A database instance uses an SPFILE. Examine the parameter:
You plan to multiplex the control file to a new location, /u01/app/oracle/oradata/cdb1/disk3/
control03.ctl/.
Examine the possible steps that are in random order:
1. Shut down the database instance.
2. Issue ALTER SYSTEM SET CONTROL_FILES= ‘/u01/app/oracle/oradata/cdb1/disk1/
control01.ctl, /u01/app/oracle/oradata/cdb1/disk2/control02, /u01/app/oracle/
oradata/cdb1/disk3/control03.ctl’ SCOPE=SPFILE;.
3. Issue ALTER SYSTEM SET CONTROL_FILES=
‘/u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/cdb1/
disk2/control02.ctl, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl’;.
4. Copy the control file from the existing location to ‘/u01/app/oracle/oradata/cdb1/disk3/
control03.ctl’.
5. Mount the database.
6. Open the database.
Identify the required steps in the correct order to accomplish the task.
A.
3, 4
B.
2, 1, 4, 6
C.
3, 1, 4, 6
D.
1, 5, 2, 4, 6
E.
2, 6
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.
B