Incomplete Recovery Query

Hi ,

I am doing Incomplete Recovery of my database.

I had taken the backup of Control file, Datafile & Archive File in ArchiveLog Mode using backup command Backup database plus archivelog;

Now I am doing following steps in restore operation.

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

RMAN> connect target/

connected to target database: DBCHECK (DBID=1335762160)

RMAN> shutdown immediate;

using target database controlfile instead of recovery catalog

database closed

database dismounted

Oracle instance shut down

RMAN> startup nomount;

connected to target database (not started)

Oracle instance started

Total System Global Area 730931140 bytes

Fixed Size 454596 bytes

Variable Size 285212672 bytes

Database Buffers 444596224 bytes

Redo Buffers 667648 bytes

RMAN> restore controlfile from 'E:\TempDest\CTL_C-1335762160-20061010-01';

Starting restore at 10-OCT-06

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=11 devtype=DISK

channel ORA_DISK_1: restoring controlfile

channel ORA_DISK_1: restore complete

replicating controlfile

input filename=D:\ORACLE\ORADATA\DBCHECK\CONTROL01.CTL

output filename=D:\ORACLE\ORADATA\DBCHECK\CONTROL02.CTL

output filename=D:\ORACLE\ORADATA\DBCHECK\CONTROL03.CTL

Finished restore at 10-OCT-06

RMAN> startup mount;

database is already started

database mounted

RMAN> run

{

allocate channel ch1 type disk;

set until time "to_date('Oct 10 2006 18:27:00','Mon DD YYYY HH24:MI:SS')";

restore database;

recover database;

}

released channel: ORA_DISK_1

allocated channel: ch1

channel ch1: sid=11 devtype=DISK

executing command: SET until clause

Starting restore at 10-OCT-06

channel ch1: starting datafile backupset restore

channel ch1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to D:\ORACLE\ORADATA\DBCHECK\SYSTEM01.DBF

restoring datafile 00002 to D:\ORACLE\ORADATA\DBCHECK\UNDOTBS01.DBF

restoring datafile 00003 to D:\ORACLE\ORADATA\DBCHECK\CWMLITE01.DBF

restoring datafile 00004 to D:\ORACLE\ORADATA\DBCHECK\DRSYS01.DBF

restoring datafile 00005 to D:\ORACLE\ORADATA\DBCHECK\EXAMPLE01.DBF

restoring datafile 00006 to D:\ORACLE\ORADATA\DBCHECK\INDX01.DBF

restoring datafile 00007 to D:\ORACLE\ORADATA\DBCHECK\ODM01.DBF

restoring datafile 00008 to D:\ORACLE\ORADATA\DBCHECK\TOOLS01.DBF

restoring datafile 00009 to D:\ORACLE\ORADATA\DBCHECK\USERS01.DBF

restoring datafile 00010 to D:\ORACLE\ORADATA\DBCHECK\XDB01.DBF

channel ch1: restored backup piece 1

piece handle=E:\TEMPDEST\STD_0DHVGRQ6_1_1 tag=TAG20061010T182614 params=NULL

channel ch1: restore complete

Finished restore at 10-OCT-06

Starting recover at 10-OCT-06

starting media recovery

archive log thread 1 sequence 8 is already on disk as file D:\ORACLE\ORA92\RDBMS

\ARC00008.001

archive log filename=D:\ORACLE\ORA92\RDBMS\ARC00008.001 thread=1 sequence=8

media recovery complete

Finished recover at 10-OCT-06

released channel: ch1

RMAN> alter database open resetlogs;

database opened

RMAN>

Its working fine uptil now...

But when i had use this backup set once again to restore. it is not working for me it is giving following error to me...

RMAN> run

{

allocate channel ch1 type disk;

set until time "to_date('Oct 10 2006 18:27:00','Mon DD YYYY HH24:MI:SS')";

restore database;

recover database;

}

allocated channel: ch1

channel ch1: sid=11 devtype=DISK

executing command: SET until clause

released channel: ch1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of set command at 10/10/2006 19:27:59

RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time

I heard somewhere that it will works if u take backup once again.. Why it is so?

Can any help me out this..

http://oracle.itags.org/q_oracle_119016.html