ADR Auto Purge Does Not Work On All RAC Instances, ASM and Standby Databases
(Doc ID 1326983.1)
Last updated on MAY 19, 2021
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.1 to 11.2]
Information in this document applies to any platform.
In a RAC multi-nodes environment, auto purge is working correctly on one instance but has not run for a couple of weeks on the other instances.
The same issue happens in ASM and standby database instances.
According to <Document 975448.1>, it should run as an MMON slave task on a weekly-basis (once in 7 days).
As every instance has it's own MMON process, we expect every instance to auto purge on a weekly basis.
In other words, why did ADR Auto Purge not run for over 1 month on 1 of your RAC instance.
LAST_AUTOPRG_TIME returned by adrci command "show control" is over 1 month in the past.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document