Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Lost of all Control Files

RE: Lost of all Control Files

From: INF/MEKKAOUI <nmekkaoui_at_lth.sonatrach.dz>
Date: Wed, 15 Aug 2001 10:20:59 -0700
Message-ID: <F001.0036B4A2.20010815074124@fatcity.com>

<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_at_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_at_codetel.net.do">com.banilejas_at_codetel.net.do   809-565-3121
    Received on Wed Aug 15 2001 - 12:20:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US