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
数据库启动时,首先通过ORACLE_SID ,来找到的服务器参数文件(如spfileorcl11g.ora),并可以启动到nomount状态,此时实例启动;通过服务器参数文件(包含控制文件的路径) 可以找到控制文件的位置(所有的控制文件要都可用且一致),然后就可以启动到mount状态,此时数据库被装载;跟据控制文件里的scn号和数据文件头部的scn对比,一致,即可以启动到open状态,此时数据库打开。
此题意思是控制文件出问题了,现在用RMAN恢复控制文件
shut down数据库(如果没关)[这是为了启动时加载服务器参数文件]→将其他控制文件复制到新的路径→START数据库到MOUNT状态→修改服务器参数中的CONTROL的路径到新地址→Recover到控制文件失效的时间点→OPEN数据库