Wednesday, August 30, 2023

RMAN-08137: warning: archived log not deleted, needed for standby or upstream capture process

Issue: DR site is down permanently and disabled the log_archive_dest_state_2 on both nodes, but still archive logs are not deleting from the primary.


cause: 

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

If  you have one of V$ARCHIVE_DEST with valid_now=’UNKNOWN’ and status = ‘DEFERRED’.

Then because of Bug 16082541, we are considering DEFERRED destination applied archived logs too and hence RMAN not purging those. 

Solution:

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2 = '' SCOPE = BOTH sid='*';


After changing above parameter archive log files deleted from primary.

No comments:

Post a Comment