3） Create and edit the parameter file for Extract 'mypump':
GGSCI > EDIT PARAMS mypump
Add following lines to this parameter file:
EXTRACT mypump
RMTHOST rac12box-scan, MGRPORT 7809
RMTTRAIL /mycloudfs/goldengate/dirdat/rt
PASSTHRU
TABLE hr.*;
NOTE: RMTHOST is the target host. If you also prefer to set up HA on the target system, specify the VIP for your target system as RMTHOST,
otherwise just use the IP address/hostname of your target system.
4） Start Extract 'myext' and 'mypump':
GGSCI > START myext
GGSCI > START mypump
5） Check the status of OGG processes:
GGSCI > info all
第六阶段：在目标端配置Replicat group
1） Create a Replicat group 'rept', which reads trails from Extract 'mypump':
GGSCI > ADD REPLICAT rept, EXTTRAIL /mycloudfs/goldengate/dirdat/rt, nodbcheckpoint
2） Create and edit the parameter file for Replicat 'rept':
GGSCI > EDIT PARAMS rept
Add following lines to this parameter file, assume the same ORACLE_HOME and target database 'ggdb' as in source ODA environment:
REPLICAT rept
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/dbhome_1")
USERID ggs@ggdb,PASSWORD ggs
ASSUMETARGETDEFS
HANDLECOLLISIONS
REPERROR (DEFAULT, DISCARD)
DDLERROR DEFAULT DISCARD
DDLOPTIONS REPORT
DISCARDFILE /mycloudfs/goldengate/repsz.dsc,append,megabytes 100
MAP hr.*, TARGET hr.*;
NOTE: make sure the SQL*Net connection string 'ggdb' works.
3） Start Replicat 'rept':
GGSCI > START rept
4） Check the status of OGG processes:
GGSCI > info all
第七阶段：验证Goldengate功能