Wednesday, October 2, 2013

RMAN-06059: expected archived log not found, during RMAN archivelog bakup.

ERROR:

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file D:\ORACLE\ORCL\ARC000044_3173.0001
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Issue:



Looks like Archivelogs deleted before they backup.Might be someone tried to create space for Archivelogs for production environment whitout taking Archivlogs backups.


Fix :

Connect to RMAN and run the following commands and make sure after this you have a good backup.

RMAN target /

RMAN>CROSSCHECK ARCHIVELOG ALL;
validation succeeded for archived log
archived log file name=D:\ORACLE\ORCL\ARC000044_3173.0001


The above will mark archivelogs in controlfile or in catalog as expired, which do not exists in OS and RMAN don't need them for future recovery.


RMAN>DELETE EXPIRED ARCHIVELOG ALL;

445852  1    445857  X 01-OCT-11
        Name: D:\ORACLE\ORCL\ARC000044_3173.0001


Do you really want to delete the above objects (enter YES or NO)?yes

RMAN>


This will delete previously marked entries as expired from controlfile or catalog. Make sure you have a good backup after this.