OGG单向复制(支持DDL) 版本说明:
./ggsci -v

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14


1. 配置环境变量(源端、目标端)> grantexecuteonutl_filetogoldengate;

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源端配置抽取进程

Data Pump进程

GGSCI(test01) 1> edit param PTEST01

extractPTEST01

setenv(NLS_LANG = AMERICAN_AMERICA.ZHS16GBK)

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

setenv(ORACLE_SID = testdb)

useridgoldengate, password goldengate

PASSTHRU

REPORTAT 01:59

REPORTROLLOVERat 02:00

RMTHOST10.18.4.41, MGRPORT 7809, COMPRESS

RMTTRAIL./dirdat/rep

DYNAMICRESOLUTION

NUMFILES2000

gettruncates

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

TABLEDEMO.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创建检查点表

同源端

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,TARGETTEST.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 StatusGroup Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNINGETEST01 00:00:00 00:00:01

EXTRACT RUNNINGPTEST01 00:00:00 00:00:03

---目标端

GGSCI(test02) 24> start RTEST01

GGSCI(test02) 24> info all

Program StatusGroup Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNINGRTEST01 00:00:00 00:00:05