goldengate通用配置

最新推荐文章于 2024-02-26 17:40:20 发布

aaron8219

最新推荐文章于 2024-02-26 17:40:20 发布

阅读量1.2k

点赞数

分类专栏： Oracle GoldenGate 文章标签： OGG GG GOLDENGATE 参数配置

Oracle GoldenGate 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

原文链接：http://www.xifenfei.com/648.html

一、理论
source

 
        ADD EXTRACT <ext>, TRANLOG, BEGIN < 
        time 
        >, [, THREADS] 
       
        ADD EXTTRAIL <local_trail>, EXTRACT <ext> 
       
        EDIT PARAMS <ext> 
       
        -- Identify the Extract group: 
       
        EXTRACT <ext> 
       
        -- Specify database login information as needed  
        for 
        the database: 
       
        [SOURCEDB <dsn_1>,][USERID <user>[, PASSWORD <pw>]] 
       
        -- Specify the  
        local 
        trail that this Extract writes to: 
       
        EXTTRAIL <local_trail> 
       
        -- Specify tables to be captured: 
       
        TABLE <owner>.<table>; 
       
        ADD EXTRACT <pump_1>, EXTTRAILSOURCE <local_trail>, BEGIN < 
        time 
        > 
       
        ADD RMTTRAIL <remote_trail_1>, EXTRACT <pump_1> 
       
        EDIT PARAMS <pump_1> 
       
        -- Identify the data pump group: 
       
        EXTRACT <pump_1> 
       
        -- Specify database login information as needed  
        for 
        the database: 
       
        [SOURCEDB <dsn_1>,][USERID <user>[, PASSWORD <pw>]] 
       
        -- Specify the name or IP address of the first target system: 
       
        RMTHOST <target_1>, MGRPORT <portnumber> 
       
        -- Specify the remote trail on the first target system: 
       
        RMTTRAIL <remote_trail_1> 
       
        -- Allow mapping, filtering, conversion or pass data through as-is: 
       
        [PASSTHRU | NOPASSTHRU] 
       
        -- Specify tables to be captured: 
       
        TABLE <owner>.<table>;

target

 
        edit params . 
        /GLOBALS 
       
        CHECKPOINTTABLE <owner>.<tablename> 
       
        ADD REPLICAT <rep_1>, EXTTRAIL <remote_trail_1>, BEGIN < 
        time 
        > checkpointtable <owner>.<tablename> 
       
        edit params <rep_1> 
       
        -- Identify the Replicat group: 
       
        REPLICAT <rep_1> 
       
        -- State whether or not  
        source 
        and target definitions are identical: 
       
        SOURCEDEFS <full_pathname> | ASSUMETARGETDEFS 
       
        -- Specify database login information as needed  
        for 
        the database: 
       
        [TARGETDB <dsn_3>,] [USERID <user  
        id 
        >[, PASSWORD <pw>]] 
       
        -- Specify error handling rules: 
       
        REPERROR (<error>, <response>) 
       
        -- Specify tables  
        for 
        delivery: 
       
        MAP <owner>.<table>, TARGET <owner>.<table>[, DEF <template name>];

二、配置实例
source

 
        add extract extl,tranlog,begin now 
       
        ADD EXTTRAIL  
        /u01/ogg/dirdat/rl 
        , EXTRACT EXTL 
       
        ADD TRANDATA chf.objce_t 
       
        edit params extl 
       
        extract extl 
       
        SETENV (NLS_LANG =  
        "AMERICAN_AMERICA.ZHS16GBK" 
        ) 
       
        userid ogg,password xifenfei 
       
        exttrail 
        /u01/ogg/dirdat/rl 
       
        dynamicresolution 
       
        gettruncates 
       
        table chf.objce_t; 
       
        ADD EXTRACT pump1, EXTTRAILSOURCE  
        /u01/ogg/dirdat/rl 
        , BEGIN now 
       
        add rmttrail  
        /u01/ogg/dirdat/rl 
        extract pump1 
       
        edit params pump1 
       
        extract pump1 
       
        SETENV (NLS_LANG =  
        "AMERICAN_AMERICA.ZHS16GBK" 
        ) 
       
        userid ogg, password xifenfei 
       
        rmthost 192.168.1.111, mgrport 7809 
       
        rmttrail 
        /u01/ogg/dirdat/rl 
       
        PASSTHRU 
       
        gettruncates 
       
        table chf.objce_t;

target

 
        edit params . 
        /GLOBALS 
       
        CHECKPOINTTABLE ogg.chkpoint 
       
        ADD CHECKPOINTTABLE ogg.chkpoint 
       
        add replicat repl exttrail  
        /u01/ogg/dirdat/rl 
        ,begin now,checkpointtable ogg.chkpoint  
       
        edit repl 
       
        replicat repl     
       
        SETENV (NLS_LANG =  
        "AMERICAN_AMERICA.ZHS16GBK" 
        )                           
       
        userid ogg,password xifenfei                     
       
        assumetargetdefs                          
       
        reperror default,discard                       
       
        discardfile 
        /tmp/repsz 
        .dsc,append,megabytes 100    
       
        gettruncates                                                      
       
        map chf.objce_t, target chf.objce_t;

aaron8219

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
goldengate通用配置

原文链接：http://www.xifenfei.com/648.html一、理论sourceADD EXTRACT , TRANLOG, BEGIN time>, [, THREADS]ADD EXTTRAIL , EXTRACT EDIT PARAMS -- Identify the Extr
复制链接

扫一扫

专栏目录