Tks Dick,
Yes, is a computer with only one disco, Is a DB for development purposes
until the real server comes. The issue is that I had too many data in the
DB and it will took me 2 days of work to load it again.
Thanks, I will have it present for the next time. It won't happen again.
:-(
Ramon E. Estevez
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
809-565-3121
-----Mensaje original-----
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de
[EMAIL PROTECTED]
Enviado el: Wednesday, 15 August, 2001 11:57 AM
Para: Multiple recipients of list ORACLE-L
Asunto: Re:RE: Lost of all Control Files
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 <[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
Envoyi : 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
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
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> </DIV>
<DIV> </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 :</B> Ramon Estevez
[mailto:[EMAIL PROTECTED]]<BR><B>Envoyi :</B> mercredi 15
ao{t
2001 14:22<BR><B>A :</B> Multiple recipients of list
ORACLE-L<BR><B>Objet :</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> </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> </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> </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> </DIV>
<DIV><FONT face=Verdana><SPAN class=902011014-15082001>Don't know what to
do. </SPAN></FONT></DIV>
<DIV><FONT face=Verdana><SPAN
class=902011014-15082001></SPAN></FONT> </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> </DIV>
<DIV><FONT face=Verdana><SPAN
class=902011014-15082001>Saludos,</SPAN></FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT face=Verdana>Ramon E. Estevez</FONT></DIV>
<DIV><FONT face=Verdana><A
href="mailto:[EMAIL PROTECTED]";>[EMAIL PROTECTED]</A><
/F
ONT></DIV>
<DIV><FONT face=Verdana>809-565-3121</FONT></DIV>
<DIV> </DIV></BLOCKQUOTE></BODY></HTML>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ramon Estevez
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
