oracle10.2.0.5.0遭遇ORA-26773错误-Bug 5623403

昨天下午查看测试库发现stream的capture进程abort掉了，归档日志有将近100个没有应用了，查看告警日志发现如下错误：
ORA-26744: STREAMS capture process "UAT$CAP" does not support "MYNET_APP"."M_EDM_RESULT" because of the following reason: 
ORA-26773: Invalid data type for column "malformed redo"
查了很多资料，居然是BUG，官方描述如下：
Bug No. 5623403
Filed 26-OCT-2006 Updated 15-NOV-2007
Product Oracle Server - Enterprise Edition Product Version  10.2.0.1.0
Platform. Microsoft Windows XP Platform. Version No Data
Database Version 10.2.0.1 Affects Platforms  Generic
Severity  Severe Loss of Service Status Development to Q/A
Base Bug N/A Fixed in Product Version 11.0

Problem statement:

ORA-26773: INVALID DATA TYPE FOR COLUMN ''MALFORMED REDO'' IN STREAMS CAPTURE

纳闷了，都升级到最终版本了，居然还会遇到这个BUG，太悲催了，想办法解决吧：

首先想到的就是尝试，从数据字典里对这张表的实例化移除：
exec DBMS_CAPTURE_ADM.ABORT_TABLE_INSTANTIATION(table_name  => 'mynet_app.M_EDM_RESULT');
执行完了之后，重新启动capture进程，依然报错，然后abort，
没办法，此路不通，再次尝试对这张表指定规则：
BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_RULES (
table_name => 'MYNET_APP.M_EDM_RESULT',
streams_type => 'capture',
streams_name => 'UAT$CAP',
queue_name => 'STRMADMIN.UAT$CAPQ',
include_dml => true,
include_ddl => true,
source_database => 'UAT',
inclusion_rule => false ); --specifies the negative rule set
END;
/
之后重新启动capture进程，归档日志终于开始应用了，没多久报错ORA-600：
Thu Nov 24 15:32:05 CST 2011
Errors in file /oracle/admin/mydev/bdump/mydev_q003_18164.trc:
ORA-00600: internal error code, arguments: [kwqbdrcp101], [], [], [], [], [], [], []
索性直接重启target数据库，起来之后查看相应的propagation、capture和apply进程都是enabled状态，但是告警日志里没相关应用日志的信息，等吧，没2分钟，归档再次开始应用了，之后就没有再报错：
LOGMINER: End mining logfile: /arch/arch1_6226_716985918.arc
Thu Nov 24 15:32:42 CST 2011
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 6227, /arch/arch1_6227_716985918.arc
Thu Nov 24 15:32:45 CST 2011
LOGMINER: End mining logfile: /arch/arch1_6227_716985918.arc
Thu Nov 24 15:32:45 CST 2011
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 6228, /arch/arch1_6228_716985918.arc
Thu Nov 24 15:32:46 CST 2011
LOGMINER: End mining logfile: /arch/arch1_6228_716985918.arc
Thu Nov 24 15:32:46 CST 2011
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 6229, /arch/arch1_6229_716985918.arc
Thu Nov 24 15:32:51 CST 2011
LOGMINER: End mining logfile: /arch/arch1_6229_716985918.arc
Thu Nov 24 15:32:51 CST 2011
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 6230, /arch/arch1_6230_716985918.arc
Thu Nov 24 15:33:03 CST 2011
LOGMINER: End mining logfile: /arch/arch1_6230_716985918.arc
Thu Nov 24 15:33:03 CST 2011
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 6231, /arch/arch1_6231_716985918.arc
Thu Nov 24 15:33:05 CST 2011
LOGMINER: End mining logfile: /arch/arch1_6231_716985918.arc
Thu Nov 24 15:33:05 CST 2011
LOGMINER: Begin mining logfile for session 1 thread 1 sequence 6232, /arch/arch1_6232_716985918.arc

后记：一直想不通oracle版本都升级到最终版本了，居然还会遇到这个BUG，看来stream技术还不是很稳定。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25618347/viewspace-711956/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25618347/viewspace-711956/