RE: restore/recovery

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Thu, 11 Mar 2004 15:07:41 -0500
Message-ID: <008e01c407a4$824a12a0$8459699f@vttaxnet.tax.state.vt.us>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
Paula_Stankus_at_doh.state.fl.us
  Sent: Wednesday, March 10, 2004 3:28 PM   To: oracle-l_at_freelists.org
  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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Ruth Gramolini

Sent: Wednesday, March 10, 2004 2:40 PM To: oracle-l_at_freelists.org
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_at_freelists.org

[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of
Paula_Stankus_at_doh.state.fl.us

      Sent: Wednesday, March 10, 2004 2:16 PM
      To: oracle-l_at_freelists.org
      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

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Mar 11 2004 - 16:09:03 CST