RMAN-08120 Since Upgrade To 12.1.0.2 Archive Logs Are Not Being Removed By Rman (Doc ID 2022958.1)

Last updated on AUGUST 23, 2017

Applies to:

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

Symptoms

 

12.1.0.2 archive logs are not being removed by rman.

One of the log_archive_dest_state_n has destinations that are marked DEFERED

You can run

SELECT * from v$archive_dest where (valid_now = 'UNKNOWN' AND status = 'DEFERRED') ;

o Since upgrade to 12.1.0.2 archive logs are not being removed by rman

  - Archived redo logs are backing up in the primary.
  - Archived redo logs are not being removed from the primary.
  - It says they are not applied to the standby, but they have been.
  
    RMAN-08120: WARNING: archived log not deleted, not yet applied by standby

Actions done:
-------------
o Due to this error the
   STANDBY DATABASE WAS REBUILD (from rman backup of production - duplicate for standby.)

   all went well, the standby applied the logs but still will not delete at Primary with rman backup.

Verified all logs are APPLIED at STANDBY:


o RMAN Backup of Archivelogs running at PRIMARY reports:

   RMAN-08120: WARNING: archived log not deleted, not yet applied by standby
   archived log file name=/CS_PROD/archive/CS_PROD_352644_1_714301880.arc thread=1 sequence=352644 <<<-- *)1

Changes

Upgraded from 11.2.0.3 to 12.1.0.2

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