One of the Replicat failed with below error.
Aborted grouped transaction on 'SCH.TAB', Mapping error.
On source side - Primary key was modified for this table. This was done by disabling and enabling PK.
--> Failed while updating a record on table SCH.TAB
Aborting transaction on ./dirdat/e2
beginning at seqno 36 rba 31942126
error at seqno 36 rba 31942126
Problem replicating SCH.TAB to SCH.TAB
Mapping problem with compressed update record (target format)...
*
ABSOLUTE_NODE_VALUE = 1010110253210001
SOFT_DELETE = Y
DATE_MODIFIED = 2015-06-22 16:16:34
MODIFIED_BY = xxxx
*
à There was no record matching this criteria during issue time.
However there is a record now.
SQL> select * from SCH.TAB where
ABSOLUTE_NODE_VALUE = 1010110253210001 and SOFT_DELETE = 'Y';
no rows selected
à All constraints are “ENABLED” and “VALIDATED”
SQL> select constraint_name, constraint_type, status,
validated from dba_constraints where owner='SCH' and table_name='TAB';
CONSTRAINT_NAME
C STATUS VALIDATED
------------------------------ - -------- -------------
SYS_C0048522
C ENABLED VALIDATED
SYS_C0048521
C ENABLED VALIDATED
SYS_C0048520
C ENABLED VALIDATED
SYS_C0048519
C ENABLED VALIDATED
SYS_C0048518
C ENABLED VALIDATED
SYS_C0048517
C ENABLED VALIDATED
SYS_C0048516
C ENABLED VALIDATED
SYS_C0048515
C ENABLED VALIDATED
à Supplemental logging is disabled as this is target and uni directional replication
SQL> select supplemental_log_data_min from v$database;
SUPPLEME
--------
NO
--> Tried by deleting and adding
trandata. However Replicat failed to start.
Process Abending : 2015-06-23 01:00:28
2015-06-23 02:49:37 INFO OGG-00987
Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle):
delete trandata SCH.TAB.
2015-06-23 02:50:39 INFO OGG-00987
Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle):
delete trandata SCH.TAB.
2015-06-23 02:50:44 INFO OGG-00987
Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle):
add trandata SCH.TAB nokeycols(NODE_ID) .
2015-06-23 02:50:57 INFO OGG-00987
Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle):
start replicat REPL1.
2015-06-23 02:50:57 INFO OGG-00963
Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from
GGSCI on host [10.173.133.36]:10051 (START REPLICAT REPL1).
2015-06-23 02:50:57 INFO OGG-00975
Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REPL1 starting.
2015-06-23 02:50:57 INFO OGG-00996
Oracle GoldenGate Delivery for Oracle, re2ocfg.prm: REPLICAT REPL1 started.
2015-06-23 02:50:58 WARNING OGG-01431 Oracle
GoldenGate Delivery for Oracle, repl1.prm: Aborted grouped transaction on
'SCH.TAB', Mapping
error.
à Now configuration was changed for this replicat and started
successfully.
MAP
SCH.TAB , TARGET
sch.tab
//Keycols for this
table was removed (
This is the fix)
2015-06-23 03:02:11 INFO OGG-00987
Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle):
edit param repl1.
2015-06-23 03:02:35 INFO OGG-01735
Oracle GoldenGate Collector for Oracle: Synchronizing
./dirdat/e2014683 to disk.
2015-06-23 03:02:35 INFO OGG-01735
Oracle GoldenGate Collector for Oracle: Synchronizing
./dirdat/e2014683 to disk.
2015-06-23 03:02:35 INFO OGG-01670
Oracle GoldenGate Collector for Oracle: Closing
./dirdat/e2014683.
2015-06-23 03:02:35 INFO OGG-01669
Oracle GoldenGate Collector for Oracle: Opening
./dirdat/e2014684 (byte -1, current EOF 0).
2015-06-23 03:02:41 INFO OGG-00987
Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle):
start replicat repl1.
2015-06-23 03:04:31 INFO OGG-01735
Oracle GoldenGate Collector for Oracle: Synchronizing
./dirdat/e2003725 to disk.
2015-06-23 03:04:31 INFO OGG-01670
Oracle GoldenGate Collector for Oracle: Closing
./dirdat/e2003725.
2015-06-23 03:04:31 INFO OGG-01669
Oracle GoldenGate Collector for Oracle: Opening
./dirdat/e2003726 (byte -1, current EOF 0).
à Once the replicat completed the update (that was failed) we stopped the replicat.
From Table SCH.TAB to SCH.TAB:
#
inserts: 0
#
updates:
1
#
deletes: 0
#
discards: 0
2015-06-23 03:04:33 INFO OGG-01021
Oracle GoldenGate Delivery for Oracle, repl1.prm: Command received from
GGSCI: GETLAG.
2015-06-23 03:04:45 INFO OGG-00987
Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle):
stop replicat REPL1.
2015-06-23 03:04:46 INFO OGG-01021
Oracle GoldenGate Delivery for Oracle, repl1.prm: Command received from
GGSCI: STOP.
2015-06-23 03:04:46 INFO OGG-00994
Oracle GoldenGate Delivery for Oracle, repl1.prm: REPLICAT REPL1 stopped
normally.
à Now keycol is added back for hierarchy table and started
replicat.
2015-06-23 03:05:20 INFO OGG-00987
Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle):
edit param repl1.
2015-06-23 03:05:26 INFO OGG-01735
Oracle GoldenGate Collector for Oracle: Synchronizing
./dirdat/e2014684 to disk.
2015-06-23 03:05:50 INFO OGG-00975
Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REPL1 starting.
2015-06-23 03:05:50 INFO OGG-00995
Oracle GoldenGate Delivery for Oracle, re2ocfg.prm: REPLICAT REPL1 starting.
2015-06-23 03:05:50 INFO OGG-03035
Oracle GoldenGate Delivery for Oracle, re2ocfg.prm: Operating system
character set identified as UTF-8. Locale: en_US, LC_ALL:.