OCP-1Z0-053-V12.02-49题

 

49.Which statement about recovering from the loss of a redo log group is true?

A. If the lost redo log group is ACTIVE, you should first attempt to clear the log file.

B. If the lost redo log group is CURRENT, you must clear the log file.

C. If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

D. If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery,and open the database using the RESETLOGS option.

Answer: D

答案解析：

参考： http://blog.csdn.net/rlhua/article/details/12622415

如果丢失当前redo log file

则还原，基于SCN,时间或者取消的恢复，再同RESETLOGS 打开数据库，打开数据库后，再进行一次全备份。

如果丢失不是当前redo log file，则删除添加，或者清除。