Oracle 11G OCP 1Z0-053 3

(3)Your database is in ARCHIVELOG mode.You have two online redo log groups,each of which contains one redo member.

When you attempt to start the database,you receive the following errors:

ORA-00313:open failed for members of log group 1 of thread 1

ORA-00312:online log 1 thread 1:'D:\REDO01.LOG'

You discover that the online redo log file of the current redo group is corrupted.

Which statement should you use to resolve this issue?

A.ALTER DATABASE DROP LOGFILE GROUP 1;

B.ALTER DATABASE CLEAR LOGFILE GROUP 1;

C.ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;

D.ALTER DATABASE DROP LOGFILE MEMBER'D:\REDO01.LOG';

答案:(C)

解析:

C. 因为只有2个重做日志组,所以不能删除任何一个重做日志组。

请使用浏览器的分享功能分享到微信等