Skip to content
Advertisements

RMAN-06059: expected archived log not found

When i try to take backup of archive log all using rman, it shows below error.

RMAN-00571: ========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ============
RMAN-00571: ========================================================
RMAN-03002: failure of backup command at 03/29/2010 12:20:05
RMAN-06059: expected archived log not found, lost of archived log co
coverability
ORA-19625: error identifying file D:\ORACLE\PRODUCT\10.2.0\FLASH_REC
ROKER\ARCHIVELOG\2010_03_25\O1_MF_1_257_5TQF22HV_.ARC
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Here what was the problem is, I was moved the archive log file using cut & paste when FRA location is fulled and then i changed the archive log destination also.In this case when i try to take backup of archive log ,the controlfile will search the oldest file on same location but it was missed, so that the system cannot find the file specified.

But i don’t want previous backup archive log.SO i try to fix following steps,Its ok now.

Step 1:

rman>crosscheck archivelog all;

Step 2:

rman>delete expired archivelog all;

Step 3:

rman>backup archivelog all;

input archive log thread=1 sequence=647 recid=400 stamp=714934627
channel ORA_DISK_1: starting piece 1 at 29-MAR-10
channel ORA_DISK_1: finished piece 1 at 29-MAR-10
piece handle=H:\RMAN\BROKER\BROKER714934764_S14_S1 tag=TAG20100329T165708 commen
t=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:07
Finished backup at 29-MAR-10

Starting Control File and SPFILE Autobackup at 29-MAR-10
piece handle=D:\ORACLE\PRODUCT\FLASHRECOVERY\BROKER\AUTOBACKUP\2010_03_29\O1_MF_
S_714934832_5V1DN201_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 29-MAR-10.

Now backup finished.

Advertisements
No comments yet

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

%d bloggers like this: