Shulou(Shulou.com)06/01 Report--

OGG One-Way Replication (DDL supported) Version Notes:

./ 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. Configure environment variables (source, destination)> 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 source-side configuration extraction process

Data Pump Process

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. Configuring the target 6.1 Configuring global variables Homogeneous

6.2 Create Checkpoint Table Source End

6.3 Configure mgr homologous end

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. Start the ogg process on the source and destination sides---source side

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

---Target end

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.