Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: recovery using backup controlfile

Re: recovery using backup controlfile

From: Thomas Vanya <twvanya_at_nospameastman.com>
Date: 1997/10/22
Message-ID: <01bcdf08$79ac5200$0cdb74a6@pc88511209.tex.emn.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US