故障模拟如下:
[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
A:HTogg01数据源,B:HTogg02备份
表AAA无主键,B机故意修改AAA一条记录,A机对AAA记录做修改,数据向B机同步时,导致B机OGG的 replicat abended。
[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