RMAN-08120- Archive Logs Are Not Being Removed By RMAN

RMAN-08120- Archive Logs Are Not Being Removed By RMAN

Error:

While deleting archive logs we are observing error as below

RMAN-08120: warning: archived log not deleted, not yet applied by standby

Solution:

When I checked the Datagaurd was in sync with primary.

But there was some old entry still pending which is no more in configuration.

Please check Destinations that are marked DEFERRED (and valid_now='UNKNOWN')

 

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

If the above query returns a row (rows), then you have some destinations that are marked DEFERRED.

Disable the log archive destination 

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_N = '' SCOPE = BOTH;

   

'n' id the dest_id for the deferred destinations

If you like please follow and comment