RE: Lost of all Control Files

If all
three are corrupted, you have to run the "create controlfile" statement and to make sure that you list all your data files and redo logs.  You will loose the archiving and RMAN (if you have it) info though. <SPAN
class=745082714-15082001> 
At
least you will not forget now to backup control files regularly ;-).
<SPAN
class=745082714-15082001> 
<SPAN
class=745082714-15082001>Djordje
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px">
<FONT face=Tahoma

  size=2>-----Original Message-----From: Ramon Estevez   [mailto:com.banilejas_at_codetel.net.do]Sent: Wednesday, August 15,   2001 10:22 AMTo: Multiple recipients of list   ORACLE-LSubject: 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 - 10:00:57 CDT