RE: restore/recovery

  • From: <Paula_Stankus@xxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 10 Mar 2004 14:56:26 -0500

Thanks so much for replying.
 
I also discovered it is a database that was backed up - running in archivelog 
mode - hot backup and not what I thought - a database running in noarchivelog 
mode with a cold backup so.....don't I also have to use the recover database 
command so that it brings forward all archivelogs it needs to make put database 
into a consistent state as in:
 
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')";

recover database;

sql 'alter database open resetlogs';

execute script rel_all_tapes;

}

EOD

~

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

Other related posts: