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