RE: Lost of all Control Files

Hi
Lyuda,
<SPAN
class=053164019-15082001> 
Alter
database backup controlfile to trace doesn't work because the DB doesn't mount. :-(
<SPAN
class=053164019-15082001> 
<SPAN
class=053164019-15082001> 
 
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   lhoska_at_calibresys.comEnviado el: Wednesday, 15 August, 2001   2:01 PMPara: Multiple recipients of list ORACLE-LAsunto:   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


      <SPAN 

      class=745082714-15082001>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> 


      <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