同步目标端失败报错:
2015-05-21 09:33:33 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, repraca.prm: PROCESS ABENDING.
2015-05-21 09:39:33 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REPRACA starting.
2015-05-21 09:39:33 INFO OGG-00965 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REPRACA restarted automatically.
2015-05-21 09:39:33 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, repraca.prm: REPLICAT REPRACA starting.
2015-05-21 09:39:33 INFO OGG-00893 Oracle GoldenGate Delivery for Oracle, repraca.prm: SQL statement executed successfully.
2015-05-21 09:39:33 INFO OGG-00893 Oracle GoldenGate Delivery for Oracle, repraca.prm: SQL statement executed successfully.
2015-05-21 09:39:33 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, repraca.prm: REPLICAT REPRACA started.
2015-05-21 09:39:33 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repraca.prm: No unique key is defined for table MET_NUI_ALLERGEN. All viable
columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2015-05-21 09:39:33 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, repraca.prm: Aborting BATCHSQL transaction. Detected inconsistent result: ex
ecuted 1 operations in batch, resulting in 0 affected rows.
2015-05-21 09:39:33 WARNING OGG-01137 Oracle GoldenGate Delivery for Oracle, repraca.prm: BATCHSQL suspended, continuing in normal mode.
2015-05-21 09:39:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repraca.prm: Repositioning to rba 1933837 in seqno 4.
2015-05-21 09:39:33 WARNING OGG-01004 Oracle GoldenGate Delivery for Oracle, repraca.prm: Aborted grouped transaction on 'HIS.MET_NUI_ALLERGEN', Database
error 1403 ().
2015-05-21 09:39:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repraca.prm: Repositioning to rba 1933837 in seqno 4.
2015-05-21 09:39:33 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, repraca.prm: SQL error 1403 mapping HIS.MET_NUI_ALLERGEN to HIS.MET_NUI_ALLE
RGEN.
2015-05-21 09:39:33 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, repraca.prm: Repositioning to rba 1933837 in seqno 4.
2015-05-21 09:39:33 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, repraca.prm: Error mapping from HIS.MET_NUI_ALLERGEN to HIS.MET_NUI_ALLERGEN
.
2015-05-21 09:39:33 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, repraca.prm: PROCESS ABENDING.
2015-05-21 09:42:33 WARNING OGG-00947 Oracle GoldenGate Manager for Oracle, mgr.prm: Lag for REPLICAT REPRACA is 00:11:17 (checkpoint updated 00:02:59 ag
o).
?
logdump 找到数据更改信息
Logdump 519 >sfh
___________________________________________________________________
Hdr-Ind : E (x45) Partition : . (x04)
UndoFlag : . (x00) BeforeAfter: A (x41)
RecLength : 396 (x018c) IO Time : 2015/05/21 09:28:15.994.354
IOType : 115 (x73) OrigNode : 255 (xff)
TransInd : . (x03) FormatType : R (x52)
SyskeyLen : 0 (x00) Incomplete : . (x00)
AuditRBA : 21 AuditPos : 214992528
Continued : N (x00) RecCount : 1 (x01)
2015/05/21 09:28:15.994.354 GGSPK Update Len 396 RBA 1933837 --更新语句问题 手动更新,跳过该语句...
Name: HIS.MET_NUI_ALLERGEN
After Image: Partition 4 G s
00c5 0000 000b 0000 0007 3230 3635 3630 3700 0100 | ..........2065607...
0500 0000 0131 0002 0008 0000 0004 4139 3939 0003 | .....1........A999..
000a 0000 0006 b0d7 bcd3 bada 0004 0005 0000 0001 | ....................
3300 0500 0500 0000 0131 0006 0004 ffff 0000 0007 | 3........1