Dropping redo logs is not possible - Oracle Redo Log

Q.  Which of these statements overcomes two situations where dropping redo logs is not possible?
- Published on 12 Aug 15

a. If there are only two log groups
b. The corrupt redo log file belongs to the current group
c. The corrupt redo log file belongs to the Inactive group
d. If there are only four log groups
e. Both A & B

ANSWER: Both A & B
 

    Discussion

  • Nirja Shah   -Posted on 24 Sep 15
    - 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.

    - This statement overcomes two situations where dropping redo logs is not possible:

    1. If there are only two log groups
    2. The corrupt redo log file belongs to the current group

Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)