From dgoulet@vicr.com Wed, 15 Aug 2001 09:36:07 -0700 From: dgoulet@vicr.com Date: Wed, 15 Aug 2001 09:36:07 -0700 Subject: Re:RE: Lost of all Control Files Message-ID: MIME-Version: 1.0 Content-Type: text/plain I've stayed out of this one up till now. But based on the original I assume that all of the control files where on the same disk drive & directory. Bad idea. If you have a problem with the drive and/or controller then you've been had. Place the control files on multiple spindles that are preferably on different controllers. And periodically, like at every shutdown, run the 'alter database backup controlfile to trace' command. It would even be a good thing to occasionally issue 'alter database backup controlfile to '. Dick Goulet ____________________Reply Separator____________________ Author: INF/MEKKAOUI Date: 8/15/2001 7:41 AM 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:com.banilejas@codetel.net.do] Envoyé : mercredi 15 août 2001 14:22 A : 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 com.banilejas@codetel.net.do 809-565-3121
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:com.banilejas@codetel.net.do]
Envoyé : mercredi 15 août 2001 14:22
A : 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
809-565-3121
 
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet@vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).