A database instance is started by using an SPFILE. The database is configured in ARCHIVELOG mode and the control file autobackup is configured. Daily full database backups are performed by using RMAN.
You lost all control files due to media failure.
Given the steps to recover from the error in random order:
1.Shut down the instance, if it is not already down.
2.Restore the control file from autobackup to a new location.
3.Start the database instance to NOMOUNT state.
4.Recover the database to the point of failure of the control file.
5.Open the database with the RESETLOGS option.
6.Mount the database.
7.Update the SPFILE with the new location of the control file by using the ALTER SYSTEM command.
Identify the correct sequence of the required steps.
A. 13,2,6,7,4,5
B. 1,3, 7, 2, 6, 4,5
C. 1, 3, 2, 4, 5
D. 1,2, 6,4,5
E. 1,6, 2,4, 5