适用范围

• 源端数据库：Oracle Version 19.3.0.0.0
• 目标端数据库：

gsql ((GaussDB Kernel V500R002C10 build c3db7c07) compiled at 2022-09-24 21:19:15 commit 3864 last mr 8636 release)
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
openGauss=# select version();
                                                           version                                                            
------------------------------------------------------------------------------------------------------------------------------
 openGauss 2.1.0 (GaussDB Kernel V500R002C10 build c3db7c07) compiled at 2022-09-24 21:19:15 commit 3864 last mr 8636 release
(1 row)
复制

• OGG版本：Version 19.1.0.0.4 OGGCORE_19.1.0.0.0_PLATFORMS_191017.1054_FBO
• 测试主机：虚拟机（16cpu,16g内存,CentOS Linux release 7.9.2009 (Core)）

OGG源端配置

EXT_01

EXTRACT EXT_01
SETENV (ORACLE_SID = test)
SETENV (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
USERID tpcc_oracle, PASSWORD tpcc_oracle
DISCARDFILE ./dirrpt/EXT_01.dsc, APPEND, MEGABYTES 100
EOFDELAYCSECS 50
FLUSHCSECS 10
GETTRUNCATES
GETUPDATEBEFORES
GETUPDATEAFTERS
CACHEMGR CACHESIZE 4G
TRANLOGOPTIONS INTEGRATEDPARAMS (MAX_SGA_SIZE 1024, _LOGMINER_READ_BUFFERS 256,parallelism 2)
TRANLOGOPTIONS _LCRPINGFREQUENCY 5
--TRANLOGOPTIONS _NOREADAHEAD ANY
--TRANLOGOPTIONS LOGRETENTION DISABLED
CHECKPOINTSECS 3
WARNLONGTRANS 4H, CHECKINTERVAL 30M
EXTTRAIL ./dirdat/ea
table tpcc_oracle.*;
复制

pmp_01

EXTRACT pmp_01
PASSTHRU
RMTHOST 172.12.0.36, MGRPORT 7809,TCPBUFSIZE 30000,TCPFLUSHBYTES 150000
RMTTRAIL ./dirdat/pb 
table tpcc_oracle.*;
复制

目标端配置

rep_01

REPLICAT rep_01
TARGETDB LIBFILE libggjava.so SET property=dirprm/jdbc_opengauss.props
REPORTCOUNT EVERY 1 MINUTES, RATE
GROUPTRANSOPS 10000
map tpcc_oracle.*, target tpcc_oracle.*;
复制

jdbc_opengauss.props

gg.handlerlist=jdbcwriter
gg.handler.jdbcwriter.type=jdbc

gg.handler.jdbcwriter.DriverClass=org.opengauss.Driver
gg.handler.jdbcwriter.connectionURL=jdbc:opengauss://172.12.0.36:33700/tpccdb
gg.handler.jdbcwriter.userName=tpcc_gaussdb
gg.handler.jdbcwriter.password=Tpcc_gaussdb@123
gg.classpath=/tools/ogg/dirprm/opengauss-jdbc-3.1.0.jar

goldengate.userexit.writers=javawriter
javawriter.stats.display=TRUE
javawriter.stats.full=TRUE
gg.log=log4j
gg.log.level=INFO
gg.report.time=30sec
javawriter.bootoptions=-Xmx512m -Xms32m -Djava.class.path=.:ggjava/ggjava.jar:./dirprm

复制

测试过程

源端数据库删除10条数据

delete from tpcc_oracle.bmsql_new_order where rownum<=10;

复制

目标端数据库检查：

发现已经删除了10条记录

ogg检查

小结

通过测试发现，使用ogg能够从Oracle同步数据到GaussDB, 安装配置过程也较为简单。