Oracle 非当前redo 损坏

一 查看当前redo

SQL>  select group#,thread#,sequence#,status from v$log;
    GROUP#    THREAD#  SEQUENCE# STATUS
---------- ---------- ---------- ----------------
         1          1          4 INACTIVE
         2          1          5 INACTIVE
         3          1          6 CURRENT

二 损坏roracle数据edo文件

[oracle@slave prod]$ dd if=/dev/null of=/u01/app/oracle/oradata/prod/redo01.log bs=512 count=10
记录了0+0 的读入
记录了0+0 的写出
0字节(0 B)已复制,0.000123676 秒,0.0 kB/秒

三 重启实例

SQL> shutdown abort;
SQL> startup
ORACLE instance started.
Total System Global Area 1202556928 bytes
Fixed Size                  2252704 bytes
Variable Size             771752032 bytes
Database Buffers          419430400 bytes
Redo Buffers                9121792 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 16812
Session ID: 1 Serial number: 5
日志报错
LGWR: STARTING ARCH PROCESSES COMPLETE
Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_lgwr_16789.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/prod/redo01.log'
ORA-27047: unable to read the header block of file
Linux-x86_64 Error: 25: Inappropriate ioctl for device
Additional information: 1
Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_lgwr_16789.trc:
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/prod/redo01.log'
ORA-27047: unable to read the header block of file
Linux-x86_64 Error: 25: Inappropriate ioctl for device
Additional information: 1
Errors in file /u01/app/oracle/diag/rdbms/prod/prod/trace/prod_ora_16812.trc:
ORA-00313: open failed for members of log group 1 of thread
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/prod/redo01.log'
USER (ospid: 16812): terminating the instance due to error 313

四 清除问题redo

SQL> alter database clear logfile group 1; (或 alter database clear unarchived logfile group)
Database altered.
SQL> alter database open;
Database altered.
SQL> alter system switch logfile; (多切换几次)