From com.banilejas@codetel.net.do Wed, 15 Aug 2001 13:25:21 -0700
From: "Ramon Estevez" <com.banilejas@codetel.net.do>
Date: Wed, 15 Aug 2001 13:25:21 -0700
Subject: RE: Lost of all Control Files
Message-ID: <F001.0036C0E5.20010815132033@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain



<SPAN 
class=578380821-15082001>tks
<SPAN 
class=578380821-15082001> 
 
Ramon E. Estevez
<A 
href="mailto:com.banilejas@codetel.net.do">com.banilejas@codetel.net.do
809-565-3121

  <FONT face=Tahoma 
  size=2>-----Mensaje original-----De: root@fatcity.com 
  [mailto:root@fatcity.com]En nombre de 
  lhoska@calibresys.comEnviado el: Wednesday, 15 August, 2001 
  3:29 PMPara: Multiple recipients of list ORACLE-LAsunto: 
  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@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@codetel.net.do">com.banilejas@codetel.net.do
    809-565-3121
    
      <FONT face=Tahoma 
      size=2>-----Mensaje original-----De: root@fatcity.com 
      [mailto:root@fatcity.com]En nombre de 
      lhoska@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><FONT color=#0000ff 
      face=Arial>[Lyuda Hoska] 
      <SPAN 
      class=651300118-15082001> -----Original 
      Message-----From: Ramon Estevez 
      [mailto:com.banilejas@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@codetel.net.do">com.banilejas@codetel.net.do
        809-565-3121
        
          <FONT face=Tahoma 
          size=2>-----Mensaje original-----De: root@fatcity.com 
          [mailto:root@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@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@codetel.net.do">com.banilejas@codetel.net.do
            809-565-3121