Monday, October 31, 2016

RMAN-06726: could not locate archived log

oracle backup of logfiles is failing with error

RMAN-06726: could not locate archived log


Issue is that there are some expired logs which still have references in catalogue. To fix this issue the cross check

RMAN> crosscheck archivelog all;

You would notice that there are some validations of some of the files fail with  message

validation failed for archived log


After that check all expired logs

RMAN> list expired archivelog all;

and then delete all expired logs


RMAN> delete expired archivelog all;

This will ask to delete them, type yes and hit enter

Boom !!!

Issue is fixed.

Re-run the backup and it is all good.



No comments: