RE: Lost of all Control Files

<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_at_codetel.net.do">com.banilejas_at_codetel.net.do 809-565-3121

  <FONT face=Tahoma
  size=2>-----Mensaje original-----De: root_at_fatcity.com   [mailto:root_at_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_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 - 13:41:42 CDT