OGG源端和目标端配置

骑猪看日落 2022-09-11 00:24 216阅读 0赞

### 目录 ###

*   *  源端
     *   *  Manager进程
         *  Extract进程
         *  Pump进程
         *  开启进程
         *  查看进程
     *  目标端
     *   *  Manager进程
         *  Checkpoint表
         *  Relicate进程
         *  开启进程
         *  查看进程

## 源端 ##

### Manager进程 ###

GGSCI (cdb) 3> view params mgr
    
    port 7809
    dynamicportlist 7800-8000
    autorestart extract *,retries 5,waitminutes 2,resetminutes 5

### Extract进程 ###

GGSCI (cdb) 4> view params ext01
    
    EXTRACT ext01
    SETENV (ORACLE_HOME = "/opt/oracle/products")
    SETENV (ORACLE_SID = "cdb")
    USERID c##goldengate, PASSWORD goldengate
    LOGALLSUPCOLS
    NOCOMPRESSUPDATES
    DDL INCLUDE MAPPED SOURCECATALOG source
    GETTRUNCATES
    EXTTRAIL /opt/oracle/ogg/dirdat/ex
    SOURCECATALOG source
    TABLE send.*;

GGSCI (cdb) 5> ADD EXTRACT ext01,INTEGRATED TRANLOG,BEGIN NOW
    GGSCI (cdb) 5> ADD RMTTRAIL /opt/oracle/ogg/dirdat/ex, EXTRACT EXT01

### Pump进程 ###

GGSCI (cdb) 5> view params pmp01
    
    extract pmp01
    dynamicresolution
    USERID c##goldengate, PASSWORD goldengate
    PASSTHRU
    rmthost cdbtest, mgrport 7809
    rmttrail /opt/oracle/ogg/dirdat/pt
    SOURCECATALOG source
    TABLE send.*;

GGSCI (cdb) 8> add extract pmp01, exttrailsource /opt/oracle/ogg/dirdat/ex
    GGSCI (cdb) 8> add RMTTRAIL /opt/oracle/ogg/dirdat/pt, EXTRACT PMP01

### 开启进程 ###

GGSCI (cdb) 8> start mgr
    GGSCI (cdb) 8> start exp01
    GGSCI (cdb) 8> start pmp01

### 查看进程 ###

GGSCI (cdb) 8> info all
    GGSCI (cdb) 8> send pmp01,status

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_15_color_FFFFFF_t_70_g_se_x_16]

## 目标端 ##

### Manager进程 ###

GGSCI (cdbtest) 2> view params mgr
    
    port 7809
    dynamicportlist 7800-8000
    autorestart extract *, retries 5, waitminutes 2, resetminutes 5
    ACCESSRULE,PROG *,IPADDR cdb,ALLOW

### Checkpoint表 ###

GGSCI (cdbtest) 16> dblogin userid c##goldengate@target, password goldengate
    GGSCI (cdbtest as c##goldengate@cdbtest/TARGET) 2> add checkpointtable c##goldengate.checkpoint

### Relicate进程 ###

GGSCI (cdbtest) 3> view params rep01
    
    replicat rep01
    assumetargetdefs
    SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
    userid c##goldengate@target, password goldengate
    discardfile /opt/oracle/ogg/dirrpt/rep01.dsc, append, megabytes 20
    dynamicresolution
    ddloptions report 
    ddlerror default ignore retryop maxretries 3 retrydelay 5
    reperror default, discard
    map source.send.*, target target.send.*;

GGSCI (cdbtest as c##goldengate@cdbtest/TARGET) 2> add replicat rep01, exttrail/opt/oracle/ogg/dirdat/pt, checkpointtable gg_user.checkpoint

### 开启进程 ###

GGSCI (cdbtest as c##goldengate@cdbtest/TARGET) 2> start mgr
    GGSCI (cdbtest as c##goldengate@cdbtest/TARGET) 2> start rep01

### 查看进程 ###

GGSCI (cdbtest as c##goldengate@cdbtest/TARGET) 2> info all

![在这里插入图片描述][d28524069fdc43228d40153fd2d5df00.png]

![在这里插入图片描述][b9f7123e6b13424ea85fad106d736b89.png]

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_15_color_FFFFFF_t_70_g_se_x_16]: /images/20220829/dd55df66074b47d082a4f1f80083930b.png
[d28524069fdc43228d40153fd2d5df00.png]: /images/20220829/3def67294ca04099ba0863bec6d7d0f0.png
[b9f7123e6b13424ea85fad106d736b89.png]: /images/20220829/d4abf33a4ea24c30ab0b27eb4416a388.png