RE: Lost of all Control Files

<SPAN
class=651300118-15082001>If  did 'alter database backup control file to trace'  prior to your control files going bad check your user dump directory.  Open that control file (it'll have .trc extension).  They syntax will be right there.  You will have to edit it deleting unnecessary info.
<SPAN
class=651300118-15082001>HTH,
<FONT
size=2>[Lyuda
Hoska] 
<SPAN
class=651300118-15082001> -----Original Message-----From: Ramon Estevez [mailto:com.banilejas_at_codetel.net.do]Sent: Wednesday, August 15, 2001 1:21 PMTo: Multiple recipients of list ORACLE-LSubject: 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