OGG故障排除1例:因B机被修改数据导致replicat服务ABENDED修复

故障模拟如下:

A:HTogg01数据源,B:HTogg02备份

表AAA无主键,B机故意修改AAA一条记录,A机对AAA记录做修改,数据向B机同步时,导致B机OGG的 replicat abended。


[oracle@HTogg2 ~]$ cd /u01/ogg
[oracle@HTogg2 ogg]$ ./ggsci
GGSCI (HTogg2) 1> info all
Program     Status      Group       Lag at Chkpt  Time Since Chkpt
MANAGER     RUNNING                                           
REPLICAT    ABENDED     REPL01      00:00:07      01:10:24    
GGSCI (HTogg2) 2> info REPL01
REPLICAT   REPL01    Last Started 2016-06-28 11:18   Status ABENDED
Checkpoint Lag       00:00:07 (updated 01:11:06 ago)
Log Read Checkpoint  File ./dirdat/ht000006
                     2016-06-28 11:23:07.465387  RBA 1309
GGSCI (HTogg2) 3> sh more ggserr.log
...
2016-06-28 11:23:15  WARNING OGG-01004  Oracle GoldenGate Delivery for Oracle, repl01.prm:  Aborted grouped transaction on 'ITS.AAA', Database error 14
03 (OCI Error ORA-01403: no data found, SQL <UPDATE "ITS"."AAA" SET "A" = :a3,"N" = :a4,"DD" = :a5 WHERE "A" = :b0 AND "N" = :b1 AND "DD" = :b2 AND ROW
NUM = 1>).
2016-06-28 11:23:15  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repl01.prm:  Repositioning to rba 1309 in seqno 6.
2016-06-28 11:23:15  WARNING OGG-01154  Oracle GoldenGate Delivery for Oracle, repl01.prm:  SQL error 1403 mapping ITS.AAA to ITS.AAA OCI Error ORA-014
03: no data found, SQL <UPDATE "ITS"."AAA" SET "A" = :a3,"N" = :a4,"DD" = :a5 WHERE "A" = :b0 AND "N" = :b1 AND "DD" = :b2 AND ROWNUM = 1>.
2016-06-28 11:23:15  WARNING OGG-01003  Oracle GoldenGate Delivery for Oracle, repl01.prm:  Repositioning to rba 1309 in seqno 6.
2016-06-28 11:23:15  ERROR   OGG-01296  Oracle GoldenGate Delivery for Oracle, repl01.prm:  Error mapping from ITS.AAA to ITS.AAA.
2016-06-28 11:23:15  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repl01.prm:  PROCESS ABENDING.
...
GGSCI (HTogg2) 5> sh ls ./dirrpt -l
total 232
-rw-rw-rw- 1 oracle oinstall   2340 5月  11 15:28 MGR0.rpt
-rw-rw-rw- 1 oracle oinstall   2007 5月  11 14:20 MGR1.rpt
-rw-rw-rw- 1 oracle oinstall   2177 5月  11 14:19 MGR2.rpt
-rw-rw-rw- 1 oracle oinstall   2007 5月   5 15:13 MGR3.rpt
-rw-rw-rw- 1 oracle oinstall   2007 5月   5 14:43 MGR4.rpt
-rw-rw-rw- 1 oracle oinstall   2772 6月  28 11:18 MGR.rpt
-rw-rw-rw- 1 oracle oinstall  17984 5月  11 15:47 REPL010.rpt
-rw-rw-rw- 1 oracle oinstall  21105 5月  11 14:47 REPL011.rpt
-rw-rw-rw- 1 oracle oinsta
  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值