新手安裝配置請參考：在Windows中 基于Oracle GoldenGate （OGG）進行Oracle->Oracle數據庫同步配置（超詳細）

一、 ODBC 數據源設置

1、打開ODBC數據源應用

odbc 數據源

添加系統數據源

image.png

image.png

二、【源端】

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、創(chuàng)建采集投遞進程：ADD EXTRACT EJWINIT, SOURCEISTABLE

GGSCI (custom04) 4> ADD EXTRACT EJWINIT, SOURCEISTABLE

6、查看創(chuàng)建的進程：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、啟動進程【注意：需在配置完目標端的接收進程后在執(zhí)行】：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、創(chuàng)建接收進程：add replicat RJWINIT,specialrun

GGSCI (custom04) 4> add replicat RJWINIT,specialrun

6、查看創(chuàng)建的進程：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
....略