1. Which two are true about Oracle instance recovery（）?
   A、Recovery begins from the beginning of the CURRENT redo log group.
   B、Recovery begins from the start of any ACTIVE redo log group or the start of the CURRENT log group if no other group is ACTIVE
   C、Recovery begins from the last checkpoint position that was recorded in the control fileby the checkpoint process (ckpt)
   D、Recovery begins from the last checkpoint position that was calculated by the Database Writer before instance failure
   E、Recovery reads redo until the end of the redo thread, and then opens the database. SMON then rolls back any dead transactions
   F、Recovery reads redo until the end of the redo thread. SMON rolls back any dead transactions, and then the database is opened

答案:CEhttp://www.cndba.cn/hbhe0316/article/108625http://www.cndba.cn/hbhe0316/article/108625http://www.cndba.cn/hbhe0316/article/108625http://www.cndba.cn/hbhe0316/article/108625

database does a roll forward (redo), opens the database and than the rollback (undo), so E instead of F!http://www.cndba.cn/hbhe0316/article/108625http://www.cndba.cn/hbhe0316/article/108625http://www.cndba.cn/hbhe0316/article/108625

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle