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’;
Explanation:
You should use the ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1; statement to
clear the corrupted online redo log file. When you issue this statement, the contents of the online
redo log file are cleared, and the log file is initialized. Because the log file has not been archived,
the UNARCHIVED keyword is used. This keyword overrides the archiving of the online redo log
file in the redo group, and the cleared redo log files become available for use. Immediately after
issuing this statement, you should perform a database backup. The option stating that you will use
the ALTER DATABASE DROP LOGFILE GROUP 1; statement to resolve the corrupted online
redo log file is incorrect. If you attempt to drop the online redo log group that belongs to a current
redo group, you will receive the following errors:
ORA-01623: log 1 is current log for thread 1 cannot drop
ORA-00312: online log 1 of thread 1: ‘D:\REDO01.LOG’
The option stating that you will use the ALTER DATABASE CLEAR LOGFILE GROUP 1;
statement to resolve the corrupted online redo log file is incorrect. If you attempt to clear an online
redo log file that must be archived without using the UNARCHIVED keyword, you will receive the
following errors:
ORA-00350: log 1 of thread 1 needs to be archived
ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG’The option stating that you will use the ALTER DATABASE DROP LOGFILE MEMBER
‘D:\REDO01.LOG’; statement to resolve the corrupted online redo log file is incorrect. Oracle does
not allow you to drop an online redo log member that belongs to an active or current redo group.
Therefore, if you attempt to drop such a member, you will receive the following error:
ORA-00361: cannot remove last log member ‘D:\redo01.log for group 1’