HowTO Fix: RMAN-06059: expected archived log not found

While doing an RMAN backup of archivelogs i got this error:

RMAN-06059: expected archived log not found

Starting backup at 04-JAN-10

current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
archived log /arch_log_1/oracle/flash_recovery_area/CCASDB/archivelog/2009_10_12/o1_mf_1_16634_5f6do36m_.arc not found or out of sync with catalog
trying alternate file for archivelog thread 1, sequence 16634
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 01/04/2010 21:57:42
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /d1/oracle/ccasarch/1_16634_591737821.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


To fix, perform a crosscheck. To perform a crosscheck, run the following command from within RMAN:

rman> change archivelog all crosscheck;

Do a full backup of the database at this point.

Archive log crosscheck, checks each archive log to make sure that it exists on disk (or tape). Those that are missing are marked as unavailable. If you have got missing logs, this won’t bring them back. It will allow you to get past this error and back-up the database though.


About this entry