If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

How to Mirror Control Files and Control File Review

Oracle 8.16, Windows 2000.

I know I should mirror my control files. Can someone please explain to me how to proceed with this process or are the control files mirrored automatically? If they are mirrored automatically where are the mirrored images located. I've attached a snippet of my init file.
control_files =("D:\Oracle8i\oradata\PROD\control01.ctl", "D:\Oracle8i\oradata\PROD\
control02.ctl", "D:\Oracle8i\oradata\PROD\control03.ctl")

Also, it appears that my control files are all located on the same disk. I believe I should copy these files and move them to another disk. Am I correct in my assumption?

I have read the 8i admin guide section concerning Managing Control Files, and I've looked at the O'Reilly Oracle Database Administration book. I can't find any specific information concerning the mirroring of the control files.

You either have to recover using a backup of the controlfile or re-create it so ok it is complete recovery (with reset logs). Think when I posted this must have confused myself with a scenario we had a while back in my last job with loss of control file but it was complicated with loss of redo logs also.....

Thanks for the information. Just to clarify, mirroring simply refers to having copies of the control files on different disks? I truly do understand the importance of having copies of the control files I just want clear up the exact definition of mirroring.

yeah, it simply means to have more than one phyiscal copy of the control file referenced in the init.ora control_files parameter. Having the different copies on totally separate disks is the recommended way to mirror control files and redo logs but you are not forced to put them on separate disks at all it just makes sense to.