My Oracle Support Banner

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

Last updated on JUNE 06, 2019

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 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.

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.