Home » Server Options » Replication » DML operations not applying on target database (DB 11g, GG11, linux)
DML operations not applying on target database [message #665201] Fri, 25 August 2017 08:46
sanovia_lesko
Messages: 1
Registered: August 2017
Junior Member
HI All,

I'm having troubles with configuring Golden Gate replication. changes made on sample schema on source DB are not applying on target DB.
please verify if this setup is correct.

DB 11g EE r11.2.0.2.0 on Oracle Linux (test environment for learning purposes)

1. source machine

MGR

PORT 7809
lagreportminutes 5
laginfominutes 1
lagcriticalminutes 2
purgeoldextracts /GG_INSTALL/t*,minkeepdays 2,usecheckpoints

Exctract

extract ext1
userid ggate, password qwerty
discardfile /GG_INSTALL/discard
reportcount every 15 minutes, rate
RMTHOST db2.local, MGRPORT 7809
RMTTRAIL /GG_INSTALL/t1
DDL include ALL
exttrail /GG_INSTALL/t1
table TEST_SCHEMA.*;

Pump

extract dpe1
passthru
rmthost db2.local, mgrport 7809
rmttrail /GG_INSTALL/t1
table TEST_SCHEMA.*;

STATUSES:

GGSCI (db1.local) 46> info all


Program Status Group Lag at Chkpt Time Since Chkpt


MANAGER RUNNING
EXTRACT RUNNING DPE1 00:00:00 00:00:01
EXTRACT RUNNING EXT1 00:00:00 00:00:04

2. Target machine

MGR

PORT 7809
dynamicportlist 7900-7950
lagreportminutes 5
laginfominutes 1
lagcriticalminutes 2
purgeoldextracts /GG_INSTALL/t*, minkeepdays 2, usecheckpoints

Replicat

replicat rep1
userid ggate, password qwerty
discardfile /GG_INSTALL/discard/rep1.dsc, purge
assumetargetdefs
reportcount every 15 minutes, rate
batchsql
deferapplyinterval 5 mins
ddl include mapped
map TEST_SCHEMA.*, target TEST_SCHEMA.*;

STATUSES:

GGSCI (db2.local) 79> info all


Program Status Group Lag at Chkpt Time Since Chkpt


MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:09

List table command from GGSCI shows my test tables under test schema. no errors in logs on both side. Tran files are successfully transmuting to target machine, but any update or insert on source is not reflecting on target. any tips? thanks in advance.
Previous Topic: Pre-Requisites For Oracle Advanced Replication
Next Topic: dbms_scheduler ORA-12560: TNS:protocol adapter error
Goto Forum:
  


Current Time: Thu Mar 28 17:43:01 CDT 2024