My Oracle Support Banner

ADR Files are not purged automatically (Doc ID 2572977.1)

Last updated on MARCH 26, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

  1. Oracle background process MMON is no longer purging automatically adrci files.
  2. LAST_AUTOPRG_TIME from ADR_CONTROL is not updated and has an old data.

    adrci> SELECT * FROM ADR_CONTROL;

    ADR Home = /u01/app/oracle/diag/rdbms/<dbname>/<instname>:
    *************************************************************************
    ADRID                SHORTP_POLICY        LONGP_POLICY         LAST_MOD_TIME
                              LAST_AUTOPRG_TIME                      
    LAST_MANUPRG_TIME                        ADRDIR_VERSION       ADRSCHM_VERSION
         ADRSCHMV_SUMMARY     ADRALERT_VERSION     CREATE_TIME
    -------------------- -------------------- --------------------
    ----------------------------------------
    ----------------------------------------
    ---------------------------------------- --------------------
    -------------------- -------------------- --------------------
    ----------------------------------------
    1971218730           720                  720                  2018-12-07  14:07:10.156481 +01:00        
    2019-02-09 14:28:12.565844 +01:00                                                                      ---> this is an old data
    2019-05-14 07:01:23.903722 +02:00        1                    2              
         107                  1                    2018-12-07 14:03:49.632211
    +01:00
    1 row fetched
  3. However manual purge of adr files is working , but is slow.

Changes

 

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