Shulou(Shulou.com)06/01 Report--

When dealing with goldengate data synchronization, the source side is out of sync with the target side, which may be due to different table structure, data and indexes. The problem is still found after importing all the tables from the source side to the target side (ERROR OGG-01296 Error mapping from T.FUT_VP_RANK to T.FUT_VP_RANK.). The final result is to filter the table and start the replication process, or you can filter the backup table name and restart the process.

Problem process:

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

. Omit.

2015-04-07 19:47:38 ERROR OGG-01296 Error mapping from T.FUT_VP_RANK to T.FUT_VP_RANK.

. Omit.

Solution:

GGSCI (ogg2) 20 > edit params repwt2

TABLEEXCLUDE T.FUT_VP_RANK-add this line to filter out the FUT_VP_RANK table (or TABLEEXCLUDE T.SYS_EXPORT_TABLE_01)

GGSCI (ogg2) 21 > start repwh3

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 >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.