RE: restore/recovery
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Mar 2004 14:40:03 -0500
Paula,
You must set the until time at the beginning of the restore so it will be in
place during the entire process.
HTH,
Ruth
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Wednesday, March 10, 2004 2:16 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: restore/recovery
-Solaris 2.8
-Oracle 8.0.6
Restoring - restore says it is complete but recovery keeps failing or
hanging:
connect target $TARGET@$DBNAME
run {
execute script alloc_all_tapes;
restore controlfile to '/data/oradata/CSTAT/ctrl/control01.ctl';
allocate channel d1 type disk;
replicate controlfile from '/data/oradata/CSTAT/ctrl/control01.ctl';
sql 'alter database mount';
restore database until time
"to_date('JAN 27 2004 12:00:00','MON DD YYYY HH24:MI:SS')";
sql 'alter database open resetlogs';
execute script rel_all_tapes;
}
EOD
Other related posts:
