RMAN - Cuando no se encuentra un archive log --- RMAN-06726: could not locate archived log

 Lo importante en todo esto, es estar dentro del catalogo correspondiente, sino el crosscheck NO FNCIONA !!

 

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




Issue is fixed.

Re-run the backup and it is all good.