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



Last updated on July 17th, 2015 at 06:05 pm

Sometimes our RMAN archive log backups hit with following RMAN-06059 error.

sent command to channel: Disk1
Starting backup at 26-JAN-2000 11:04:32
current log archived
released channel: Disk1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/26/2010 11:05:30
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /u01/ABCDPR/arch/ABCDPR_434345355_1_661.arc
ORA-17503: ksfdopn:4 Failed to open file /u01/ABCDPR/arch/ABCDPR_434345355_1_661.arc
ORA-17500: ODM err:File does not exist
RMAN>

Solution:

export ORACLE_SID=ABCDPR1
MROXXX:oracle:ABCDPR1:rman target /
Recovery Manager: Release 10.2.0.4.0 – Production on Tue Dec 6 11:36:11 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: ABCDPR (DBID=XXXXX31740)
RMAN> connect rcvcat rman_username/password@XXX
connected to recovery catalog database
RMAN> crosscheck archivelog all;
RMAN > Delete noprompt archivelog expired;

Then rerun the backup again


Leave a Reply