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

URGENT: Control File question - For Gurus

From: <miary_at_my-dejanews.com>
Date: Fri, 19 Mar 1999 18:29:13 GMT
Message-ID: <7cu50v$d11$1@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 - 12:29:13 CST

Original text of this message

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