RE: Lost of all Control Files

[Djordje Jankovic]

If all three are corrupted, you have to run the "create controlfile" statement and to make sure that you list all your data files and redo logs.  You will loose the archiving and RMAN (if you have it) info though.

 

At least you will not forget now to backup control files regularly ;-).

 

Djordje

-----Original Message-----
From: Ramon Estevez [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 15, 2001 10:22 AM
To: Multiple recipients of list ORACLE-L
Subject: Lost of all Control Files

Hi gurus,

 

When my DB is starting I am getting an error of corrupt block in controlfile (block 1, block #1)

Ora-00202 'c:\oracle\oradata\control01.con'

Ora-00207

 

I have 3 controlfiles, no copies, sorry, shame.

 

In the init.ora I commented the line of the control file No1, then it gives me the error in the No 2, then commented line of Control No 2, and continues the error.

 

Don't know what to do. 

 

I don't have backups of the control files.

 

Saludos,

 

 

Ramon E. Estevez

[EMAIL PROTECTED]

809-565-3121