新手安装配置请参考：在Windows中 基于Oracle GoldenGate （OGG）进行Oracle->Oracle数据库同步配置（超详细）
一、 ODBC 数据源设置
1、打开ODBC数据源应用
2、选择
系统 DSN > 添加
3、创建新数据源，根据SQL Server的版本选择相应的驱动程序
4、注意 “名称” ：
DSN001，填写的名称后面需要使用。
5、根据引导添加完成后，开始配置OGG
二、【源端】
1、配置MGR管理器进程：EDIT PARAMS MGR
GGSCI (custom04) 1> EDIT PARAMS MGR
2、填写内容
port 2000
dynamicportlist 2001-2005
autorestart extract *,waitminutes 2,retries 5
3、启动MGR管理器进程：start mgr
GGSCI (custom04) 2> start mgr
Manager started.
4、查看MGR管理器进程：info mgr
GGSCI (custom04) 3> info mgr
Manager is running (IP port Win10.2000, Process ID 13820).
5、创建采集投递进程：ADD EXTRACT EJWINIT, SOURCEISTABLE
GGSCI (custom04) 4> ADD EXTRACT EJWINIT, SOURCEISTABLE
6、查看创建的进程：INFO EXTRACT *, TASKS
GGSCI (custom04) 5> INFO EXTRACT *, TASKS
EXTRACT EJWINIT Last Started 2019-01-31 12:37 Status STOPPED
Checkpoint Lag Not Available
Log Read Checkpoint Table JW_USER.T_USERINFO
2019-01-31 12:37:15 Record 5
Task SOURCEISTABLE
7、编辑配置文件：EDIT PARAMS EJWINIT
GGSCI (custom04) 6> EDIT PARAMS EJWINIT
8、填写内容【注意：1.DSN001 为上面添加ODBC数据源的名称，2.修改用户名、密码，3.新增表tab、tab2并添加10条数据】
EXTRACT EJWINIT
sourcedb DSN001 userid ogg, password 123456
RMTHOST 172.16.11.11, MGRPORT 2000
RMTTASK REPLICAT, GROUP RJWINIT
table dbo.tab;
table dbo.tab2;
9、启动进程【注意：需在配置完目标端的接收进程后在执行】：START EXTRACT EJWINIT
GGSCI (custom04) 7> START EXTRACT EJWINIT
10、查看运行情况 ：VIEW REPORT EJWINIT
GGSCI (custom04) 8> VIEW REPORT EJWINIT
....略
2019-01-31 12:37:15 INFO OGG-02911 Processing table JW_USER.T_USERINFO.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2019-01-31 12:37:16 (activity since 2019-01-31 12:37:04)
Output to RJWINIT:
From Table JW_USER.T_USERINFO:
# inserts: 5
# updates: 0
# deletes: 0
# discards: 0
REDO Log Statistics
Bytes parsed 0
Bytes output 741
三、【目标端】
1、配置MGR管理器进程：EDIT PARAMS MGR
GGSCI (custom04) 1> EDIT PARAMS MGR
2、填写内容
port 2000
dynamicportlist 2001-2005
autorestart extract *,waitminutes 2,retries 5
ACCESSRULE, PROG *, IPADDR 172.16.11.11, ALLOW
3、启动MGR管理器进程：start mgr
GGSCI (custom04) 2> start mgr
Manager started.
4、查看MGR管理器进程：info mgr
GGSCI (custom04) 3> info mgr
Manager is running (IP port Win10.2000, Process ID 13820).
5、创建接收进程：add replicat RJWINIT,specialrun
GGSCI (custom04) 4> add replicat RJWINIT,specialrun
6、查看创建的进程：INFO REPLICAT *, TASKS
GGSCI (custom04) 5> INFO REPLICAT *, TASKS
REPLICAT RJWINIT Initialized 2019-01-31 12:38 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:42:44 ago)
Log Read Checkpoint Not Available
Task SPECIALRUN
7、编辑配置文件：edit params RJWINIT
GGSCI (custom04) 6> edit params RJWINIT
8、填写内容【注意：1.DSN001 为上面添加ODBC数据源的名称，2.修改用户名、密码，3.新增表tab、tab2】
REPLICAT RJWINIT
ASSUMETARGETDEFS
targetdb DSN001 userid ogg password 123456
DISCARDFILE ./dirrpt/RJWINIT.dsc, PURGE
MAP dbo.tab, target dbo.tab;
MAP dbo.tab2, target dbo.tab2;
9、启动进程：START REPLICAT RJWINIT
GGSCI (custom04) 7> START REPLICAT RJWINIT
10、查看运行情况 ：VIEW REPORT RJWINIT
GGSCI (custom04) 8> VIEW REPORT RJWINIT
....略
2019-01-31 12:37:14 INFO OGG-03522 Setting session time zone to source database time zone 'GMT'.
2019-01-31 12:37:14 WARNING OGG-02760 ASSUMETARGETDEFS is ignored because trail file contains table definitions.
2019-01-31 12:37:14 INFO OGG-06505 MAP resolved (entry JW_USER.T_USERINFO): MAP "JW_USER"."T_USERINFO", target JWUSER.T_USERINFO.
2019-01-31 12:37:14 INFO OGG-02756 The definition for table JW_USER.T_USERINFO is obtained from the trail file.
2019-01-31 12:37:14 INFO OGG-06511 Using following columns in default map by name: id, name.
2019-01-31 12:37:14 INFO OGG-06510 Using the following key columns for target table JWUSER.T_USERINFO: id.
2019-01-31 12:37:14 INFO OGG-03010 Performing implicit conversion of column data from character set zhs16gbk to UTF-8.
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2019-01-31 12:37:19 (activity since 2019-01-31 12:37:14)
From Table JW_USER.T_USERINFO to JWUSER.T_USERINFO:
# inserts: 5
# updates: 0
# deletes: 0
# discards: 0
CACHE OBJECT MANAGER statistics
....略
