Oracle goldengate的OGG-01004 OGG-1296错误

Oracle goldengate的OGG-01004 OGG-1296错误

在复制进程的错误：

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.