| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 1/2 control file failure - will database halt?
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
 |
 |