1.查看日志文件
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
1 1 100 52428800 512 1 NO CURRENT 3277175 19-FEB-16 2.8147E+14
2 1 98 52428800 512 1 YES INACTIVE 3219784 19-FEB-16 3247884 19-FEB-16
3 1 99 52428800 512 1 YES INACTIVE 3247884 19-FEB-16 3277175 19-FEB-16
2.正常关闭数据库
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
3.处理redolog
[oracle@single2 single2]$ mv redo01.log redo01.log.bak
[oracle@single2 single2]$ rm -rf redo01.log
4.启动
SQL> startup
ORACLE instance started.
Total System Global Area 413372416 bytes
Fixed Size 2253784 bytes
Variable Size 318770216 bytes
Database Buffers 88080384 bytes
Redo Buffers 4268032 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 2560
Session ID: 1 Serial number: 5
alert日志
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/single2/redo01.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
5.恢复
SQL> startup mount;
ORACLE instance started.
Total System Global Area 413372416 bytes
Fixed Size 2253784 bytes
Variable Size 318770216 bytes
Database Buffers 88080384 bytes
Redo Buffers 4268032 bytes
Database mounted.
SQL> recover database until cancel;
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
6.自己生成了redolog文件
[oracle@single2 single2]$ ll redo01.log
-rw-r----- 1 oracle oinstall 52429312 Mar 5 21:55 redo01.log
当前日志损坏(ACTIVE,CURRENT)，数据库正常关闭
原文：http://blog.csdn.net/ghostliming/article/details/50864106