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: URGENT: Control File question - For Gurus

Re: URGENT: Control File question - For Gurus

From: Van Messner <vmessner_at_netaxis.com>
Date: Fri, 19 Mar 1999 19:52:05 -0500
Message-ID: <_nCI2.3370$mZ6.9859@news7.ispnews.com>


You got two somewhat different answers. Jurij is right.

Van

miary_at_my-dejanews.com wrote in message <7cu50v$d11$1_at_nnrp1.dejanews.com>...
>To the Gurus: Someone confirm/rectify these statements for me (database is
in
>archivelog mode): 1) If you loose ALL your control files (I know, very
>unlikely but just for the sake of the argument and to try to understand the
>concept), the only way out is to retrieve a backup control file and perform
>an incomplete recovery. 2) If you have an older control file, you cannot
just
>apply archive logs generated after the loss of control files to update the
>status of your database to the status of your log files. The SCN in the
>control file is what determines up to which stage you can restore your
>database. So with an older control file (from a backup for instance), the
>only solution is an incomplete recovery. Answer needed urgently for tests
>that we are currently conducting. In advance, thanks. Miary.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Mar 19 1999 - 18:52:05 CST

Original text of this message

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