複製程式錯誤日誌：

2011-04-29 15:32:40 WARNING OGG-01004 Aborted grouped transaction on 'CHQING.OMS_CLIENT_TAB_RELATION', Database error 100 (retrieving bind info for query).

2011-04-29 15:32:40 WARNING OGG-01003 Repositioning to rba 26715058 in seqno 1.

Source Context :

SourceModule : [er.main]

SourceID : [/mnt/ecloud/workspace/Build_OpenSys_r11.1.1.0.15_001_[41784]/perforce/src/app/er/rep.c]

SourceFunction : [take_rep_err_action]

SourceLine : [15809]

2011-04-29 15:32:40 ERROR OGG-01296 Error mapping from CHQING.OMS_CLIENT_TAB_RELATION to CHQING.OMS_CLIENT_TAB_RELATION.

***********************************************************************

* ** Run Time Statistics ** *

***********************************************************************

Last record for the last committed transaction is the following:

___________________________________________________________________

Trail name : /oragg/oggst/dirdat/sb000001

Hdr-Ind : E (x45) Partition : . (x04)

UndoFlag : . (x00) BeforeAfter: A (x41)

RecLength : 99 (x0063) IO Time : 2011-04-29 10:22:17.352327

IOType : 15 (x0f) OrigNode : 255 (xff)

TransInd : . (x03) FormatType : R (x52)

SyskeyLen : 0 (x00) Incomplete : . (x00)

AuditRBA : 2336 AuditPos : 6608912

Continued : N (x00) RecCount : 1 (x01)

2011-04-29 10:22:17.352327 FieldComp Len 99 RBA 26715058

Name: CHQING.OMS_CLIENT_TAB_RELATION

___________________________________________________________________

Reading /oragg/oggst/dirdat/sb000001, current RBA 26715058, 0 records

Report at 2011-04-29 15:32:40 (activity since 2011-04-29 15:32:40)

From Table CHQING.OMS_CLIENT_TAB_RELATION to CHQING.OMS_CLIENT_TAB_RELATION:

# inserts: 0

# updates: 0

# deletes: 0

# discards: 2

忽略錯誤不能啟動：

start replicat repsb skiptransaction

使用PLSQL連線源資料庫，同時連線備庫，比較該表的資料，然後把比較出來的結果在備庫執行。

然後再啟動複製程式

start replicat repsb

Goldengate的複製程式出錯OGG-01296

相關文章