If the necessary redo logs, whether online or archived, are not available
then incomplete or cancel-based recover is necessary. Also, when doing
recovery using BACKUP CONTROLFILE you will then have to do ALTER DATABASE
OPEN RESETLOGS and should take a full backup of the database. I have also
found that you MUST have ALL redo logs associated with a hot backup if you
are restoring a hot backup of a database. Fortunately I discovered this
when building a Year 2000 test system using hot backup files. I could not
recover the database until I also had access to the redo logs that spanned
the time of the backup.
--
Thomas W. Vanya
Oracle and OracleRdb Database Administrator
Eastman Chemical Company
-------------------------------------------------------------------------
(Due to proliferation of spammers, remove nospam from address.)
Chuck Hamilton <see_bottom_at_of_msg.com> wrote in article
<344efb60.4031075_at_news.dvol.com>...
> I've recently been testing database recover using a backup control
> file (RECOVER DATABASE USING BACKUP CONTROLFILE). At the end of
> recovering, Oracle always asks for an archive log that doesn't exist.
> Is this normal? What I end up having to do each time is cancel based
> recovery (RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL).
> --
> Chuck Hamilton
> Oracle DBA
> QVC Inc.
>
> In an effort to reduce spam my return address has been changed.
> Reply to chuck_hamilton at qvc dot com
>
> Never share a foxhole with anyone braver than yourself!
>
>
Received on Wed Oct 22 1997 - 00:00:00 CDT
