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