the steps of multiplexing the control file
672680Dec 17 2010 — edited Dec 18 2010I 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