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: 1/2 control file failure - will database halt?

RE: 1/2 control file failure - will database halt?

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Wed, 21 Mar 2001 14:49:10 -0800
Message-ID: <F001.002D40EF.20010321143729@fatcity.com>

Yea,
it worked for me...  it was a small database....

<FONT face=Tahoma

  size=2>-----Original Message-----From: Kevin Kostyszyn   [mailto:kevin_at_dulcian.com]Sent: Wednesday, March 21, 2001 4:30   PMTo: Multiple recipients of list ORACLE-LSubject: RE:   1/2 control file failure - will database halt?   So
  you don't bring the DB down and then copy the controlfile?  You just copy   it?  Just curious
<FONT color=#0000ff face=Arial

  size=2>Kev   

    <FONT face=Tahoma
    size=2>-----Original Message-----From: root_at_fatcity.com     [mailto:root_at_fatcity.com]On Behalf Of Koivu, LisaSent:     Wednesday, March 21, 2001 4:02 PMTo: Multiple recipients of list     ORACLE-LSubject: RE: 1/2 control file failure - will database     halt?
    Dana,
    The database will spit errors.  I found as long as you     are only reading data and not trying any DDL or stuff like that, for the     most part the database will continue to run.  As the DBA, if you rush     in and copy one of the control files over to where the missing one was, the     database will continue running. Remember, no changes will be allowed that     will write to the control files - this will fail because Oracle wants to     write to every one of them, and if one is missing, nothing gets     changed. 
    This helps if you can't just bring down your database (like     me).
    I tested this a couple of weeks ago.     HTH Lisa
    -----Original Message----- From:
    dana [<A
    href="mailto:danamn2000_at_yahoo.com">mailto:danamn2000_at_yahoo.com]     Sent: Wednesday, March 21, 2001 3:46 PM <FONT     size=2>To: Multiple recipients of list ORACLE-L <FONT     size=2>Subject: 1/2 control file failure - will database halt?     

    I've been told a single control file failure will     halt the database, even if you've got another     control file on a second device; that the database     will only come up again after editing the init.ora     to remove the reference to the faulty control file     and initiating a fresh startup.
    Is this still true, if it ever was true for any version of     Oracle, for Oracle 8.X+? The person who warned me     about the halt has been using Oracle since version     5.
    Thanks very much.
     - Dana



    Do You Yahoo!? Get email at your
    own domain with Yahoo! Mail. <A
    href="http://personal.mail.yahoo.com/"     target=_blank>http://personal.mail.yahoo.com/ --     Please see the official ORACLE-L FAQ: <A     href="http://www.orafaq.com" target=_blank>http://www.orafaq.com Received on Wed Mar 21 2001 - 16:49:10 CST

Original text of this message

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