OGG單向復制(支持DDL)

1. 配置環(huán)境變量(源端、目標端)>grant execute on utl_file to goldengate;

成都創(chuàng)新互聯(lián)公司專注為客戶提供全方位的互聯(lián)網綜合服務，包含不限于網站設計、做網站、察雅網絡推廣、重慶小程序開發(fā)公司、察雅網絡營銷、察雅企業(yè)策劃、察雅品牌公關、搜索引擎seo、人物專訪、企業(yè)宣傳片、企業(yè)代運營等，從售前售中售后，我們都將竭誠為您服務，您的肯定，是我們最大的嘉獎；成都創(chuàng)新互聯(lián)公司為所有大學生創(chuàng)業(yè)者提供察雅建站搭建服務，24小時服務熱線：18980820575，官方網址：www.cdcxhl.com

SQL>@marker_setup.sql

SQL>@ddl_setup.sql

SQL>@role_setup.sql

SQL>GRANT GGS_GGSUSER_ROLE TO goldengate;>@?/rdbms/admin/dbmspool

SQL >@ddl_pin goldengate;

1.@ddl_setup.sql

5.4源端配置抽取進程

DataPump進程

GGSCI (test01) 1> edit param PTEST01

extract PTEST01

setenv (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)

setenv (ORACLE_HOME = /oracle/app/oracle/product/11.2.4/db_1)

setenv (ORACLE_SID = testdb)

userid goldengate, password goldengate

PASSTHRU

REPORT AT 01:59

REPORTROLLOVER at 02:00

RMTHOST 10.18.4.41, MGRPORT 7809, COMPRESS 

RMTTRAIL ./dirdat/rep

DYNAMICRESOLUTION

NUMFILES 2000

gettruncates

------lizhen-------

TABLE DEMO.TEST_TABLE_FOR_OGG;

GGSCI > ADD EXTRACT PTEST01, EXTTRAILSOURCE ./dirdat/exp

GGSCI > ADD RMTTRAIL ./dirdat/rep, EXTRACT PTEST01, MEGABYTES 200

6. 配置目標端

6.1配置全局變量

同源端

6.2創(chuàng)建檢查點表

同源端

6.3 配置mgr

同源端

6.4 配置目標端復制進程

GGSCI (test01) 23> view param RTEST01

replicat RTEST01

setenv (NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)

userid goldengate, password goldengate

REPORTCOUNT EVERY 30 MINUTES,RATE

REPORT AT 01:59

REPORTROLLOVER at 02:00

DISCARDROLLOVER on friday

HANDLECOLLISIONS

REPERROR DEFAULT,ABEND

DISCARDFILE ./DIRRPT/RTEST01.DSC,APPEND, MEGABYTES 1000

ASSUMETARGETDEFS

CHECKSEQUENCEVALUE

ALLOWNOOPUPDATES

DYNAMICRESOLUTION

NUMFILES 2000

DDL INCLUDE MAPPED

DDLOPTIONS REPORT

GROUPTRANSOPS 500

MAXTRANSOPS 500

------lizhen--------

MAP DEMO.TEST_TABLE_FOR_OGG,TARGET TEST.TEST_TABLE_FOR_OGG;

ggsci >add replicat RTEST01 ,exttrail ./dirdat/rep

7. 啟動源端和目標端的ogg進程

---源端

GGSCI (test01) 50> start ETEST01

GGSCI (test01) 51> start PTEST01

GGSCI (test01) 53> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          

EXTRACT     RUNNING     ETEST01        00:00:00      00:00:01   

EXTRACT     RUNNING     PTEST01        00:00:00      00:00:03   

---目標端

GGSCI (test02) 24> start RTEST01

GGSCI (test02) 24> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          

REPLICAT    RUNNING     RTEST01        00:00:00      00:00:05