本文介绍的是从将数据从Oracle同步到SQLServer

假设源数据库oracle已经有了一个用于GG环境的ggs用户

Oracle GoldenGate的安装已经在以前的blog中有过介绍，这里不再介绍针对于Oracle数据库GoldenGate的安装

ggs用户已经有了足够的权限运行GoldenGate

先创建两张表用于测试

create table emp as select * from scott.emp where 1 = 0;

create table dept as select * from scott.dept where 1 = 0;

在ggsci下创建一个用于创建数据定义文件的参数文件defgen, 内容如下：

edit param defgen

DEFSFILE dirdef/source.def, PURGE

USERID GGS, PASSWORD xxxx

TABLE GGS.EMP;

TABLE GGS.DEPT;

生成的参数文件位于dirprm下

退出ggsci,运行源定义生成器

defgen paramfile dirprm/defgen.prm

/*******************

d:\ggs>defgen paramfile dirprm/defgen.prm

***********************************************************************

Oracle GoldenGate Table Definition Generator for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230

Windows (optimized), Oracle 11g on Apr 23 2012 05:45:18

Starting at 2013-07-11 14:36:22

***********************************************************************

Operating System Version:

Microsoft Windows 7 , on x86

Version 6.1 (Build 7600: )

Process id: 1516

***********************************************************************

** Running with the following parameters **

***********************************************************************

DEFSFILE dirdef/source.def,PURGE

userid ggs, password ***

table ggs.emp;

Retrieving definition for GGS.EMP

2013-07-11 14:36:22 WARNING OGG-00869 No unique key is defined for table 'EMP'

. All viable columns will be used to represent the key, but may not guarantee un

iqueness. KEYCOLS may be used to define the key.

table ggs.dept;

Retrieving definition for GGS.DEPT

2013-07-11 14:36:22 WARNING OGG-00869 No unique key is defined for table 'DEPT

'. All viable columns will be used to represent the key, but may not guarantee u

niqueness. KEYCOLS may be used to define the key.

Definitions generated for 2 tables in dirdef/source.def

d:\ggs>

*******************/

这样就生成了我们需要同步的表的定义描述文件

Oracle数据库的GoldenGate完成后，需要配置SQLServer,即目标端的GoldenGate

SQLServer端的GoldenGate版本信息

Oracle GoldenGate Command Interpreter for SQL Server

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230

Windows x64 (optimized), Microsoft SQL Server on Apr 23 2012 06:56:36

GGSCI (chenyj-WorkPC) 1> create subdirs

Creating subdirectories under current directory D:\ggs

Parameter files D:\ggs\dirprm: already exists

Report files D:\ggs\dirrpt: created

Checkpoint files D:\ggs\dirchk: created

Process status files D:\ggs\dirpcs: created

SQL script. files D:\ggs\dirsql: created

Database definitions files D:\ggs\dirdef: created

Extract data files D:\ggs\dirdat: created

Temporary files D:\ggs\dirtmp: created

Stdout files D:\ggs\dirout: created

GGSMGR已经被安装为windows服务，安装过程与oracle版本相同

在GGSCI中启动mgr时碰到了错误：

GGSCI (chenyj-WorkPC) 4> start mgr

Process creation error: WIN32 API CALL CreateProcess failed 740 (请求的操作需要

提升。)

因而我直接从服务列表中启动它

GGSCI (chenyj-WorkPC) 5> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

截至到目前我们已经安装好了源端(Oracle)与目标端(SQL Server)的GoldenGate

ITPub博客

GoldenGate异种数据库之间的复制

最新文章