DB= 9.2.0.8
os= Linux AS 4.
I am recovering database through RMAN by using following script:
connect target / connect rcvcat 'rman/<password>@RMAN'
run {
SET UNTIL TIME "TO_DATE('2011-02-28:14:00:00','YYYY-MM-DD:HH24:MI:SS')";
RESTORE CONTROLFILE FROM AUTOBACKUP;
restore (database);
sql 'alter database mount';
recover database;
}
But I am getting following error:
Finished restore at 01-MAR-11
sql statement: alter database mount
released channel: ORA_SBT_TAPE_1
released channel: ORA_SBT_TAPE_2
released channel: ORA_SBT_TAPE_3
released channel: ORA_SBT_TAPE_4
released channel: ORA_SBT_TAPE_5
released channel: ORA_SBT_TAPE_6
released channel: ORA_DISK_1
executing command: SET until clause
Starting recover at 01-MAR-11
allocated channel: ORA_SBT_TAPE_1
channel ORA_SBT_TAPE_1: sid=378 devtype=SBT_TAPE
channel ORA_SBT_TAPE_1: NMO v5.0.0.0
allocated channel: ORA_SBT_TAPE_2
channel ORA_SBT_TAPE_2: sid=377 devtype=SBT_TAPE
channel ORA_SBT_TAPE_2: NMO v5.0.0.0
allocated channel: ORA_SBT_TAPE_3
channel ORA_SBT_TAPE_3: sid=370 devtype=SBT_TAPE
channel ORA_SBT_TAPE_3: NMO v5.0.0.0
allocated channel: ORA_SBT_TAPE_4
channel ORA_SBT_TAPE_4: sid=371 devtype=SBT_TAPE
channel ORA_SBT_TAPE_4: NMO v5.0.0.0
allocated channel: ORA_SBT_TAPE_5
channel ORA_SBT_TAPE_5: sid=372 devtype=SBT_TAPE
channel ORA_SBT_TAPE_5: NMO v5.0.0.0
allocated channel: ORA_SBT_TAPE_6
channel ORA_SBT_TAPE_6: sid=373 devtype=SBT_TAPE
channel ORA_SBT_TAPE_6: NMO v5.0.0.0
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=374 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/01/2011 21:44:32
RMAN-06095: a backup control file must be restored to recover datafile 2
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1664927 1664928 test 4240924319 CURRENT 290118 11-OCT-06
1664927 36956808 test1 4240924319 ORPHAN 9667112526524 25-JUL-08
1664927 36956772 test1 4240924319 ORPHAN 9673237530067 07-OCT-08
Thanks for your help.