一 查看当前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
二 损坏redo文件
[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; (多切换几次)
