RE: restore/recovery

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Fri, 12 Mar 2004 12:02:02 -0500
Message-ID: <011001c40853$bd8f7620$8459699f@vttaxnet.tax.state.vt.us>

With 9i, it should. Just be sure that you have all the ones you think you need. On 8.0.6.3 you had to restore them separately before applying them with a restore archivelog all or restore archivelog from logseq xxx until logseq yyy thread N.

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:09 PM   To: oracle-l_at_freelists.org
  Subject: RE: restore/recovery

I don't think that is quite true. If your system admin. blows the box away and you are doing a restore - so no online redo - then without using recover database you don't get the archivelog files restored for recovery unless you restore the archivelog files separate - right? My thought was that recover database in this cause would restore necessary archive files.

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org
  [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DENNIS WILLIAMS   Sent: Wednesday, March 10, 2004 2:57 PM   To: 'oracle-l_at_freelists.org'
  Subject: RE: restore/recovery

  Paula - If RMAN recovery encounters problems, I exit RMAN and   just log into
  Oracle (svrmgrl in 8i, sqlplus in 9i) and perform the recovery there. I   believe that for recovery RMAN is just issuing the same commands to the   RDBMS.   Dennis Williams
  DBA
  Lifetouch, Inc.
  dwilliams_at_lifetouch.com

-----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 1: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


-----------------------------------------------------------------

----------------------------------------------------------------

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

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 Fri Mar 12 2004 - 10:58:08 CST