Manhandling GoldenGate, part 3

Here are the different configuration files and such I used for the setup described in parts 1 and 2. Please note that I’ve removed the several hundred schemas for clarity, and I have exchanged the customer-specific schema names for the nonexistent SCOTT and TIGER schema names.

mgr parameter file on primary

PORT 7809
AUTOSTART EXTRACT *
AUTORESTART EXTRACT *, RETRIES 3, WAITMINUTES 5, RESETMINUTES 60
BOOTDELAYMINUTES 3
PURGEOLDEXTRACTS E:\oracle\product\12.1.2\oggcore_1\dirdat\tr*, USECHECKPOINTS

extract parameter file on primary

extract ext1
userid ggs_owner@DPSPATIAL, password XXXX
exttrail E:\oracle\product\12.1.2\oggcore_1\dirdat\tr
ROLLOVER AT 22:00
CACHEMGR CACHESIZE 8G
LOGALLSUPCOLS
UPDATERECORDFORMAT COMPACT
TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 1024)
ddl &;
include mapped objname SCOTT.* &;  
include mapped objname TIGER.* 
table SCOTT.*;                                                                    
table TIGER.*;

pump parameter file on primary

EXTRACT pump1
USERID ggs_owner@DPSPATIAL PASSWORD XXXX
RMTHOST LUDP-ESLOV.lekonc.se, MGRPORT 7809
RMTTRAIL E:\oracle\product\12.1.2\oggcore_1\dirdat\tr 
PASSTHRU
table SCOTT.*;                                                                    
table TIGER.*;

manager parameter file on secondary

PORT 7809
AUTOSTART REPLICAT *
AUTORESTART REPLICAT *, RETRIES 3, WAITMINUTES 5, RESETMINUTES 60
BOOTDELAYMINUTES 3
PURGEOLDEXTRACTS E:\oracle\product\12.1.2\oggcore_1\dirdat\tr*, USECHECKPOINTS, MINKEEPHOURS 24

replicat parameter file on secondary

REPLICAT rep1
USERID ggs_owner@DPSPATIAL, PASSWORD XXXX
discardfile E:\oracle\product\12.1.2\oggcore_1\dirdat\tr\discard\rep1_discard.txt, append, megabytes 100
DDL
DBOPTIONS SUPPRESSTRIGGERS 
SQLEXEC "ALTER SESSION SET COMMIT_WAIT='NOWAIT'";
map SCOTT.*, target SCOTT.*;                                                        
map TIGER.*, target TIGER.*;

Oracle parameters on primary/secondary

alter system set ENABLE_GOLDENGATE_REPLICATION=TRUE scope=BOTH;
alter system set streams_pool_size=2G scope=both;
alter system set recyclebin=off scope=spfile;
alter system set undo_retention=86400 scope=spfile;

GGSCI statements for the primary

dblogin userid GGS_OWNER password XXXX
add schematrandata SCOTT allcols
add schematrandata TIGER allcols
register extract ext1 database
add extract ext1, integrated tranlog, begin now
add exttrail E:\oracle\product\12.1.2\oggcore_1\dirdat\tr, extract ext1
add extract pump1, exttrailsource E:\oracle\product\12.1.2\oggcore_1\dirdat\tr , begin now
add rmttrail E:\oracle\product\12.1.2\oggcore_1\dirdat\tr, extract pump1
start ext1
start pump1

GGSCI statements for the secondary

dblogin userid GGS_OWNER password XXXX
add replicat rep1 integrated, exttrail E:\oracle\product\12.1.2\oggcore_1\dirdat\tr, begin now
start rep1 atcsn 5827928

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *