標籤:goldengate資料不同步
在處理goldengate資料同步時出現源端與目標端不同步,有可能是表結構,資料以及索引不一樣。將源端的表全部匯入到目標端後仍發現問題(ERROR OGG-01296 Error mapping from T.FUT_VP_RANK to T.FUT_VP_RANK.)。最後結果將表過濾再啟動複製進程,也可過濾備份的表名再重啟進程。
問題進程:
GGSCI (ogg2) 18> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT ABENDED REPWT2 04:43:27 237:28:34
GGSCI (ogg2) 19> view report repwt2
。。。。。。。。。。。。。。。省略。。。。。。。。。。。。。。。。。。。。。。
2015-04-07 19:47:38 ERROR OGG-01296 Error mapping from T.FUT_VP_RANK to T.FUT_VP_RANK.
。。。。。。。。。。。。。。。省略。。。。。。。。。。。。。。。。。。。。。。
解決方案:
GGSCI (ogg2) 20> edit params repwt2
TABLEEXCLUDE T.FUT_VP_RANK --添加這行,將FUT_VP_RANK表過濾掉(或者TABLEEXCLUDE T.SYS_EXPORT_TABLE_01)
GGSCI (ogg2) 21> start repwh2
Sending START request to MANAGER ...
REPLICAT REPWH2 starting
GGSCI (ogg2) 22> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REPWH2 04:43:27 237:30:56
GGSCI (ogg2) 23> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REPWH2 04:43:27 237:30:58
GGSCI (ogg2) 24>
goldengate ERROR OGG-01296 Error mapping from