OCP认证052考试题库：1Z0-V8.02-第7题

OCP认证052考试题库：1Z0-V8.02-第7题，完整题库请点击这里联系老师咨询了解

7. You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider

the steps that will be performed later when you open the database:

1: SGA is allocated.

2: Control file is read.

3: Redo log files are read.

4: Instance recovery is started.

5: Background processes are started.

6: Data files are checked for consistency.

7: Server parameter file or the initialization parameter file is read.

Which option has the correct order in which these steps occur?

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

B.1, 2, 3,7, 5, 6, 4

C.7, 1, 4, 5, 2, 3, 6

D.1, 7, 5, 4, 2, 3, 6

Answer: A

答案解析：

shutdown abort后，再startup，需要用到smon进行实例恢复。

在nomount阶段，读取初始化参数，分配SGA，后台进程启动

在mount阶段，读取控制文件和联机日志文件，查看需要打开哪些数据文件

在open阶段，根据控制文件内容找到数据文件，并打开，因为是abort关闭的数据库，则在open时需要检查数据库，数据库文件以及数据文件头部的scn号是否一致，如果不一致，SMON进程进行实例恢复。