Xref: alice comp.databases.oracle.server:20035
Path: alice!news-feed.fnsi.net!newsfeed.direct.ca!Supernews73!Supernews60!supernews.com!uunet!in3.uu.net!news1!not-for-mail
From: "John P. Higgins" <jh33378nospam@deere.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: Hot backup recovery help !
Date: Thu, 30 Apr 1998 20:21:11 -0500
Organization: Deere & Company
Lines: 48
Message-ID: <35492387.30BF@deere.com>
References: <6i990c$toa$1@nnrp1.dejanews.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Mailer: Mozilla 3.03C (Win95; U)

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@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