GoldenGate OGG-01296

错误信息:

WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, repyxb.prm:  SQL error 1403 mapping SGPM.P_SMS_SEND to SGPM.P_SMS_SEND.

WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repyxb.prm:  Repositioning to rba 2509817 in seqno 1.

ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, repyxb.prm:  Error mapping from SGPM.P_SMS_SEND to SGPM.P_SMS_SEND.

ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repyxb.prm:  PROCESS ABENDING.

原因分析:由于源端进行了表结构更改,没有通知目标端,导致此错误

处理方法:

  • 先确认两端表结构是否一致
  • 在源端查看附加日志是否enable

GGSCI>INFO TRANDATA schema.table_name

–返回应该是enable,如果不是,重新添加

GGSCI>ADD TRANDATA schema.table_name

  • 目标端数据库:触发器,约束,job等是否已经禁止
  • 查看discard文件(./dirrpt/xxx.dsc)中的相关描述
  • 使用logdump查看实际数据,分析原因

 

 


Posted

in

by

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *