RE: Lost of all Control Files

I said
if you've done it before..Otherwise you're right :-(. May be
a call Oracle support would help.

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Ramon Estevez   [mailto:com.banilejas_at_codetel.net.do]Sent: Wednesday, August 15,   2001 3:48 PMTo: Multiple recipients of list   ORACLE-LSubject: 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