From nmekkaoui@lth.sonatrach.dz Wed, 15 Aug 2001 10:20:59 -0700
From: INF/MEKKAOUI <nmekkaoui@lth.sonatrach.dz>
Date: Wed, 15 Aug 2001 10:20:59 -0700
Subject: RE: Lost of all Control Files
Message-ID: <F001.0036B4A2.20010815074124@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



<SPAN 
class=644383015-15082001>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.
<SPAN 
class=644383015-15082001> 
 
Best Regards,
Nabila Mekkaoui
DBA Oracle

  <FONT face=Tahoma 
  size=2>-----Message d'origine-----De : Ramon Estevez 
  [mailto:com.banilejas@codetel.net.do]Envoyé : mercredi 15 août 
  2001 14:22À : Multiple recipients of list 
  ORACLE-LObjet : Lost of all Control Files
  Hi 
  gurus,
  <SPAN 
  class=902011014-15082001> 
  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 
  
  <SPAN 
  class=902011014-15082001> 
  I have 3 controlfiles, 
  no copies, sorry, shame.
  <SPAN 
  class=902011014-15082001> 
  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.
  <SPAN 
  class=902011014-15082001> 
  Don't know what to 
  do.  
  <SPAN 
  class=902011014-15082001> 
  I don't have backups of 
  the control files.
  <SPAN 
  class=902011014-15082001> 
  <SPAN 
  class=902011014-15082001>Saludos,
   
   
  Ramon E. Estevez
  <A 
  href="mailto:com.banilejas@codetel.net.do">com.banilejas@codetel.net.do
  809-565-3121