Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Goldengate extract and replicat are running, but the data is not the same

Julian CaleffaMar 31 2024

I executed a EXPDP with flashback_scn and imported to the target database

The extract and replicat are running, but we have difference between the rows..

here is my configuration

GGSCI (JDEDB) 54> view param EPRODDT4
EXTRACT EPRODDT4
setenv (ORACLE_SID="PJDE")
setenv (ORACLE_HOME="O:\Oracle\product\11.2.0\dbhome_1")
userid gg_admin, password GG_ADMIN
--FETCHOPTIONS FETCHPKUPDATECOLS
exttrail G:\OGG\dirdat\aa
TABLE PRODDTA.F0911;
TABLE PRODDTA.F564111A;
TABLE PRODDTA.F42199;
TABLE PRODDTA.F0911_MEDIDORES;
TABLE PRODDTA.F43199;
TABLE PRODDTA.F01131M;
TABLE PRODDTA.F4111;

GGSCI (JDEDB) 55> view param DPRODDT4
EXTRACT DPRODDT4
setenv (ORACLE_SID="PJDE")
setenv (ORACLE_HOME="O:\Oracle\product\11.2.0\dbhome_1")
userid gg_admin, password GG_ADMIN
RMTHOST RJDEDB,MGRPORT 7809
rmttrail G:\OGG\dirdat\aa
TABLE PRODDTA.F0911;
TABLE PRODDTA.F564111A;
TABLE PRODDTA.F42199;
TABLE PRODDTA.F0911_MEDIDORES;
TABLE PRODDTA.F43199;
TABLE PRODDTA.F01131M;
TABLE PRODDTA.F4111;

GGSCI (RJDEDB) 368> view param RPRODDT4
REPLICAT RPRODDT4
setenv (ORACLE_SID="RJDE")
setenv (ORACLE_HOME="O:\Oracle\product\11.2.0\dbhome_1")
handlecollisions
userid GG_ADMIN,password GG_ADMIN
ASSUMETARGETDEFS
INSERTMISSINGUPDATES
MAP PRODDTA.F0911,TARGET PRODDTA.F0911;
MAP PRODDTA.F564111A,TARGET PRODDTA.F564111A;
MAP PRODDTA.F42199,TARGET PRODDTA.F42199;
MAP PRODDTA.F0911_MEDIDORES,TARGET PRODDTA.F0911_MEDIDORES;
MAP PRODDTA.F43199,TARGET PRODDTA.F43199;
MAP PRODDTA.F01131M,TARGET PRODDTA.F01131M;
MAP PRODDTA.F4111,TARGET PRODDTA.F4111;

any suggestions?

Comments
Post Details
Added on Mar 31 2024
1 comment
27 views