Home » RDBMS Server » Server Administration » Automatic Diagnostic Repository (Oracle 11gR2 on AIX)
Automatic Diagnostic Repository [message #510338] Fri, 03 June 2011 14:23 Go to next message
caprikar
Messages: 226
Registered: March 2007
Senior Member
Hi,
I have a trace files under diag/rdbms/oem11g/OEM11G/trace directory starting from May 3rd, 2011. I want to purge the files older than 10days automatically and I tried to change the ADR configuration

adrci> set control (SHORTP_POLICY = 240)

I was expecting MMON to clean up the trace files and all the files older than 10 days, but I was checking for 2-days now and these trace files are not been removed.

I would appreciate if someone tell me how to automate the purge process.

Thanks
Re: Automatic Diagnostic Repository [message #510339 is a reply to message #510338] Fri, 03 June 2011 14:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
post "show control".

If it does not work as you want you can cron a job executing:
adrci exec="purge -age 14400 -type TRACE"

Regards
Michel
Re: Automatic Diagnostic Repository [message #510341 is a reply to message #510339] Fri, 03 June 2011 14:58 Go to previous message
caprikar
Messages: 226
Registered: March 2007
Senior Member
adrci> adrci> show control

ADR Home = /ora01/app/oracle/diag/rdbms/oem11g/OEM11G:
*************************************************************************
ADRID                SHORTP_POLICY        LONGP_POLICY         LAST_MOD_TIME                            LAST_AUTOPRG_TIME                        LAST_MANUPRG_TIME                        ADRDIR_VERSION       ADRSCHM_VERSION      ADRSCHMV_SUMMARY     ADRALERT_VERSION     CREATE_TIME                              
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ---------------------------------------- 
2406684394           240                  8760                 2011-06-03 15:51:20.055595 -04:00        2011-06-02 00:24:38.270480 -04:00        2011-06-03 10:52:15.502904 -04:00        1                    2                    80                   1                    2011-05-03 11:50:01.742064 -04:00       
1 rows fetched

Previous Topic: Datafile - archivelog destination?
Next Topic: Minimum datafile size
Goto Forum:
  


Current Time: Tue May 07 22:29:35 CDT 2024