RE: Lost of all Control Files

<SPAN
class=068181717-15082001>Thanks,
<SPAN
class=068181717-15082001> 
And what is
the sintax of the create controlfile command ? <SPAN
class=068181717-15082001> 
How do I
use it ?
<SPAN
class=068181717-15082001> 
Now I will
backup them :-)
 
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 Djordje JankovicEnviado   el: Wednesday, 15 August, 2001 10:37 AMPara: Multiple   recipients of list ORACLE-LAsunto: 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 - 11:29:57 CDT