From lkoivu@qode.com Wed, 21 Mar 2001 14:49:10 -0800 From: "Koivu, Lisa" Date: Wed, 21 Mar 2001 14:49:10 -0800 Subject: RE: 1/2 control file failure - will database halt? Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: RE: 1/2 control file failure - will database halt? Yea, it worked for me...  it was a small database.... -----Original Message-----From: Kevin Kostyszyn [mailto:kevin@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 Kev -----Original Message-----From: root@fatcity.com [mailto:root@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 [mailto:danamn2000@yahoo.com] Sent: Wednesday, March 21, 2001 3:46 PM To: Multiple recipients of list ORACLE-L 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. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana   INET: danamn2000@yahoo.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@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).