A database instance is started by using an SPFILE.

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

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

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


The reCAPTCHA verification period has expired. Please reload the page.