Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

the steps of multiplexing the control file

672680Dec 17 2010 — edited Dec 18 2010
I am preparing for the OCP and I encountered the below case and I don`t know which one is the right answer.
So, could you guys help pick the right one and explain why?

144: You want to protect your database from single point of failure by multiplexing the control file. Your database is started using SPFILE. You have to perform the following tasks
1.shutdown the database instance;
2. copy the control file to new location.
3.configure the CONTROL_FILES parameter.
4. restart the instance.
select the correct order in which these tasks need to be performed:
a) 1,2,3,4
b) 3,2,1,4
c) 3,1,2,4
d) 2,3,1,4

the answer said c) is the right one.

Here is my explanation, please see if it is right?

to make sure the consistency of control file before copying it to new location, we must shutdown the database.
so, the order is 2 must be after 1, so we got a) or c).
then to configure CONTROL_FILES, you have to start the instance at least, so we can eliminate the a) and we left with c).

correct me if I am wrong.

Thanks a bunch.

Edited by: PhoenixBai on Dec 18, 2010 10:46 AM
This post has been answered by CKPT on Dec 17 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 15 2011
Added on Dec 17 2010
10 comments
403 views