Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Goldengate Running but not replicating

Richard OwusuNov 19 2024

We are using GoldenGate version 19.1.0.0.4 for replicating data from a Oracle 19C source DB to Oracle 19C target DB trying for bidirectional replication.

All the processes(EXTRACT, PUMP and REPLICAT) are running as usual, but the updates i make in the source table are not replicating in target tables.

When i run the stats Extract PUMPFE1 process i get No Active Extraction maps. The same on Target db.

I did not see any error in the ggserr.log

See below for your information.

Source DB

GGSCI (pr-emv-appdb-02) 5> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EXTBO 00:00:00 00:00:06
EXTRACT RUNNING PUMPFE1 00:00:00 00:00:02
REPLICAT RUNNING REPA1FE1 00:00:00 00:00:03
REPLICAT RUNNING REPD1FE1 00:00:00 00:00:05
REPLICAT RUNNING REPD2FE1 00:00:00 00:00:07
REPLICAT RUNNING REPR1FE1 00:00:00 00:00:06
REPLICAT RUNNING REPT1FE1 00:00:00 00:00:04

GGSCI (pr-emv-appdb-02) 8> stats EXTRACT PUMPFE1

Sending STATS request to EXTRACT PUMPFE1 ...

No active extraction maps.

GGSCI (pr-emv-appdb-02) 9>

Target DB

GGSCI (pr-emv-switchdb-01) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EXTFE1 00:00:04 00:00:09
EXTRACT RUNNING PUMPBO 00:00:00 00:00:00
REPLICAT RUNNING REPA1BO 00:00:00 00:00:08
REPLICAT RUNNING REPD1BO 00:00:00 00:00:09
REPLICAT RUNNING REPD2BO 00:00:00 00:00:01
REPLICAT RUNNING REPR1BO 00:00:00 00:00:02

GGSCI (pr-emv-switchdb-01) 2> stats EXTRACT PUMPBO

Sending STATS request to EXTRACT PUMPBO ...

No active extraction maps.

GGSCI (pr-emv-switchdb-01) 3>

Kindly assist me to resolve this issue as i am pretty new to GG.
Thanks.

Comments
Post Details
Added on Nov 19 2024
2 comments
376 views