Identify the correct sequence of steps?

The database instance is currently using SPFILE. View the Exhibit and examine the error
that you received while running the DB Structure Integrity check. Given below are the steps
to recover from the error in random order: 1. Shut down the instance, if not already done. 2.
Copy one of the remaining control files to a new location. 3. Change the value of the
CONTROL_FILES initialization parameter to correspond to the new location of the control
files. 4. Start up the database instance to the NOMOUNT stage. 5. Recover the database to
the point of failure of the control file. 6. Open the database. Identify the correct sequence of
steps?

The database instance is currently using SPFILE. View the Exhibit and examine the error
that you received while running the DB Structure Integrity check. Given below are the steps
to recover from the error in random order: 1. Shut down the instance, if not already done. 2.
Copy one of the remaining control files to a new location. 3. Change the value of the
CONTROL_FILES initialization parameter to correspond to the new location of the control
files. 4. Start up the database instance to the NOMOUNT stage. 5. Recover the database to
the point of failure of the control file. 6. Open the database. Identify the correct sequence of
steps?

A.
1, 2, 4, 3, 5, 6

B.
2, 4, 3, 5, 6; 1 not required

C.
4, 5, 6, 2, 3; 1 not required

D.
5, 2, 3, 4; 1 and 6 not required



Leave a Reply 1

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