Sometimes our RMAN archive log backups hit with following RMAN-06059 error.
Here is what we could do to resolve this issue.
sent command to channel: t1
Starting backup at 06-dec-2011 11:04:32
current log archived
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 12/06/2011 11:05:30
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /arch/ppos/arch/ppos_712666108_1_20221.arc
ORA-17503: ksfdopn:4 Failed to open file /arch/ppos/arch/ppos_712666108_1_20221.arc
ORA-17500: ODM err:File does not exist
RMAN>
Here is what we could do to resolve this issue.
export ORACLE_SID=ppos1
prdposx501:oracle:ppos1:/orasw/static/oradba/bin/rman: 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: PPOS (DBID=XXXXX31740)
RMAN> connect rcvcat rman_username/password@PRRMAN
connected to recovery catalog database
RMAN> crosscheck archivelog all;
