Oracle Exam 1Z0-063 Topic 4 Question 30 Discussion

A database instance uses an SPFILE. Examine the parameter:

You plan to multiplex the control file to a new location, parallelization for the backup

set./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, ctl,

/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.