Oracle goldengate的OGG-01004 OGG-1296错误

2014-11-24 18:23:51 · 作者: · 浏览: 0

在复制进程的错误:


Using the following key columns for target table CHQING.DH_OPS_TESTOILLOG: PK_TEST_LOG.


2011-06-28 10:40:37 WARNING OGG-01004 Aborted grouped transaction on 'CHQING.MLOG_ADM_DAILY_LOG_ORG_DTL', Database error 100 (retrieving bind info for query).


2011-06-28 10:40:37 WARNING OGG-01003 Repositioning to rba776068 inseqno 56.


2011-06-28 10:40:38 WARNING OGG-01003 Repositioning to rba980558 inseqno 56.


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-06-28 10:40:38 ERROR OGG-01296 Error mapping from CHQING.MLOG_ADM_DAILY_LOG_ORG_DTL to CHQING.MLOG_ADM_DAILY_LOG_ORG_DTL.


解决:


在目标库:


GGSCI (CBDBS01) 74> dblogin userid username,password userpwd


Successfully logged into database.


GGSCI (CBDBS01) 75> add trandata CHQING.MLOG_ADM_DAILY_LOG_ORG_DTL


Logging of supplemental redo data enabled for table CHQING.MLOG_ADM_DAILY_LOG_OR


G_DTL.