首页 > 数据库 > Oracle > 052-007题解析
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进程进行实例恢复。来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12798004/viewspace-1133229/,如需转载,请注明出处,否则将追究法律责任。