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.
1, 3, 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
The correct answer should be D.
– https://docs.oracle.com/cd/B19306_01/backup.102/b14191/osrecov.htm#i1011110
Without control file can It be mounted?
I’m not sure about that. After restoring control file to new location you need to update CONTROL_FILES param.
Anyway…for restoring ctrl file using RMAN, Database schould be at least at NOMOUNT state.
Restore of the Control File to a New Location
You can perform this operation with the database in NOMOUNT, MOUNT or OPEN states, because you are not overwriting any of the control files currently in use. After restoring the control file to a new location, you can then update the CONTROL_FILES initialization parameter to include the new location.
I would go with answer A.
I think B is better