GoldenGate

Friends

I have the following situation:

TableA (ID, Name):

ID#3 and 4 were added before I started the Golden Gate extract process hence they should not be copied to the destination table (TableB). TableB (ID, Name) is the destination table which has ID#1 and 2.

I want to replicate just ID#3 and 4 into the destination table. So I added the extract (named EXTORA)

ADD EXTRACT EXTORA, INTEGRATED TRANLOG, SCN 37980219

I then added the Remote trail:

ADD RMTTRAIL ./dirdat/rt, EXTRACT EXTORA, MEGABYTES 10

and started the extract:

START EXTRACT EXTORA ATCSN 37980219

I added the replicate step :

ADD REPLICAT REPORA, INTEGRATED, EXTTRAIL ./dirdat/rt

and start the replicate step:

START REPLICAT REPORA, ATCSN 37980219

Here is my extract parameters:

EXTRACT EXTORA
USERID c##ggadmin, PASSWORD oracle
RMTHOST rl-linux-srv02.db.net, MGRPORT 7809
RMTTRAIL ./dirdat/rt
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
SOURCECATALOG orclpdb
TABLE ogg.emp;

And replicate parameters:

REPLICAT REPORA
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/repora.dsc, PURGE, MEGABYTES 100
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
DBOPTIONS INTEGRATEDPARAMS(parallelism 6)
USERID c##ggadmin@dbembdw01, PASSWORD oracle
MAP orclpdb.ogg.emp, TARGET dbembdw01.ogg.emp;

The issue is the records are not getting replicated to the destination table (TableB). However, if a new record is inserted into TableA it gets replicated to TableB. Can someone please help me understand why records at a specific CSN is not replicating here?

I am using Golden Gate version: OGG 12.3.0.1 and Oracle DB is 12.2

Thanks

Sabya