GoldenGate初体验（单向同步）+Data Pump

最新推荐文章于 2023-06-21 17:02:50 发布

ora600

最新推荐文章于 2023-06-21 17:02:50 发布

阅读量959

点赞数

CC 4.0 BY-SA版权

分类专栏： GoldenGate

本文链接：https://blog.youkuaiyun.com/heizistudio/article/details/8717594

GoldenGate 专栏收录该内容

2 篇文章

订阅专栏

本文详细介绍了在金蝶系统中使用GoldenGate进行数据同步的过程，包括使用DataPump和Replicat组件搭建同步环境、配置参数、启动进程及测试验证等关键步骤。通过实践案例，读者可以了解如何在源端和目标端建立数据一致性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

是在上一篇基础之上，应用Data Pump

GGSCI (hadoop-m1) 154> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)? y

Sending STOP request to MANAGER ...
Request processed.
Manager stopped.

GGSCI (hadoop-m1) 157> stop REPL

Sending STOP request to REPLICAT REPL ...
Request processed.

GGSCI (hadoop-m1) 160> stop extl

Sending STOP request to EXTRACT EXTL ...
Request processed.

GGSCI (hadoop-m1) 162> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER     STOPPED
EXTRACT     STOPPED     EXTL        00:00:00      00:00:17
REPLICAT    STOPPED     REPL        00:00:00      00:00:40

-------------------------------------------------------------------------------

开始搭建

GGSCI (hadoop-m1) 174> delete extl -------删掉重建了
Deleted EXTRACT EXTL.

GGSCI (hadoop-m1) 175> dblogin userid goldengate,password goldengate
Successfully logged into database

GGSCI (gg1) 11> add extract ext1,tranlog, begin now

GGSCI (gg1) 12> add exttrail /u01/ggate/dirdat/lt, extract extl

GGSCI (hadoop-m1) 238> view params extl

extract extl
userid goldengate@duxiu,password goldengate
exttrail /home/oracle/golddir/w1
table scott.*;

在Source 端创建Data Pump Group

GGSCI (gg1) 49> add extract dpump,exttrailsource /home/oracle/golddir/w1

EXTRACT added.

--这里指定我们localtrail 的位置。

配置Data Pump 参数：

GGSCI (hadoop-m1) 239> view params dpump

extract dpump
userid goldengate@duxiu,password goldengate
rmthost 192.168.80.200, mgrport 7801
rmttrail /home/oracle/golddir/w2
passthru
table scott.*;

在Target 端配置Replicat 进程

--这里配置进程的checkpoint

GGSCI (gg2) 6> EDIT PARAMS ./GLOBALS

GGSCHEMA goldengate
CHECKPOINTTABLE goldengate.checkpoint

添加如上2条记录。

GGSCI (gg2) 12> dblogin userid goldengate@jour password goldengate

Successfully logged into database.

--连接到DB 的GGATE 用户，在db里创建checkpoint表

GGSCI (gg2) 13> add checkpointtable goldengate.checkpoint

Successfully created checkpoint table GGATE.CHECKPOINT.

--创建replicat group

GGSCI (gg2) 14> add replicat rep1,exttrail /home/oracle/golddir/w2, checkpointtablegoldengate.checkpoint

REPLICAT added.

--注意这里的目录要和我们的data pump 指定的目录一致。

修改rep1参数：

GGSCI (hadoop-m1) 240> view params rep1

replicat rep1
ASSUMETARGETDEFS
userid goldengate@jour,password goldengate
discardfile /home/oracle/golddir/reptmy.dsc, append, megabytes 10
map scott.*, target scott.*;

开始测试

在Source 端启动Extract和data pump 进程

GGSCI (gg1) 60> start extract ext1

Sending START request to MANAGER ...

EXTRACT EXT1 starting

GGSCI (gg1) 61> start extract dpump

Sending START request to MANAGER ...

EXTRACT DPUMP starting

GGSCI (gg1) 76> info dpump

------------------------------------------------------

主库

SQL> insert into dept values(60,'usa','shanghai');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON
        50 DBA            peijing
        60 usa            shanghai

6 rows selected.

备库

SQL> select * from dept;

    DEPTNO DNAME          LOC
---------- -------------- -------------
        10 ACCOUNTING     NEW YORK
        20 RESEARCH       DALLAS
        30 SALES          CHICAGO
        40 OPERATIONS     BOSTON
        60 usa            shanghai
        50 DBA            peijing

6 rows selected

-----------------------------------------------

数据同步

参考文章

http://blog.youkuaiyun.com/tianlesoftware/article/details/6978501