同步目标端失败报错：
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 viablecolumns 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: executed 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’, Databaseerror 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_ALLERGEN.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 ago).
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 : 214992528Continued : N (x00) RecCount : 1 (x01)2015/05/21 09:28:15.994.354 GGSPK Update Len 396 RBA 1933837 –更新语句问题 手动更新，跳过该语句…Name: HIS.MET_NUI_ALLERGENAfter 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………. 000a 0000 0006 3030 3134 3832 0008 0015 0000 3230 | ……001482……20 3135 2d30 352d 3134 3a31 343a 3534 3a31 3500 0900 | 15-05-14:14:54:15… 04ff ff00 0000 0a00 1500 0030 3030 312d 3031 2d30 | ………..0001-01-0 Before Image Len 199 (x000000c7)KeyLen 197 (x000000c5)KeyCol 0 (x0000), Len 11 (x000b) 0000 0007 3230 3635 3630 37 | ….2065607 KeyCol 1 (x0001), Len 5 (x0005) 0000 0001 31 | ….1 KeyCol 2 (x0002), Len 8 (x0008) 0000 0004 4139 3939 | ….A999 KeyCol 3 (x0003), Len 10 (x000a) 0000 0006 b0d7 bcd3 bada | ………. KeyCol 4 (x0004), Len 5 (x0005) 0000 0001 33 | ….3 KeyCol 5 (x0005), Len 5 (x0005) 0000 0001 31 | ….1 KeyCol 6 (x0006), Len 4 (x0004) ffff 0000 | …. KeyCol 7 (x0007), Len 10 (x000a) 0000 0006 3030 3134 3832 | ….001482 KeyCol 8 (x0008), Len 21 (x0015) 0000 3230 3135 2d30 352d 3134 3a31 343a 3534 3a31 | ..2015-05-14:14:54:1 35 | 5 KeyCol 9 (x0009), Len 4 (x0004) ffff 0000 | …. KeyCol 10 (x000a), Len 21 (x0015) 0000 3030 3031 2d30 312d 3031 3a30 303a 3030 3a30 | ..0001-01-01:00:00:0 30 | 0 KeyCol 11 (x000b), Len 6 (x0006) 0000 0002 4441 | ….DA KeyCol 12 (x000c), Len 13 (x000d) 0000 0009 4147 3336 3831 3030 38 | ….AG3681008 KeyCol 13 (x000d), Len 10 (x000a) 0000 0000 0000 0000 0001 | ………. KeyCol 14 (x000e), Len 4 (x0004) ffff 0000 | …. After Image Len 197 (x000000c5)Column 0 (x0000), Len 11 (x000b) 0000 0007 3230 3635 3630 37 | ….2065607 Column 1 (x0001), Len 5 (x0005) 0000 0001 32 | ….2 ——————-这个地方修改Column 2 (x0002), Len 8 (x0008) 0000 0004 4139 3939 | ….A999 Column 3 (x0003), Len 10 (x000a) 0000 0006 b0d7 bcd3 bada | ………. Column 4 (x0004), Len 5 (x0005) 0000 0001 33 | ….3 Column 5 (x0005), Len 5 (x0005) 0000 0001 31 | ….1 Column 6 (x0006), Len 4 (x0004) ffff 0000 | …. Column 7 (x0007), Len 10 (x000a) 0000 0006 3030 3134 3832 | ….001482 Column 8 (x0008), Len 21 (x0015) 0000 3230 3135 2d30 352d 3134 3a31 343a 3534 3a31 | ..2015-05-14:14:54:1 35 | 5 Column 9 (x0009), Len 4 (x0004) ffff 0000 | …. Column 10 (x000a), Len 21 (x0015) 0000 3030 3031 2d30 312d 3031 3a30 303a 3030 3a30 | ..0001-01-01:00:00:0 30 | 0 Column 11 (x000b), Len 6 (x0006) 0000 0002 4441 | ….DA Column 12 (x000c), Len 13 (x000d) 0000 0009 4147 3336 3831 3030 38 | ….AG3681008 Column 13 (x000d), Len 10 (x000a) 0000 0000 0000 0000 0001 | ………. Column 14 (x000e), Len 4 (x0004) ffff 0000 | …. GGS tokens:TokenID x52 ‘R’ ORAROWID Info x00 Length 204141 4158 365a 4141 3741 414b 6957 6e41 4251 0001 | AAAX6ZAA7AAKiWnABQ.. TokenID x4c ‘L’ LOGCSN Info x00 Length 103235 3931 3637 3033 3930 | 2591670390 TokenID x36 ‘6’ TRANID Info x00 Length 93230 322e 3133 2e38 36 | 202.13.86 Logdump 520 >
关键命令
>pos &>ghdr on>detail data>ggstoken detai
alter replicat REPRACA,extrba 1934359
手动更新表，，跳过该事务，问题暂时解决
一个人目睹沿途的风景，拿着相机，拍下沿途上的风景，
