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. 配置环境变量(源端、目标端)> grant
execute on utl_file to goldengate;
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
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创建检查点表
同源端
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
