GoldenGate配置（一）之单向复制配置

最新推荐文章于 2019-08-13 09:51:36 发布

原创

最新推荐文章于 2019-08-13 09:51:36 发布 · 4.9k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle #GoldenGate

本文详细介绍了Oracle GoldenGate的单向复制配置步骤，包括环境变量设置、子目录创建、用户授权、补充日志开启、MGR及Extract、Replicat进程配置，并通过DML操作验证数据同步。

GoldenGate配置（一）之单向复制配置

环境：

Item	Source System	Target System
Platform	Red Hat Enterprise Linux Server release 5.4	Red Hat Enterprise Linux Server release 5.4
Hostname	gc1	gc2
Database	Oracle 10.2.0.1	Oracle 11.2.0.1
Character Set	ZHS16GBK	ZHS16GBK
ORACLE_SID	PROD	EMREP
Listener Name/Port	LISTENER/1521	LISTENER/1521
Goldengate User	ogg	ogg

单向复制配置

--环境变量里添加如下内容

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib

gc1：解压GoldenGate安装包

[oracle@gc1 ~]$ mkdir -p/u01/app/ogg

[oracle@gc1 ~]$ cd /u01/app/ogg

[oracle@gc1 ogg]$ ls

V18156-01-linux.zip

[oracle@gc1 ogg]$ unzip V18156-01-linux.zip

[oracle@gc1 ogg]$ tar -xvf ggs_redhatAS40_x86_ora10g_32bit_v10.4.0.19_002.tar

gc2：解压GoldenGate安装包

[oracle@gc2 ~]$ mkdir -p/u01/app/ogg

[oracle@gc2 ~]$ cd /u01/app/ogg

[oracle@gc2 ogg]$ ls

V18156-01-linux.zip

[oracle@gc2 ogg]$ unzip V18156-01-linux.zip

[oracle@gc2 ogg]$ tar -xvf ggs_redhatAS40_x86_ora10g_32bit_v10.4.0.19_002.tar

gc1：配置环境变量、建立相关子目录

[oracle@gc1 ~]$ vi .bash_profile

添加exportLD_LIBRARY_PATH=$ORACLE_HOME/lib

[oracle@gc1~]$ source .bash_profile

[oracle@gc1ogg]$ ./ggsci

OracleGoldenGate Command Interpreter for Oracle

Version10.4.0.19 Build 002

Linux, x86,32bit (optimized), Oracle 10 on Sep 17 2009 23:49:42

GGSCI (gc1)1>create subdirs

Creatingsubdirectories under current directory /u01/app/ogg

Parameterfiles /u01/app/ogg/dirprm: created

Reportfiles /u01/app/ogg/dirrpt: created

Checkpointfiles /u01/app/ogg/dirchk:created

Process statusfiles /u01/app/ogg/dirpcs:created

SQL scriptfiles /u01/app/ogg/dirsql:created

Databasedefinitions files /u01/app/ogg/dirdef: created

Extract datafiles /u01/app/ogg/dirdat:created

Temporaryfiles /u01/app/ogg/dirtmp:created

Veridatafiles /u01/app/ogg/dirver: created

Veridata Lockfiles /u01/app/ogg/dirver/lock: created

VeridataOut-Of-Sync files /u01/app/ogg/dirver/oos: created

VeridataOut-Of-Sync XML files /u01/app/ogg/dirver/oosxml: created

VeridataParameter files /u01/app/ogg/dirver/params: created

Veridata Reportfiles /u01/app/ogg/dirver/report: created

Veridata Statusfiles /u01/app/ogg/dirver/status: created

Veridata Tracefiles /u01/app/ogg/dirver/trace: created

Stdoutfiles /u01/app/ogg/dirout:created

gc2：配置环境变量、建立相关子目录

[oracle@gc2 ~]$ vi .bash_profile

添加exportLD_LIBRARY_PATH=$ORACLE_HOME/lib

[oracle@gc2~]$ source .bash_profile

[oracle@gc2db_1]$ cd $ORACLE_HOME/lib

[oracle@gc2lib]$ ln -s libnnz11.so libnnz10.so

[oracle@gc2ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 10.4.0.19 Build 002

Linux, x86, 32bit (optimized), Oracle 10 on Sep17 2009 23:49:42

GGSCI (gc2) 1> create subdirs

Creating subdirectories under current directory/u01/app/ogg

Parameter files /u01/app/ogg/dirprm: created

Report files /u01/app/ogg/dirrpt: created

Checkpoint files /u01/app/ogg/dirchk: created

Process status files /u01/app/ogg/dirpcs: created

SQL script files /u01/app/ogg/dirsql: created

Database definitions files /u01/app/ogg/dirdef: created

Extract data files /u01/app/ogg/dirdat: created

Temporary files /u01/app/ogg/dirtmp: created

Veridata files /u01/app/ogg/dirver: created

Veridata Lock files&n

最低0.47元/天解锁文章