RE: restore/recovery

  • From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 10 Mar 2004 13:57:25 -0600

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

Dennis Williams
Lifetouch, Inc.

-----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
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;



Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at //
FAQ is at //

Other related posts: