Loss of "Current" Online Redo Log Group

·         Start the instance if necessary.

·         Attempt to alter the database and drop the redo log group. You will receive an ORA-00350 error stating that the redo log group needs to be archived.

·         Shutdown the instance.

·         Review the trace files.

·         Review the alert.log file.

·         Copy the datafiles and redo log files from the backup directory into their respective paths.

·         Mount the instance.

·         Query the v$log view to determine the sequence# of the current log group.

·         Run archive log list.

·         Recover the database until cancel, cancelling the recovery operation one log file sequence# before the current log group.

·         Once recovery is complete open the database with the resetlogs command.

·         Determine if a full off-line backup is required and perform one if necessary.

·         Delete the trace files in the $HOME/trace directory.

·         View the alert.log file for the recovery that was applied.

·         Remove the archive log files from the archive directory.

·         Remove the alert.log and trace files from the trace directory.

·         Ensure the instance is started and the database is open.