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