Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Lost of all Control Files

RE: Lost of all Control Files

From: <lhoska_at_calibresys.com>
Date: Wed, 15 Aug 2001 10:56:00 -0700
Message-ID: <F001.0036BA59.20010815110031@fatcity.com>

<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  
Received on Wed Aug 15 2001 - 12:56:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US