RMAN-08120 Since Upgrade To 12.1.0.2 Archive Logs Are Not Being Removed By Rman
Last updated on AUGUST 23, 2017
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
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