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 is correct:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/onlineredo008.htm
his statement overcomes two situations where dropping redo logs is not possible:
-If there are only two log groups
-The corrupt redo log file belongs to the current group
If the corrupt redo log file has not been archived, use the UNARCHIVED keyword in the statement.
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;
This statement clears the corrupted redo logs and avoids archiving them. The cleared redo logs are available for use even though they were not archived.
If you clear a log file that is needed for recovery of a backup, then you can no longer recover from that backup. The database writes a message in the alert log describ
The information and facts talked about within the article are a few of the very best readily available.