I've configured Oracle goldengate for one of my schema. On target database my data is not replicating. Please help
I'm using data-pump for replication. Please find the following config files:
=============
On Source:
=============
mgr parameter file:
--------------------------------
port 7809
dynamicportlist 7810-7830,7833,7835
--autorestart extract extatm,retries 500,waitminutes 1,resetminutes 600
--autorestart extract extcbs,retries 500,waitminutes 1,resetminutes 600
--autorestart extract dpatm,retries 500,waitminutes 1,resetminutes 600
--autorestart extract dpcbs,retries 500,waitminutes 1,resetminutes 600
--autorestart replicat drrepatm,retries 500,waitminutes 1,resetminutes 600
--autorestart replicat drrepcbs,retries 500,waitminutes 1,resetminutes 600
--autorestart extract extaml,retries 500,waitminutes 1,resetminutes 600
--autorestart extract extrm,retries 500,waitminutes 1,resetminutes 600
--autorestart extract extinb,retries 500,waitminutes 1,resetminutes 600
--autorestart extract dpaml,retries 500,waitminutes 1,resetminutes 600
--autorestart extract dprm,retries 500,waitminutes 1,resetminutes 600
--autorestart extract dpinb,retries 500,waitminutes 1,resetminutes 600
--autorestart replicat drrepaml,retries 500,waitminutes 1,resetminutes 600
--autorestart replicat drreprm,retries 500,waitminutes 1,resetminutes 600
--autorestart replicat drrepinb,retries 500,waitminutes 1,resetminutes 600
userid ggs_owner,password ggs_owner
purgeoldextracts /home/oracle/ogg/dirdat/*,usecheckpoints,minkeepdays 5
EXT process:
--------------------
extract extrm
userid ggs_owner,password ggs_owner
statoptions resetreportstats
reportcount every 2 hours,rate
report at 01:00
reportrollover at 01:15
tranlogoptions asmuser sys@asm,asmpassword asmdba
grouptransops 2000
discardfile /home/oracle/ogg/dirdat/discard/extrm_discard.txt,append,megabytes 10
discardrollover at 02:00 on sunday
exttrail /home/oracle/ogg/dirdat/ld
ddl include mapped objname riskmate.*;
ddloptions addtrandata retryop retrydelay 20 maxretries 20,report
sequence riskmate.*;
table riskmate.*;
DP Processes:
----------------------------
extract dprm
userid ggs_owner,password ggs_owner
discardfile /home/oracle/ogg/dirdat/discard/dprm_discard.txt,append,megabytes 10
rmthost 10.10.250.198,mgrport 7809,tcpbufsize 100000
rmttrail /home/oracle/ogg/dirdat/rd
passthru
sequence riskmate.*;
table riskmate.*;
=========
On Target:
=========
Manager:
--------------
port 7809
dynamicportlist 7810-7830,7833,7835,9001-9010
userid ggs_owner,password ggs_owner
purgeoldextracts /home/oracle/ogg/dirdat/*,usecheckpoints,minkeepdays 5
autorestart replicat repatm,retries 500,waitminutes 1,resetminutes 600
autorestart replicat repcbs,retries 500,waitminutes 1,resetminutes 600
autorestart extract drextatm,retries 500,waitminutes 1,resetminutes 600
autorestart extract drextcbs,retries 500,waitminutes 1,resetminutes 600
autorestart extract drdpatm,retries 500,waitminutes 1,resetminutes 600
autorestart extract drdpcbs,retries 500,waitminutes 1,resetminutes 600
autorestart replicat repaml,retries 500,waitminutes 1,resetminutes 600
autorestart replicat reprm,retries 500,waitminutes 1,resetminutes 600
autorestart replicat repinb,retries 500,waitminutes 1,resetminutes 600
autorestart extract drextaml,retries 500,waitminutes 1,resetminutes 600
autorestart extract drextrm,retries 500,waitminutes 1,resetminutes 600
autorestart extract drextinb,retries 500,waitminutes 1,resetminutes 600
autorestart extract drdpaml,retries 500,waitminutes 1,resetminutes 600
autorestart extract drdprm,retries 500,waitminutes 1,resetminutes 600
autorestart extract drdpinb,retries 500,waitminutes 1,resetminutes 600
Replicate process:
--------------------------
replicat reprm
setenv (ORACLE_SID=seva)
userid ggs_owner,password ggs_owner
batchsql batchesperqueue 100,opsperbatch 2000
grouptransops 2000
dboptions deferrefconst
allownoopupdates
assumetargetdefs
discardfile /home/oracle/ogg/dirdat/discard/reprm_discard.txt,append,megabytes 100
statoptions resetreportstats
reportcount every 2 hours,rate
report at 01:00
reportrollover at 01:15
discardrollover at 02:00 on sunday
ddl include all
ddlerror default ignore retryop
ddloptions report
map riskmate.*,target riskmate.*;
Waiting for your reply...
Thanks,
Simon