ADR Auto Purge Not Working In ASM Instance

(Doc ID 1191704.1)

Last updated on NOVEMBER 28, 2016

Applies to:

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

Symptoms

 

ADR Auto Purge Not Working In ASM Instance
1. Initial information : SHORTP_POLICY=720 hr =30days.

adrci> set homepath diag/asm/+asm/+ASM1
adrci> show control
.
ADR Home = /u01/app/oracle/diag/asm/+asm/+ASM1:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME
LAST_AUTOPRG_TIME
LAST_MANUPRG_TIME ADRDIR_VERSION
ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION
CREATE_TIME
-------------------- -------------------- --------------------
1424334487 720 8760 2010-02-17
13:18:27.929615 +09:00
1
2 76 1
2010-02-17 13:18:27.929615 +09:00
1 rows fetched


2. Change policy interval as 1hr as of March 4 12:27 pm.

adrci> set control (SHORTP_POLICY = 1)
adrci> set control (LONGP_POLICY = 1)
adrci> show control
.
ADR Home = /u01/app/oracle/diag/asm/+asm/+ASM1:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME
LAST_AUTOPRG_TIME
LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION
ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- --------------------
1424334487 1 1 2010-03-04
12:15:01.023465 +09:00
1 2
76 1 2010-02-17 13:18:27.929615 +09:00

1 rows fetched


3. LAST_AUTOPRG_TIME was not changed as of Mar 17 10:39:49.

adrci> show control
.
ADR Home = /u01/app/oracle/diag/asm/+asm/+ASM1:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME

LAST_AUTOPRG_TIME LAST_MANUPRG_TIME
AD RDIR_VERSION
ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- --------------------
1424334487 1 1 2010-03-04
12:15:01.023465 +09: 00
1
2
76 1 2010-02-17 1
3:18:27.929615 +09:00

Changes



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