ADR Auto Purge Does Not Work On All RAC Instances, ASM and Standby Databases (Doc ID 1326983.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

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.

Cause

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