Skip to content

Archive for

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
ORA-19625: error identifying file D:\ORACLE\PRODUCT\10.2.0\FLASH_REC
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
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
S_714934832_5V1DN201_.BKP comment=NONE
Finished Control File and SPFILE Autobackup at 29-MAR-10.

Now backup finished.