RE: Lost of all Control Files

[INF/MEKKAOUI]

hi,

if you have 3 controlfiles (it means that you have two copies of your controlfile), so if there is a problem with one controlfile, you had to change the parameter control_files in the init.ora so that you eliminate the corrupted file.

 

 

Best Regards,

Nabila Mekkaoui

DBA Oracle

-----Message d'origine-----
De : Ramon Estevez [mailto:[EMAIL PROTECTED]]
Envoy� : mercredi 15 ao�t 2001 14:22
� : Multiple recipients of list ORACLE-L
Objet : 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