Identify the required steps in the correct order to accomplish the task.


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. control files. cases, to guarantee that control files do not change during the procedure, shut down the database before copying the control file. filename.


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. control files. cases, to guarantee that control files do not change during the procedure, shut down the database before copying the control file. filename.

A.
3, 4

B.
2, 1, 4, 6

C.
3, 1, 4, 6

D.
1, 5, 2, 4, 6

E.
2, 6



Leave a Reply 0

Your email address will not be published. Required fields are marked *