Hi Experts,
I am just beginner for Goldengate and i have a 2 Linux machine and DB's are created as LABPRD1 (Machine 1 ) , LABPRD2 (Machine 2). Also goldengate is installed on both servers and Uni-directional replications worked fine. But moving forward to next level to test Bi-Directional, its giving me the trouble . Replicate process is went down on source & not starting post 1 ddl operation was made.
Source:
GGSCI (rhelprddb01.lab.com as ggadmsrc@labprd1) 142> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:01
EXTRACT RUNNING PUMP1 00:00:00 00:00:07
REPLICAT ABENDED RPLIC1 00:00:00 00:40:54 <== It was running state before i did transaction on Target site
Target:
GGSCI (rhelprddb02.lab.com as ggadmtrg@labprd2) 79> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:01
EXTRACT RUNNING PUMP1 00:00:00 00:00:08
REPLICAT RUNNING RPLIC1 00:00:00 00:00:09
RPLIC1 log: ( I am suspecting this error shows its trying to reapply the transaction was performed here in source and its captured by target Extract again . Not sure)
2020-05-25 14:48:54 WARNING OGG-01004 Aborted grouped transaction on GGADMSRC.DEPT1, Database error 1 (OCI Error ORA-0
0001: unique constraint (GGADMSRC.PK_DEPT) violated (status = 1), SQL <INSERT INTO "GGADMSRC"."DEPT1" ("DEPTNO","DNAME",
"LOC") VALUES (:a0,:a1,:a2)>).
2020-05-25 14:48:54 WARNING OGG-01003 Repositioning to rba 2082 in seqno 0.
2020-05-25 14:48:54 WARNING OGG-01154 SQL error 1 mapping GGADMTRG.DEPT2 to GGADMSRC.DEPT1 OCI Error ORA-00001: unique
constraint (GGADMSRC.PK_DEPT) violated (status = 1), SQL <INSERT INTO "GGADMSRC"."DEPT1" ("DEPTNO","DNAME","LOC") VALUE
S (:a0,:a1,:a2)>.
2020-05-25 14:48:54 ERROR OGG-01296 Error mapping from GGADMTRG.DEPT2 to GGADMSRC.DEPT1.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
2020-05-25 14:48:54 INFO OGG-02333 Reading /opt/app/oracle/product/gg_home/trail/TR000000000, current RBA 2,082, 0
records, m_file_seqno = 0, m_file_rba = 2,230.
Report at 2020-05-25 14:48:54 (activity since 2020-05-25 14:48:54)
From Table GGADMTRG.DEPT2 to GGADMSRC.DEPT1:
# inserts: 0
# updates: 0
# deletes: 0
# upserts: 0
# discards: 1
Thanks
Bala