Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2, and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk.
Which command would you execute to proceed further?
A. RECOVER LOGFILE BLOCK GROUP 2;
B. ALTER DATABASE DROP LOGFILE GROUP 2;
C. ALTER DATABASE CLEAR LOGFILE GROUP 2;
D. ALTER DATABASE RECOVER LOGFILE GROUP 2;
E. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;
Answer: E
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.