RMAN Is Not Reporting Old Archive Log Files As Obsolete (Doc ID 1936141.1)

Last updated on OCTOBER 18, 2019

Applies to:

Symptoms

Archive logs are backed up using this RMAN command:
backup as copy format '/mnt/oralogs2/$ORACLE_SID/%U' archivelog like '+LOG%' delete input;

.....

delete force noprompt obsolete;

This is the retention policy:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1;

The database and archivelogs are backed up every three days.  Backups are only run on the primary database.

Archivelog copies that are almost two months old are not being recognized as obsolete.

This is a primary, standby environment with an archivelog destination directing log_archive_dest_2 to archive to the standby database.

Changes

The standby database has been down for quite some time. 

Cause

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