数据库在线重做日志崩溃

处理方法：

Clearing Inactive, Unarchived Redo

Clearing a not-yet-archived redo log allows it to be reused without archiving it. This action makes backups unusable if they were started before the last change in the log, unless the file was taken offline before the first change in the log. Hence, if you need the cleared log file for recovery of a backup, then you cannot recover that backup. Clearing a not-yet-archived-redo-log, prevents complete recovery from backups due to the missing log.

To clear an inactive, online redo log group that has not been archived:

1. If the database is shut down, then start a new instance and mount the database:

   SQL> STARTUP MOUNT

2. Clear the log using the UNARCHIVED keyword.

   For example, to clear log group 2, issue the following SQL statement:

   SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2;