control file missing !
What happens if 1 of the 3 control files is deleted ?
remove the missing controlfile entry from the init parameter file :-)
"There is a difference between knowing the path and walking the path."
AS u know control files . where every thing lies . in case if your control file as been deleted . think that your database as gone . but in case if your more than one control files . it is very good . if try to second ctr files . your have many optional . to get the data from the control files
This is my understanding, just wanted to confirm it:
if 1 of the 3 control files is deleted (or the disk that it is on, and its mirror goes bad) while the database is running, the database will not even write any errors to the alert log until shutdown time ?
At that time, will I have to abort the instance, fix the init.ora or copy the control file, and restart the database ?
You should not need to abort the instance, however you will need to either 'fix' the init.ora or get a new copy of the control file before you can restart the instance.
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
Click Here to Expand Forum to Full Width