RE: diag/rdbms alert files
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <mdinh@xxxxxxxxx>, <stellr@xxxxxxxxxx>
- Date: Tue, 7 Dec 2010 08:52:06 -0500
I remember adrci now and meant to come back to it later. Didn't realize it
would purge all the files (except some like trace alert log). So thx.
1) Do most people just let the LONGP_POLICY stay at one year and not bother?
If I set it to something like 1440 I'd have to do it for every database
(individually)... or I could just forget about it.
2) If I'm taking care of my alert log (in trace dir) manually, do I also need
to manually take care of the listener_logs in the tnslsnr/.../.../trace dir
manually (in the same way I do for 10g, 9i, 8i...)?
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: Michael Dinh [mailto:mdinh@xxxxxxxxx]
Sent: Monday, December 06, 2010 3:39 PM
To: Patterson, Joel; stellr@xxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: diag/rdbms alert files
You can also set policy for short term and long term duration.
set control (SHORTP_POLICY = 720)
set control (LONGP_POLICY = 2160)
Michael Dinh
NOTICE OF CONFIDENTIALITY - This material is intended for the use of the
individual or entity to which it is addressed, and may contain information that
is privileged, confidential and exempt from disclosure under applicable laws.
BE FURTHER ADVISED THAT THIS EMAIL MAY CONTAIN PROTECTED HEALTH INFORMATION
(PHI). BY ACCEPTING THIS MESSAGE, YOU ACKNOWLEDGE THE FOREGOING, AND AGREE AS
FOLLOWS: YOU AGREE TO NOT DISCLOSE TO ANY THIRD PARTY ANY PHI CONTAINED HEREIN,
EXCEPT AS EXPRESSLY PERMITTED AND ONLY TO THE EXTENT NECESSARY TO PERFORM YOUR
OBLIGATIONS RELATING TO THE RECEIPT OF THIS MESSAGE. If the reader of this
email (and attachments) is not the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this communication is
strictly prohibited. Please notify the sender of the error and delete the
e-mail you received. Thank you.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Joel.Patterson@xxxxxxxxxxx
Sent: Monday, December 06, 2010 12:33 PM
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:
