From com.banilejas@codetel.net.do Wed, 15 Aug 2001 11:41:42 -0700
From: "Ramon Estevez" <com.banilejas@codetel.net.do>
Date: Wed, 15 Aug 2001 11:41:42 -0700
Subject: RE: Lost of all Control Files
Message-ID: <F001.0036BBF2.20010815114046@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



<SPAN 
class=034303719-15082001>Nabila,
<SPAN 
class=034303719-15082001> 
I did that 
and all of them report the same error.
<SPAN 
class=034303719-15082001> 
I look in 
the DBA Manual and dont see the sintax of create controlfile command 

<SPAN 
class=034303719-15082001> 
Any 
suggestions ?
 
Ramon E. Estevez
<A 
href="mailto:com.banilejas@codetel.net.do">com.banilejas@codetel.net.do
809-565-3121

  <FONT face=Tahoma 
  size=2>-----Mensaje original-----De: root@fatcity.com 
  [mailto:root@fatcity.com]En nombre de INF/MEKKAOUIEnviado 
  el: Wednesday, 15 August, 2001 10:41 AMPara: Multiple 
  recipients of list ORACLE-LAsunto: RE: Lost of all Control 
  Files
  <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