GoldenGate 异常

• Error occured in javawriter.c[269]: Error occurred (Java exception): UEDataSource.createOperation:

  com.goldengate.atg.datasource.InvalidTransactionState: A new operation was received without first receiving a BEGIN transaction. This can happen when processing is resumed in the middle of a transaction, or when there are "before" images in the trail that are not being sent to the user exit (always include "GetUpdateBefores" in the user-exit parameter file)

停止extract进程

ggsci>stop ehbase

登陆OGG用户

ggsci>dblogin userid ggowner, password ggowner;

删除extract进程

ggsci>delete EXTRACT ehbase

删除${OGG_HOME}/dirdat目录下对应的数据文件

#rm ${OGG_HOME}/dirdat/tf000000

新建extract并启动

ggsci>add extract ehbase, tranlog, begin now
ggsci>add exttrail ./dirdat/tf, extract ehbase, megabytes 50 
ggsci>start extract ehbase

• ERROR   OGG-01705  Input checkpoint position 8012 for input trail file './dirdat/tf000000' is greater than the size of the file (8012).  Please consult Oracle Knowledge Management Doc ID 1138409.1. for instructions
  

修改参数

ggsci>alter EXTRACT phbase, extseqno 000000, extrba 0