Synchronization Target failed Error:
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 Automat Ically.
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 succes Sfully.
2015-05-21 09:39:33 INFO OGG-00893 Oracle GoldenGate Delivery for Oracle, Repraca.prm:SQL statement executed succes Sfully.
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 was defined for Table Met_nui_allergen. All viable
Columns'll is used to represent the key, and may not guarantee uniqueness. Keycols May is 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, Continuin G 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 o N ' 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 he. 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 the 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: (Checkpoint updated 00:02:59 AG
O).
Logdump Find Data change information
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 GGSPKUpdateLen 396 RBA 1933837--UPDATE statement Issue manual update, skip the statement ...
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 .....
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 0030 3030 312d 3031 2d30 | ........... 0001-01-0
Before Image Len 199 (X000000C7)
Keylen 197 (X000000C5)
KeyCol 0 (x0000), Len (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 (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 (x000a)
0000 0006 3030 3134 3832 | .... 001482
KeyCol 8 (x0008), Len (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 (x000a), Len (x0015)
0000 3030 3031 2d30 312d 3031 3a30 303a 3030 3a30 | 0001-01-01:00:00:0
30 | 0
KeyCol (x000b), Len 6 (x0006)
0000 0002 4441 | .... DA
KeyCol (x000c), Len (x000d)
0000 0009 4147 3336 3831 3030 38 | .... AG3681008
KeyCol (x000d), Len (x000a)
0000 0000 0000 0000 0001 | ..........
KeyCol (x000e), Len 4 (x0004)
FFFF 0000 | ....
After Image Len 197 (X000000C5)
Column 0 (x0000), Len (x000b)
0000 0007 3230 3635 3630 37 | .... 2065607
Column 1 (x0001), Len 5 (x0005)
0000 0001 32 | ..... 2-------------------Change this place
Column 2 (x0002), Len 8 (x0008)
0000 0004 4139 3939 | .... A999
Column 3 (x0003), Len (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 (x000a)
0000 0006 3030 3134 3832 | .... 001482
Column 8 (x0008), Len (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 Ten (x000a), Len (x0015)
0000 3030 3031 2d30 312d 3031 3a30 303a 3030 3a30 | 0001-01-01:00:00:0
30 | 0
Column One (x000b), Len 6 (x0006)
0000 0002 4441 | .... DA
Column (x000c), Len (x000d)
0000 0009 4147 3336 3831 3030 38 | .... AG3681008
Column (x000d), Len (x000a)
0000 0000 0000 0000 0001 | ..........
Column (x000e), Len 4 (x0004)
FFFF 0000 | ....
GGS Tokens:
Tokenid x52 ' R ' orarowid Info x00 Length 20
4141 4158 365a 4141 3741 414b 6957 6e41 4251 0001 | AAAX6ZAA7AAKIWNABQ.
Tokenid x4c ' L ' LOGCSN Info x00 Length 10
3235 3931 3637 3033 3930 |2591670390
Tokenid x36 ' 6 ' tranid Info x00 Length 9
3230 322e 3133 2e38 36 | 202.13.86
Logdump 520 >
Key commands
>pos &>GHDR on>detail Data>ggstoken Detai
Alter REPLICAT Repraca,extrba 1934359
Manually updating the table, skipping the transaction, and temporarily resolving the problem
SQL Error 1403:ogg Synchronization