ORA-00354,ORA-00353,ORA-00312

yiyufeng1986

OS: rhel5.5
oracle :10.2.0.4.0 - 64bit  (单实例)

Errors in file /oracle/admin/ods/bdump/ods_arc4_26580.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 9768 change 91738890343 time 02/18/2013 22:00:05
ORA-00312: online log 7 thread 1: '/oracle/oradata/ods/redo07.log'

春节前出现过几次，今天又出现了这个问题。导致goldengate的抽取进程无法从对应的归档中抽取数据和备库应用归档中断  。之前处理的方法是：alter database clear unarchived logfile 'corrupt redo logfilename';然后重启数据库，好了一阵子。但是今天也出现了该错误。今天用 ALTER SYSTEM DUMP LOGFILE 'filename'; 也报错同样的错。情急之下就只好clear掉坏的redo logfile.

针对目前多次出现该现象，请求协助找到具体的原因。

Maclean Liu(刘相兵

ARC4: Log corruption near block 9768 change 91738890343 time ?
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 9768 change 91738890343 time 02/18/2013 22:00:05
ORA-00312: online log 7 thread 1: '/oracle/oradata/ods/redo07.log'

简单来说是redo corruption， 如果没法dump出redo log的话 很难分析具体原因。

如果反复出现该错误的话 考虑 检测一下filesystem是否正常，并考虑 重建这些redo log所在的位置