You work as a database administrator for Certkiller .com. You started the instance using the init.ora file. You have two control files and three redo log groups in your database. You decided to protect the database against failures by adding one more control file.
Which file is the appropriate way to perform this task?
A.
Shut down the instance, copy the control file to the third location and open the database.
B.
Abort the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in the init.ora file and open the database.
C.
Copy the control file to the third location, modify the CONTROL_FILES parameter inthe init.ora file, restart the instance and open the database.
D.
Shut down the instance, copy the control file to the third location, modify the CONTROL_FILES parameter in the init.ora file and open the database.
E.
Shut down the instance, startup in the mount state, copy the control file to the third location, modify the CONTROL_FILES parameter in init.ora and open the database.
Explanation:
You can create an additional control file copy for multiplexing by copying an existing control file to a new location and adding the file name to the list of control files. Similarly, you rename an existing control file by copying the file to its new name or location, and changing the file name in the control file list. In both cases, to guarantee that control files do not change during the procedure, shut down the database before copying the control file.
To add a multiplexed copy of the current control file or to rename a control file:
1. Shut down the database
2. Copy an existing control file to a new location, using operating system commands.
3. Edit the CONTROL_FILES parameter in the database initialization parameter file to add the new control file name, or to change the existing control filename.
4. Restart the database.
REF.: Oracle 10g Administrator Guide, 5-4