Monday 10 December 2018

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

RMAN Backup failed.


After Deleting Archive log files in the filesystem, RMAN backup getting failed with below error.


RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/09/2018 03:13:49
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /oracle/product/12102/fast_recovery_area/archivelog/2018_12_07/o1_mf_1_5632_g0n1o2vv_.arc
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3




Solution:





RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;


After the expired backup command, started run the RMAN backup and check.

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

RMAN Backup failed. After Deleting Archive log files in the filesystem, RMAN backup getting failed with below error. RMAN-00571: ======...