RE: restore/recovery

  • From: "Ruth Gramolini" <rgramolini@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 12 Mar 2004 12:00:15 -0500

If you are in 9i is is much easier to use rman for everything.  But when I
was in 8.0.6.3 recovery  from svrmgrl was usually necessary.  recover
database using backup controfile until time or until cancel. Rman has grown
up since those days.

Ruth

  -----Original Message-----
  From: oracle-l-bounce@xxxxxxxxxxxxx
  [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of DENNIS WILLIAMS
  Sent: Wednesday, March 10, 2004 2:57 PM
  To: 'oracle-l@xxxxxxxxxxxxx'
  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@xxxxxxxxxxxxx

  -----Original Message-----
  From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On
Behalf Of Paula_Stankus@xxxxxxxxxxxxxxx
Sent: Wednesday, March 10, 2004 1: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

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: