Re: URGENT: Control File question - For Gurus

Van Messner is right. Jurij gave you the straight scoop. I've had this happen before and the procedure Jurij describes does work. BTW, it doesn't hurt to occasionally use the command "ALTER DATABASE BACKUP CONTROLFILE TO TRACE" and archive off somewhere the .TRC file generated (maybe onto a floppy kept in your briefcase - it's really small). Within this file is the complete CREATE CONTROLFILE statement needed to create all your controlfiles from scratch as well as your REDO log files.

Allan

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 Sun Mar 21 1999 - 11:40:10 CST