Examine this configuration http://www.cndba.cn/hbhe0316/article/108620http://www.cndba.cn/hbhe0316/article/108620

1. CDB1 is a container database running in ARCHIVELOG mode.
2. Multiple uncommitted transactions are running in CDB1
3. Redo log groups 1 and 2 are NACTIVE
4. Redo log group 3 is the CURRENT group
   All members of redo log group 3 are lost before it is archived
   Examine these possible steps（）?
   1.SHUTDOWN ABORT
   2.STARTUP NOMOUNT
   3.STARTUP MOUNT
   4.ALTER DATABASE MOUNT
   5.RESTORE DATABASE
   6.recover database noredo
   7.RECOVER DATABASE UNTIL AVAILABLE
   8.RESTORE ARCHIVELOGALL
   9.ALTER DATABASE OPEN
   10.ALTER DATABASE OPEN RESETLOGS.
   Choose the mininum required steps in the correct order to recover the database.

A、1,3,5,6,9
B、1,3,5,8,6,10
C、1,2,5,7,4,10
D、1,3,5,7,10
E、1 3,5.6.10
F、1,3,5,6,10http://www.cndba.cn/hbhe0316/article/108620

答案：D
redo log group 3 are lost，只能使用open resetlogs方式打开http://www.cndba.cn/hbhe0316/article/108620http://www.cndba.cn/hbhe0316/article/108620http://www.cndba.cn/hbhe0316/article/108620http://www.cndba.cn/hbhe0316/article/108620

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

oracle