67.The instance abnormally terminates because of a power outage. Which statement is true about redo

最新推荐文章于 2023-09-15 14:53:19 发布

今年我18

最新推荐文章于 2023-09-15 14:53:19 发布

阅读量1.4k

点赞数

CC 4.0 BY-SA版权

分类专栏： 1z0-052 文章标签： 1z0-052

本文链接：https://blog.youkuaiyun.com/dwj19830118/article/details/52024500

1z0-052 专栏收录该内容

187 篇文章

订阅专栏

探讨了在因电力故障导致实例异常终止后的实例恢复过程中，重做日志文件的作用及其实现机制。强调所有从最后一个检查点之后的重做日志条目都会被应用到数据文件中。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

67.The instance abnormally terminates because of a power outage. Which statement is true about redo
log files during instance recovery?
A.Inactive and current redo log files are required to accomplish recovery.
B.Online and archived redo log files are required to accomplish instance recovery.
C.All redo log entries after the last checkpoint are applied from redo log files to data files.
D.All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files.
答案：C
解析：
A：错误，INACTIVE表示实例恢复已经不在需要这个联机重做日志组
B：错误，都归档了肯定是不需要了
C：正确，具体过程参考63题
D：错误，这里说当前redo文件中直到数据文件记录的checkpoint那个点，这部分都已经写到数据文件中了，还恢复干啥