Custom Search . . .

Sunday, May 2, 2010

RMAN-06555: datafile 1 must be restored from backup created before 01-MAY-10

RMAN> recover database until time="TO_DATE('2010-05-01 1300:00','YYYY-MM-DD HH24:MI:SS')";


Starting recover at 01-MAY-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=150 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/01/2010 15:19:10
RMAN-06555: datafile 1 must be restored from backup created before 01-MAY-10


The  above error got during database recover stage. Because of this i tried with different point in time


RMAN> shutdown immediate


database dismounted
Oracle instance shut down




RMAN>  run
2> {
3> startup mount
4> allocate channel c1 type disk;
5> allocate channel c2 type disk;
6> set until time="TO_DATE('2010-05-01 14:40:00','YYYY-MM-DD HH24:MI:SS')";
7> restore database;
8> recover database;
9> }


database is already started


allocated channel: c1
channel c1: SID=154 device type=DISK


allocated channel: c2
channel c2: SID=153 device type=DISK


executing command: SET until clause


Starting restore at 01-MAY-10


channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00003 to F:\ORACLE\PRODUCT\11.0.1\ORADATA\ORCL\DATA\UNDOTBS01.DBF
channel c1: restoring datafile 00004 to F:\ORACLE\PRODUCT\11.0.1\ORADATA\ORCL\DATA\USERS01.DBF
channel c1: reading from backup piece I:\BACKUP\ORCL\ORCL_20100501_04LCJA23_S4_P1
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00001 to F:\ORACLE\PRODUCT\11.0.1\ORADATA\ORCL\DATA\SYSTEM01.DBF
channel c2: restoring datafile 00002 to F:\ORACLE\PRODUCT\11.0.1\ORADATA\ORCL\DATA\SYSAUX01.DBF
channel c2: restoring datafile 00005 to F:\ORACLE\PRODUCT\11.0.1\ORADATA\ORCL\DATA\TEST010_2.DBF
channel c2: reading from backup piece I:\BACKUP\ORCL\ORCL_20100501_03LCJA23_S3_P1
channel c1: piece handle=I:\BACKUP\ORCL\ORCL_20100501_04LCJA23_S4_P1 tag=TAG20100501T131443
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:45
channel c2: piece handle=I:\BACKUP\ORCL\ORCL_20100501_03LCJA23_S3_P1 tag=TAG20100501T131443
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:01:05
Finished restore at 01-MAY-10


Starting recover at 01-MAY-10


starting media recovery


channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=72
channel c1: reading from backup piece I:\BACKUP\ORCL\ORCL_ARCH_20100501_07LCJA81_S7_P1
channel c1: piece handle=I:\BACKUP\ORCL\ORCL_ARCH_20100501_07LCJA81_S7_P1 tag=TAG20100501T131550
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:01
archived log file name=D:\ARCHIVELOG\ORCL\ORCL_ARC00072_0715935770.001 thread=1 sequence=72
unable to find archived log
archived log thread=1 sequence=73
released channel: c1
released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/01/2010 15:28:25
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 73 and starting SCN of 1178194

Even still i got different error message. The sequence 73 archive log file not in my archive log destination but still it's asking archive log file. 

I guess there is no way for medio recovery with this archive log. I just try to open the database with resetlog it's working fine. :)..

Share me with your feedback/suggestions. Thanks 

No comments: