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:RE: Lost of all Control Files

Re:RE: Lost of all Control Files

From: <dgoulet_at_vicr.com>
Date: Wed, 15 Aug 2001 09:36:07 -0700
Message-ID: <F001.0036B6BD.20010815085631@fatcity.com>

I've stayed out of this one up till now. But based on the original I assume that all of the control files where on the same disk drive & directory. Bad idea. If you have a problem with the drive and/or controller then you've been had. Place the control files on multiple spindles that are preferably on different controllers. And periodically, like at every shutdown, run the 'alter database backup controlfile to trace' command. It would even be a good thing to occasionally issue 'alter database backup controlfile to <somewhere safe>'.

Dick Goulet

____________________Reply Separator____________________
Author: INF/MEKKAOUI <nmekkaoui_at_lth.sonatrach.dz>
Date:       8/15/2001 7:41 AM

hi,
if you have 3 controlfiles (it means that you have two copies of your controlfile), so if there is a problem with one controlfile, you had to change the parameter control_files in the init.ora so that you eliminate the corrupted file.    

Best Regards,
Nabila Mekkaoui
DBA Oracle

-----Message d'origine-----
De : Ramon Estevez [mailto:com.banilejas_at_codetel.net.do] Envoyé : mercredi 15 août 2001 14:22
A : Multiple recipients of list ORACLE-L Objet : Lost of all Control Files

Hi gurus,  

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  

I have 3 controlfiles, no copies, sorry, shame.  

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.  

Don't know what to do.  

I don't have backups of the control files.  

Saludos,    

Ramon E. Estevez
com.banilejas_at_codetel.net.do <mailto:com.banilejas_at_codetel.net.do> 809-565-3121  

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">


<META content="MSHTML 5.00.2920.0" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=644383015-15082001>hi,</SPAN></FONT></DIV> <DIV><FONT color=#0000ff face=Arial size=2><SPAN class=644383015-15082001>if you

have 3 controlfiles (it means that you have two copies of your controlfile), so if there is a problem with one controlfile, you had to change the parameter control_files in the init.ora so that you eliminate the corrupted file.</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN class=644383015-15082001></SPAN></FONT>&nbsp;</DIV>

<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>Best Regards,</FONT></DIV>
<DIV><FONT face=Arial size=2>Nabila Mekkaoui</FONT></DIV>
<DIV><FONT face=Arial size=2>DBA Oracle</FONT></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">

<DIV align=left class=OutlookMessageHeader dir=ltr><FONT face=Tahoma
  size=2>-----Message d'origine-----<BR><B>De&nbsp;:</B> Ramon Estevez   [mailto:com.banilejas_at_codetel.net.do]<BR><B>Envoyé&nbsp;:</B> mercredi 15 août

  2001 14:22<BR><B>A&nbsp;:</B> Multiple recipients of list   ORACLE-L<BR><B>Objet&nbsp;:</B> Lost of all Control Files<BR><BR></DIV></FONT>
<DIV><FONT face=Verdana><SPAN class=902011014-15082001>Hi
  gurus,</SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN

  class=902011014-15082001></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Verdana><SPAN class=902011014-15082001>When my DB is starting
  I am getting an error of corrupt block in controlfile (block 1, block #1)
</SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN class=902011014-15082001>Ora-00202
  'c:\oracle\oradata\control01.con'</SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN class=902011014-15082001>Ora-00207
</SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN

  class=902011014-15082001></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Verdana><SPAN class=902011014-15082001>I have 3 controlfiles,
  no copies, sorry, shame.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN

  class=902011014-15082001></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Verdana><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></FONT></DIV>
<DIV><FONT face=Verdana><SPAN

  class=902011014-15082001></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Verdana><SPAN class=902011014-15082001>Don't know what to
  do.&nbsp; </SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN

  class=902011014-15082001></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Verdana><SPAN class=902011014-15082001>I don't have backups of

  the control files.</SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN

  class=902011014-15082001></SPAN></FONT>&nbsp;</DIV>
<DIV><FONT face=Verdana><SPAN

  class=902011014-15082001>Saludos,</SPAN></FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Verdana>Ramon E. Estevez</FONT></DIV>
<DIV><FONT face=Verdana><A

  href="mailto:com.banilejas_at_codetel.net.do">com.banilejas_at_codetel.net.do</A></F ONT></DIV>
<DIV><FONT face=Verdana>809-565-3121</FONT></DIV>
<DIV>&nbsp;</DIV></BLOCKQUOTE></BODY></HTML>

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: dgoulet_at_vicr.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Aug 15 2001 - 11:36:07 CDT

Original text of this message

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