Re: Hot backup recovery help !

Try this after the startup mount:

recover database;

You don't use the 'using backup controlfile' unless the control file is from prior to the latest backup.

william_t_lee_at_hotmail.com wrote:
>
> 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 - 20:21:11 CDT