KunlunBase指导手册（四）之从Oracle实时同步数据

一、环境及软件需求

Oracle GoldenGate从11.2.1.0.2开始支持在Oracle数据库和KunlunBase之间做数据复制。

本文档提供数据复制过程的基本配置方案，涉及不同操作系统及数据库版本具体配置，请参考官方文档。

软件需求：

• Oracle GoldenGate for Oracle

• Oracle GoldenGate for Postgresql

• 软件下载页面：https://www.oracle.com/middleware/technologies/goldengate.html

数据同步架构图

二、安装

2.1 安装&配置Oracle GoldenGate for Oracle

Oracle数据库服务器端环境变量。

ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
ORACLE_SID=kunluntest
LD_LIBRARY_PATH=$ORACLE_HOME/lib

Oracle数据库运行在归档模式并且开启附加日志。

alter system set log_archive_dest='LOCATION=USE_DB_RECOVERY_FILE_DEST'scope=both sid='*';
shutdown immediate
startup mount
alter database archivelog;
alter database open;
alterdatabaseaddsupplementallogdata;

安装Oracle GoldenGate for Oracle并设置GoldenGate软件目录到环境变量。

exportPATH=$PATH:/var/kunlun/ggs
exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/var/kunlun/ggs/lib/LD_LIBRARY_PATH

为Goldengate 配置基本目录。

GGSCI (SOURCE.KUNLUN.COM)1> create subdirs
Creatingsubdirectories under current directory /var/kunlun/ggs
Parameterfiles        /var/kunlun/ggs/dirprm:alreadyexists
Reportfiles          /var/kunlun/ggs/dirrpt:created
Checkpointfiles        /var/kunlun/ggs/dirchk:created
processstatusfiles      /var/kunlun/ggs/dirpcs:created
SQLscriptfiles        /var/kunlun/ggs/dirsql:created
Databasedefinitionsfiles   /var/kunlun/ggs/dirdef:created
Extractdatafiles      /var/kunlun/ggs/dirdat:created
Temporaryfiles        /var/kunlun/ggs/dirtmp:created
Stdoutfiles          /var/kunlun/ggs/dirout:created

创建OGG manager 参数文件。

GGSCI(SOURCE.KUNLUN.COM)2>editparammgr
addPORT7809 to  theparameterfile:

启动 OGG manager。

GGSCI(SOURCE.KUNLUN.COM)3>startmgr
GGSCI(SOURCE.KUNLUN.COM)4>infoall
Program   Status   Group    LagatChkptTimeSinceChkpt
addPORT7809 to  theparameterfile:
MANAGER   RUNNING

2.2 安装&配置Oracle GoldenGate for KunlunBase

在PostgreSQL服务器端解压GoldenGate软件包并发lib路径配置到环境变量中。

mkdir ggs
cd ggs
unzip V34006-01.zip
tar xvf *.tar
[kunlun@centos7b ggs]$ export LD_LIBRARY_PATH=/var/kunlun/ggs/lib

GoldenGate通过ODBC连接 KunlunBase ,因此，需要配置ODBC 数据源。

[ODBC Data Sources]
Kunlundb1=DataDirect 11.5 KUNLUNDB Wire Protocol
[ODBC]
IANAAppCodePage=106
InstallDir=/var/kunlun/ggs
[kunlundb1]
Driver=/var/kunlun/ggs/lib/GGpsql25.so
Description=DataDirect 11.5 KUNLUNDB Wire Protocol
Database=kunlundb
HostName=192.168.0.130
PortNumber=5401
LogonID=abc
Password=abc

将配置文件export到环境变量。

[kunlun@centos7b  ggs]$ export ODBCINI=/var/kunlun/ggs/odbc.ini

配置目标端Goldengate。

[kunlun@TARGET ggs]$ ./ggsci
GGSCI (TARGET