logfile文件损坏的问题处理(ORA-00327)
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,系统恢复正常了,但是日志文件损坏的原因还不是特清楚。
推荐阅读