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 *