Skip to main content

RMAN-06059 expected archived log not found

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/09/2012 13:43:10
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability

ORA-19625: error identifying file /fra/arch/1_49515_728281252.dbf
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

This is mostly because some archive log files are deleted. If you can not find the file expected then crosscheck archivelogs. After crosscheck do not forget to perform a full backup.

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


Popular posts from this blog

Find and replace with sed command in Linux

Find and replace feature is always handy. It can turn into a torture when it comes to change or delete a simple constant string in a text file. There is a handy tool in linux for doing these kind of tihngs. Actually sed is not a text editor but it is used outside of the text file to make changes.