RE: diag/rdbms alert files
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <Freek.DHooge@xxxxxxxxx>, <stellr@xxxxxxxxxx>
- Date: Tue, 7 Dec 2010 07:22:51 -0500
Thanks. I got a script specifically for the alert files in the trace directory
running from cron on weekends.
But this does prompt me for any other that might not be covered by adrci. It's
a wonder I found adrci in the first place. (Can't say the manuals are my first
thing I read, my bad. I'm into about four books now instead, mainly math for
DB professionals at the moment... and that one has homework).
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: D'Hooge Freek [mailto:Freek.DHooge@xxxxxxxxx]
Sent: Tuesday, December 07, 2010 6:20 AM
To: Patterson, Joel; stellr@xxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: diag/rdbms alert files
Not all logfiles are purged by adrci:
Adrci Purge Does Not Clear the Text-formatted Alert.Log located in the Trace
Folder [ID 751082.1]
Regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
email: freek.dhooge@xxxxxxxxx
tel +32(0)3 451 23 82
http://www.uptime.be
disclaimer: www.uptime.be/disclaimer
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Joel.Patterson@xxxxxxxxxxx
Sent: maandag 6 december 2010 21:33
To: stellr@xxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: diag/rdbms alert files
Thanks, fast. After days, you would think SR would have directed me at least
to here?
Anyway, any other comments or gotchas or practices are gladly accepted.
I'll look closer, 1 year is not really what I wanted for all files... I got a
log of trace file for instance.
Sounds like I might have a different approach than the old one with unix
commands and cron.
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: Ray Stell [mailto:stellr@xxxxxxxxxx]
Sent: Monday, December 06, 2010 3:10 PM
To: Patterson, Joel
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: diag/rdbms alert files
adr
http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/adrci.htm#sthref1961
On Mon, Dec 06, 2010 at 03:02:27PM -0500, Joel.Patterson@xxxxxxxxxxx wrote:
>
> Does anyone keep say 30 days worth of data in the new 11g Architecture?
>
> Example:
> find ${ORACLE_BASE}/diag/rdbms -name "* .trc" -type f -atime
> -{NUMBER_KEEPDAYS} -exec ls -ltr {} \; (or xargs instead of exec)
>
> *.trc *.trm *.ams *.stg *.mif *.ir
>
> Could you just blanket remove all files, (or do the six file types
> specifically)? I created an SR once for this and essentially the analyst
> said yes. However, I'd like a second opinion as I am not sure of all the
> file types yet.
>
> For instance in alert/log.xml appears to rotate at 1M, but is there any
> cleanup to purge old files?
>
> Etc. wondering what the rest of the community is doing in this regard.
>
>
> Joel Patterson
> Database Administrator
> 904 727-2546
>
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
