ogg-配置添加新表

源端：192.168.214.145

目标端：192.168.214.139

源端

GGSCI (bogon) 1> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     RUNNING     EXT1        00:00:00      00:00:03    
EXTRACT     RUNNING     PUMP1       00:00:00      00:00:01    


GGSCI (bogon) 2> view params mgr

port 7809


GGSCI (bogon) 3> view params ext1

EXTRACT ext1
SETENV (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
--SETENV (ORACLE_SID = "orcl")
SETENV (ORACLE_HOME = /data/oracle/product/11.2.0/db_1)
USERID ogg, PASSWORD ogg
THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 20000
EXTTRAIL ./dirdat/et
DYNAMICRESOLUTION
--DDL INCLUDE ALL
TABLE songhongjun.t;
TABLE songhongjun.k;


GGSCI (bogon) 4> view params pump1

EXTRACT pump1
RMTHOST 192.168.214.139, MGRPORT 7809
RMTTRAIL ./dirdat/et
PASSTHRU
DYNAMICRESOLUTION
TABLE songhongjun.t;
TABLE songhongjun.k;

打开表级附加日志

dblogin userid ogg password ogg

add trandata songhongjun.t

add trandata songhongjun.k

目标端：

GGSCI (bogon) 2> info all

Program     Status      Group       Lag           Time Since Chkpt

MANAGER     RUNNING                                           
REPLICAT    RUNNING     REP1        00:00:00      00:00:05    


GGSCI (bogon) 3> view params mgr

port 7809


GGSCI (bogon) 4> view params rep1

REPLICAT rep1
setenv (ORACLE_SID=orcl)
SETENV (ORACLE_HOME = "/data/oracle/product/11.2.0/db_1")
USERID ogg,PASSWORD ogg
ASSUMETARGETDEFS
HANDLECOLLISIONS
REPERROR (DEFAULT, DISCARD)
DDLERROR DEFAULT DISCARD
DDLOPTIONS REPORT
DISCARDFILE ./dirrpt/repr1.dsc,append,megabytes 100
MAP songhongjun.t, TARGET songhongjun.t;
MAP songhongjun.k, TARGET songhongjun.k;


GGSCI (bogon) 5>

ogg-配置添加新表

原文：https://www.cnblogs.com/redarmy/p/14280962.html