Database started using SPFILE - Example - Oracle Managed Files

Q.  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, Give the correct order in which these tasks to be performed.

1. Shut down the database instance.
2. Copy the control file to new location.
3. Configure the CONTROL_FILES parameter.
4. Restart the instance.

- Published on 12 Aug 15

a. 3, 2, 1, 4
b. 3, 1, 2, 4
c. 3, 2, 1, 4
d. 2, 3, 1, 4

ANSWER: 3, 1, 2, 4

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)