-----Original Message-----
From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Paula_Stankus@doh.state.fl.us
Sent: Wednesday, March 10, 2004 3:28 PM
To: oracle-l@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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Ruth Gramolini
Sent: Wednesday, March 10, 2004 2:40 PM
To: oracle-l@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@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Paula_Stankus@doh.state.fl.us
Sent: Wednesday, March 10, 2004 2:16 PM
To: oracle-l@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