clearing corrupt redo log

# Clear A Log File If It Has Become Corrupt:
ALTER DATABASE CLEAR LOGFILE GROUP <group_number>;

This 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.

And then there is another one

# Clear A Log File If It Has Become Corrupt And Avoid Archiving:
ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP <group_number>;

Use this version of clearing a log file if the corrupt log file has not been archived.

now in both cases the previous backup is unusable right? Because we are erasing the redo log in both cases. Received on Thu Oct 09 2008 - 14:16:34 CDT