Hot backup recovery help !

Hi,

I am currently running Oracle Workgroups Server V7.3.3 on Windows NT 4.0. I have a test database that I want to simulate disaster recovery using online backups. The steps that my online backup scripts is performing are:

1. archive log list ;
2. alter tablespace tablespace_name begin backup ;
3. host ocopy73 datafile dest_directory
4. alter tablespace tablespace_name end backup ;
5. Repeat steps 2-4 for other tablespaces
6. alter system switch logfile ;
7. alter database backup controlfile to dest_controlfile ;

The database is in ARCHIVELOG mode.
I then shutdown the database and delete all datafiles, control files, and online redo log files. Next I restore the online backups and do the following:

1. startup the database in mount mode
2. recover database until cancel using backup controlfile ;

What happens next is that it asks for an archive log file that I do not have. If I try and cancel, it returns with a "media recovery canceled" message. If I try and open the database using resetlogs, it says that one of the data files requires media recovery.

Has anyone come across this problem or know what the solution is?

I have also included in my script to do an ocopy of the control file and online redo log file and if I use these for recovery, it works okay but I have read in the Backup & Recovery book from Oracle Press that this will cause corruptions.

TIA William

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 30 1998 - 03:24:58 CDT