mysql ogg丢数据_my27_OGG MySQL To MySQL错误汇总

OGG-00446

2019-02-12T14:57:57.668+0800 ERROR OGG-00446 Oracle GoldenGate Delivery for MySQL, r1.prm: .

2019-02-12T14:57:57.668+0800 ERROR OGG-01668 Oracle GoldenGate Delivery for MySQL, r1.prm: PROCESS ABENDING.

2019-02-12T14:59:24.221+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for MySQL: GGSCI command (root): info r1 detail.

GGSCI (dbwuliao02 DBLOGIN as dbamng_wuliao) 13>info r1 detail

REPLICAT R1 Last Started2019-01-29 15:27Status ABENDED

Checkpoint Lag00:00:00 (updated 264:20:03ago)

Log Read Checkpoint File/data/ogg/dirdat/r10000000012019-01-29 14:50:03.590825 RBA 131688047Current Log BSN value: (no data)

Last Committed Transaction CSN value: (no data)

Extract Source Begin End/data/ogg/dirdat/r1000000001 * Initialized * 2019-01-29 14:50

/data/ogg/dirdat/r1000000000 * Initialized *First Record

Current directory/data/ogg

Report file/data/ogg/dirrpt/R1.rpt

Parameter file/data/ogg/dirprm/r1.prm

Checkpoint file/data/ogg/dirchk/R1.cpr

Checkpoint table ad_dianjing.checkpoint

Process file/data/ogg/dirpcs/R1.pcr

Error log/data/ogg/ggserr.log

实际上这个OGG年前做了进程中断重新同步操作，只处理了抽取与推送进程，没有处理这个复制进程；下面重新指定复制进程的起点，以可重复执行的方式重新启动复制进程后，复制进程恢复正常

alter replicat r1 extseqno 3, extrba 0

start r1 NOFILTERDUPTRANSACTIONS

OGG-01004

2019-02-12T15:25:45.543+0800 WARNING OGG-01004 Oracle GoldenGate Delivery for MySQL, r1.prm: Aborted grouped transaction on vodb.test, Database error 1062 ([SQL error 1062]Duplicate entry '5451326' for key 'PRIMARY').

2019-02-12T15:25:45.543+0800 WARNING OGG-01003 Oracle GoldenGate Delivery for MySQL, r1.prm: Repositioning to rba 2235 in seqno 1.

2019-02-12T15:25:45.543+0800 WARNING OGG-01154 Oracle GoldenGate Delivery for MySQL, r1.prm: SQL error 1062 mapping vodb.test to vodb.test [SQL error 1062]Duplicate entry '5451326' for key 'PRIMARY'.

2019-02-12T15:25:45.553+0800 ERROR OGG-01296 Oracle GoldenGate Delivery for MySQL, r1.prm: Error mapping from vodb.test to vodb.test.

2019-02-12T15:25:45.554+0800 ERROR OGG-01668 Oracle GoldenGate Delivery for MySQL, r1.prm: PROCESS ABENDING.

主键重复，删除目标的相关数据即可。

OGG-01031

ERROR   OGG-01031  Oracle GoldenGate Capture for MySQL, p1.prm:  There is a problem in the communication with the Collector/Receiver Server. (Reply received is 'Unable to open file "/data/ogg/dirdat/r1000000000" (error 11, Resource temporarily unavailable)').

/data/ogg/dirdat/r1000000000文件打不开，这是配置在目标端上的文件，安装OGG时使用了非root用户，该文件生成了，但内容为空，重新配置目标端OGG，步骤如下

停止目标端OGG所有进程

将目标端OGG目录授权为 root.root 权限

由于是刚配置启动目标端OGG，远程的同步文件为空文件，此处删除该空文件，然后为重装为dump进程设置推送的起点

p1为推送进程，设置p1重新从第一个抽取进程生成文件的最开始的位置，重新开始推送文件；因为抽取进程一直运行正常，在不断地从日志中抽取文件，所以不需要重新配置抽取进程

alter p1 extseqno 0,extrba 0

start extract p1

之后可以看到远程文件可以正常写入了

[root@db02 /data/ogg/dirdat]# ll

total 616888

-rw-r----- 1 root root 499999777 Jan 29 11:33 r1000000000

-rw-r----- 1 root root 131686696 Jan 29 11:33 r1000000001

OGG-02760

WARNING OGG-02760  Oracle GoldenGate Delivery for MySQL, r1.prm:  ASSUMETARGETDEFS is ignored because trail file /data/ogg/dirdat/r1000000000 contains table definitions.

ASSUMETARGETDEFS 参数在OGG12中已经不再使用了，可以去掉该参数