RE: restore/recovery
- From: <Paula_Stankus@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Mar 2004 14:16:13 -0500
-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:
