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技術還不是很穩定。