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 *


Sergio Sathler

Sergio Sathler

[IMAGE]

(X) Error
———————————————-
Error while running checker DB Structure Integrity Check
SQL Error: ORA-00210: cannot open the specified control file
ORA-00202: control file: ‘/u01/app/oracle/oradata/orcl/control01.ctl’
ORA-27041: unable to open file
Linux Error: 2: No such file od directory
Additional Information: 3
ORA-05512: at “SYS.DBMS_HM”, line 191 ORA-06512: at line 1