Pages

Thursday, June 16, 2016

Sample Manager GoldenGate Extract, Pump, Replicat Process


-- Sample Manager process # 
-- Manager runs on default port number 7809 # 
PORT 7809
-- Lag Time reporting #
LAGINFOMINUTES 0
LAGREPORTMINUTES 5
LAGCRITICALSECONDS 30
-- Any process got abended, manager will auto restart the goldengate processes #
AUTORESTART EXTRACT E*, RETRIES 5, WAITMINUTES 2, RESETMINUTES 1440
AUTORESTART EXTRACT P*, RETRIES 5, WAITMINUTES 2, RESETMINUTES 1440
AUTORESTART REPLICAT R*, RETRIES 5, WAITMINUTES 2, RESETMINUTES 1440
-- House Keeping jobs, purging used trails using check point  
PURGEOLDEXTRACTS /local_trail_directory/*, USECHECKPOINTS, MINKEEPHOURS 1, FREQUENCYMINUTES 30

NAMING CONVENTION should be followed in any environment we are Implementing GoldenGate#
E starts with Extract 
P starts with Pump
R starts with Replicat 

GoldenGate Extract process should not exceed 8 Characters
Before adding Any goldengate for any table
we have to make sure, we need to enable supplemental logging for table ##

-- Sample Extract Process
-- GGSCI> add extract ework, tranlog, begin now
-- GGSCI> add exttrail /gg_trail/local/da, extract ework, megabytes 500
extract ework
userid ggsuser, password oracle
exttrail /gg_trail/local/da
discardfile /gg_home/dsc/ework.dsc, megabytes 100, append
discardrollover at 06:00 on saturday
TRANLOGOPTIONS INCLUDEREGIONID
table hr.emp;

Collect the enough Information to configure GoldenGate pump process # 
rmthost      # happy.world.com
port number  # 7809
local Trail  # /gg_trail/local
remote trail # /gg_trail/remote 
table hr.emp

--add extract pwork, exttrailsource /gg_trail/local/da, begin now
--add rmttrail /gg_trail/remote/da, extract pwork, megabytes 500
extract pwork
userid ggsuser, password oracle
reportcount every 24 hours, rate
discardfile /gg_home/dsc/pwork.dsc, megabytes 100, append
discardrollover at 06:00 on saturday
rmthost zhappy.world.com, mgrport 7809
rmttrail  /gg_trail/remote/da
table hr.emp;


On Target we have to configure replicat ## 
rmttrail # /gg_trail/remote/
checkpoint table information # ckptab

GGSCI 5> dblogin userid ggsuser, password oracle
Successfully logged into database.
GGSCI 6> add checkpointtable ggsuser.ckptab 

—Sample Replicat PROCESS 
--add replicat rwork,exttrail /gg_trail/remote/da,checkpointtable ggsuser.ckptab
replicat rwork
assumetargetdefs
userid ggsuser, password oracle
reportcount every 24 hours, rate
discardfile /gg_home/dsc/rwork.dsc, megabytes 100, append
discardrollover at 21:00
reperror (default, discard)
map hr.emp, target scott.emp;

--Nikhil Tatineni--
--GoldenGate --