logfile文件损坏的问题处理(ora-00327),查看报错具体内容,应该是redo文件+data/tyolap/onlinelog/redo31a损坏。
1, 数据库日志报错ora-00327,注意此处有乱码
查看报错具体内容,应该是redo文件+data/tyolap/onlinelog/redo31a损坏
2,,进一步查看trc文件,具体原因没看明白,但基本已可以确定是日志文件损坏
de: problem key 'ora 313' was flood controlled (0x1) (no incident)
ora-00313: 31 ( 3) ?
ora-00313: 31 ( 3) ?
dde rules only execution for: ora 312
----- start event driven actions dump ----
---- end event driven actions dump ----
----- start dde actions dump -----
executing sync actions
----- start dde action: 'db_structure_integrity_check' (async) -----
dde action 'db_structure_integrity_check' was flood controlled
----- end dde action: 'db_structure_integrity_check' (flood controlled, 5 csec) -----
executing async actions
----- end dde actions dump (total 0 csec) -----
3,查看此redo文件的状态,status为invalid,另一个为stale,系统还在正常运行中.
4,日志文件损坏,最简单的方法就是在线重建日志文件了
5,系统恢复正常了,但是日志文件损坏的原因还不是特清楚。