Goldengate常见错误处理方式

1.OGG-01296

WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: SQL error 1403 mapping HR.EMPLOYEES to HR.EMPLOYEES.
WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Repositioning to rba 2509817 in seqno 1.
ERROR  OGG-01296 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: Error mapping from HR.EMPLOYEES to HR.EMPLOYEES.
ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: PROCESS ABENDING.
由于源端进行了表结构更改， 没有通知目标端，导致此错误

处理方案：

1).确认两端表结构是否一致;

2).确认源端表的附加日志已经打开,如果没打开则进行打开:

GGSCI> info trandata <schema>.<table>

GGSCO> add TRANDATA <schema>.<table>

3).确认目标端:触发器,约束,job等是否已经禁用

2.OGG-01444

OGG-01004  Oracle GoldenGate Delivery for Oracle, repchl_c.prm:  Aborted grouped transaction on 'CHANNEL.SEQ_POLICY_REPORT', Database error 6550 ().
OGG-01003  Oracle GoldenGate Delivery for Oracle, repchl_c.prm:  Repositioning to rba 28315843 in seqno 5.
OGG-01154  Oracle GoldenGate Delivery for Oracle, repchl_c.prm:  SQL error 6550 mapping CHANNEL.SEQ_POLICY_REPORT to CHANNEL.SEQ_POLICY_REPORT.
OGG-01003  Oracle GoldenGate Delivery for Oracle, repchl_c.prm:  Repositioning to rba 29190828 in seqno 5.
OGG-01444  Oracle GoldenGate Delivery for Oracle, repchl_c.prm:  Error in replicating sequence value [ORA-06550: line 1, column 7:
PLS-00201: identifier 'OGG.REPLICATESEQUENCE' must be declared
ORA-06550: line 1, column 7:

处理方案:

1).结合报错中出现的ORA错误进行分析;

2).如果类似本次报出的PLS-00201则表示sequence.sql没有执行引起的

3.OGG-01154

2011-03-29 15:53:57 WARNING  OGG-01154 Oracle GoldenGate Delivery for Oracle,
repya.prm: SQL error 14402 mapping HR.EMPLOYEES to HR.EMPLOYEES OCI Error ORA-14402:
updating partition key column would cause a partition change (status = 14402), SQL <UPDATE
“HR”.”EMPLOYEES” SET "PR_ORG" = :a1,"BELONG_DEPT" = :a2 WHERE "METER_ID" = :b0>.

处理方案:

1).报错信息可以看出，是分区表更新分区键引起的数据分区变更。需要启用row movement;

SQL> alter table <schema>.<table> enable row movement;

4.OGG-01088

ERROR  OGG-01088 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: malloc 2097152 bytes failed.
ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep_hr.prm: PROCESS ABENDING.

处理方案:

1).ulimit -a,确认操作系统是否对GG用户有资源限制；

2).拆分进程;

3).从MOS上下载最新补丁，升级OGG

5.OGG-10224 

ERROR OGG-01224 Oracle GoldenGate Manager for Oracle, mgr.prm: No buffer space available
ERROR OGG-01224 Oracle GoldenGate Capture for Oracle, dpe_hr.prm: TCP/IP error 9 (Bad file number)

处理方案：

1).扩大动态端口范围;

2).确认目标端MGR进程是否启动;

6.OGG-01031(正常使用一段时间出现) 

ERROR  OGG-01031 There is a problem in network communication, a remote file problem, encryption
keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is
Expected 4 bytes, but got 0 bytes, in trail ./dirdat/hr000026, seqno 26, reading record trailer token at RBA
103637218).
2011-01-06 11:04:16 ERROR OGG-01668 PROCESS ABENDING.

处理方案：

1).可能是网络故障后源端DP进程重启，如果此时目标端的server进程还没停则:

a).停掉源端所有的dp进程;

b).目标端执行:ps -ef|grep server并杀死这些gg相关的server进程(例: ./server -w 300 -p 7890-7938 -m 7889 -k -l /u01/app/goldengate/ggtgt/ggserr.log);

c).重启dp进程;

2).如果目标端的trail文件出现问题,则前滚一个trail：

send extract <group>, etrollover

7.OGG-01072

ERROR OGG-01072 LOBROW_get_next_chunk(LOBROW_row_t *, BOOL, BOOL, BOOL,
LOBROW_chunk_header_t *, char *, size_t, BOOL, *) Buffer overflow, needed:132, alloc 2.

处理方案:

1).如果版本为11.1.1.0.1 Build 078，则有BUG需要升级;

2).确认是否有资源限制：ulimit -a;

3).extract: DBOPTIONS LOBBUFSIZE <bytes>

4).replicat: DBOPTIONS LOBWRITESIZE 1MB

 

8.OGG-01476 

ERROR OGG-01476 The previous run abended due to an out of order transaction. Issue ALTER
ETROLLOVER to advance the output trail sequence past the current trail sequence number, then restart.
Then, use ALTER EXTSEQNO on the subsequent pump EXTRACT, or REPLICAT, process group to start
reading from the new trail file created by ALTER ETROLLOVER; the downstream process will not
automatically switch to the new trail file.

解决方案：

1).如果源端是RAC，确认两个节点的时间是否同步并且参数文件增加:

THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 7000 IOLATENCY 7000

2).如果以上动作完成后仍然有相同问题则按照简易进行trail切换

a).alter extract <group>, etrollover

b).alter extract <dp_group>, extseqno <new>, extrba 0;

c).alter replicat <rep_group>,extseqno <new>, extrba 0;