RE: restore/recovery
- From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Mar 2004 15:07:41 -0500
Right, right after the run { in the run block. At least that is what I was
told, and what I have done. Especially since 9i, if you don't tell rman when
you want to go back to, he will just blithely restore the most current
version, even if you have an until time after the restore.
Regards,
Ruth
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Wednesday, March 10, 2004 3:28 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: restore/recovery
Ruth,
You mean before the restore of the controlfile to ensure all pieces are
in-synch - correct?
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Ruth Gramolini
Sent: Wednesday, March 10, 2004 2:40 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: restore/recovery
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:
