You are using the following command to clear the log file group:
ALTER DATABASE CLEAR LOGFILE GROUP 2;
In which case would the command be successful?
A.
Group 2 is the active group.
B.
Group 2 is the current group.
C.
Database is in the MOUNT state.
D.
Group 2 has been already archived.
A redo log file might become corrupted while the database is open, and ultimately stop database activity because archiving cannot continue. In this situation the ALTER DATABASE CLEAR LOGFILE statement can be used to reinitialize the file without shutting down the database.
You can clear an inactive redo log group when the database is open or closed. The procedure depends on whether the damaged group has been archived.
To clear an inactive, online redo log group that has been archived, use the following procedure:
1.. ……
2. Reinitialize the damaged log group. For example, to clear redo log group 2, issue the following statement:
ALTER DATABASE CLEAR LOGFILE GROUP 2