Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: URGENT: Control File question - For Gurus
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