Mani's Blog

September 1, 2011

Oracle: RMAN-06059: expected archived log not found

Filed under: Oracle — mani @ 11:08 pm

I scheduled a full backup that includes archive logs that are not backed up yet.   I ran into error

RMAN> backup device type disk tag '%s' archivelog all not backed up;
Starting backup at 01-SEP-11
current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 09/01/2011 22:46:30
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file %s.arc
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

It is okay, I don’t want to take archive logs that are missing now.

Solution: connect to RMAN and run “change archivelog all crosscheck;”  this fixed the issue.

RMAN> change archivelog all crosscheck;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1041 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=1060 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=1057 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=1087 device type=DISK
validation succeeded for archived log
archived log file name=/local/opt/oracle/product/11.1.0/db_1/dbs/arch1_115_717451798.dbf RECID=115 STAMP=725994293
validation succeeded for archived log
archived log file name=/local/opt/oracle/product/11.1.0/db_1/dbs/arch1_116_717451798.dbf RECID=116 STAMP=725994356
validation succeeded for archived log
archived log file name=/local/opt/oracle/product/11.1.0/db_1/dbs/arch1_117_717451798.dbf RECID=117 STAMP=725994358
validation succeeded for archived log
archived log file name=/local/opt/oracle/product/11.1.0/db_1/dbs/arch1_1399_717451798.dbf RECID=118 STAMP=760657462
validation succeeded for archived log
archived log file name=/local/opt/oracle/product/11.1.0/db_1/dbs/arch1_1400_717451798.dbf RECID=119 STAMP=760742780
validation succeeded for archived log
archived log file name=/local/data/oracle/nfs/XNB3CORE/archivelog/2011_09_01/o1_mf_1_1401_7602bmxc_.arc RECID=120 STAMP=760747092
validation succeeded for archived log
archived log file name=/local/data/oracle/nfs/XNB3CORE/archivelog/2011_09_01/o1_mf_1_1402_7602dlgm_.arc RECID=121 STAMP=760747154
Crosschecked 7 objects

validation failed for archived log
archived log file name=/local/opt/oracle/product/11.1.0/db_1/dbs/arch1_1_717451798.dbf RECID=1 STAMP=717457431
validation failed for archived log
archived log file name=/local/opt/oracle/product/11.1.0/db_1/dbs/arch1_2_717451798.dbf RECID=2 STAMP=718149657
validation failed for archived log
archived log file name=/local/opt/oracle/product/11.1.0/db_1/dbs/arch1_3_717451798.dbf RECID=3 STAMP=718477282
validation failed for archived log
archived log file name=/local/opt/oracle/product/11.1.0/db_1/dbs/arch1_4_717451798.dbf RECID=4 STAMP=718763012
………

Crosschecked 114 objects

RMAN>

Advertisements

Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: