OGG 的初始化加载

待我称王封你为后i 2022-09-11 00:26 204阅读 0赞

### 目录 ###

*   *  源端
     *   *  Extract进程
         *  开启和查看进程
     *  目标端
     *   *  Relicate进程
         *  开启和查看进程

## 源端 ##

### Extract进程 ###

GGSCI (cdb) 7> view params ext02
    
    extract ext02
    SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
    userid c##goldengate, password goldengate
    rmthost cdbtest, mgrport 7809
    rmttask replicat, group rep02
    SOURCECATALOG source
    table send.t1;

### 开启和查看进程 ###

GGSCI (cdb) 8> add extract ext02, sourceistable
    GGSCI (cdb) 8> info extract ext02
    GGSCI (cdb) 8> info all
    
    GGSCI (cdb) 8> start extract ext02
    GGSCI (cdb) 8> info extract ext02
    GGSCI (cdb) 8> view report ext02
    GGSCI (cdb) 8> info all

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

## 目标端 ##

### Relicate进程 ###

GGSCI (cdbtest) 4> view params rep02
    
    replicat rep02
    ASSUMETARGETDEFS        
    SETENV (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
    userid c##goldengate@target, password goldengate
    --reperror default, discard
    discardfile /opt/oracle/ogg/dirrpt/rep02.dsc, append, megabytes 20
    BATCHSQL
    INSERTAPPEND         
    map source.send.t1, target target.send.t1;

### 开启和查看进程 ###

GGSCI (cdbtest) 8> add replicat rep02, specialrun
    GGSCI (cdbtest) 8> info replicat rep02
    GGSCI (cdbtest) 8> info all
    
    GGSCI (cdbtest) 8> info replicat rep02
    GGSCI (cdbtest) 8> view report rep02
    GGSCI (cdbtest) 8> info all

**源端开启ext02，目标端自动打开rep02**  
![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_20_color_FFFFFF_t_70_g_se_x_16]  
![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_20_color_FFFFFF_t_70_g_se_x_16 1]

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_16_color_FFFFFF_t_70_g_se_x_16]: /images/20220829/f4b9b7e11f854b6d8197a72354525cfd.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_20_color_FFFFFF_t_70_g_se_x_16]: /images/20220829/2d751a3dcf124d6a82305b2a64551f52.png
[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_20_color_FFFFFF_t_70_g_se_x_16 1]: /images/20220829/6f12a6753bb54a35b3292d02eb505b5a.png