Purge TRC Files with ADRCI on a Standby Database
edited May 26, 2011 1:07AM in Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC) 7 commentsAnswered ✓
Hi all
The ADR don't purge the Trace files on our standby databases.
The physical standby databases using dataguard or dbvisit and are in mount state.
ADRCI>show control
Shows a correct short and long policy but the "Last_Autoprg_Time" is a long time ago.
So what is wrong?
Many thanks for further informations
Daniel
Retention Policy for ADR [ID 564269.1]
There are two time attributes which are used to manage the retention of informations in ADR.
Both attributes correspond to a number of hours after which the MMON (Memory Monitor) background process removes the expired ADR data:
**************************
Oracle 11.1.0.7.0 SE on Windows 2008 x64 EE
0