ADR Auto Purge Does Not Work On All RAC Instances, ASM and Standby Databases
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.1 to 11.2]
Information in this document applies to any platform.
In your 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms