使用最新版OGG配置ORACLE TO SQL SERVER同步

源库配置

数据库设置为归档模式

ALTER DATASBASE ARCHIVELOG;

开启强制日志

ALTER DATABASE FORCE LOGGING;

开启附加日志

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

修改参数

ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION=TRUE;

创建用户

--创建用户表空间

create tablespace ogg datafile '/u01/app/oracle/oradata/ogg.dbf' size 2G autoextend off;

--创建用户

create user goldengate identified by goldengate;

--添加权限

grant dba to goldengate;

静默安装：

goldengate自12c版本开始也开始采用oui方式进行安装，但是有很多情况下操作系统没有图形化，这种情况下可以采用静默方式安装，具体步骤如下：

1.上传ogg 12.1.2.1.0介质

2.解压介质

unzip V46695-01.zip

3.配置自动应答文件

静默安装需要配置一个自动应答文件，位置在刚才解压出来的介质目录中，具体如下：

[oracle@rac1 software]$ cd fbo_ggs_Linux_x64_shiphome/Disk1/response/

[oracle@rac1 response]$ ls

oggcore.rsp

这个oggcore.rsp就是静默安装的配置模板，照着这个模板修改即可。

[oracle@rac1 response]$ cat oggcore.rsp

oracle.install.responseFileVersion=/oracle/install/rspfmt_ogginstall_response_schema_v12_1_2

不要修改这个值

################################################################################

##                                                                            ##

## Oracle GoldenGate installation option and details                          ##

##                                                                            ##

################################################################################

#-------------------------------------------------------------------------------

# Specify the installation option.

# Specify ORA12c for installing Oracle GoldenGate for Oracle Database 12c and

#         ORA11g for installing Oracle GoldenGate for Oracle Database 11g

#-------------------------------------------------------------------------------

INSTALL_OPTION=ORA11g

根据系统是12c还是11g选择ORA12c或者ORA11g

#-------------------------------------------------------------------------------

# Specify a location to install Oracle GoldenGate

#-------------------------------------------------------------------------------

SOFTWARE_LOCATION=/goldengate

写上goldengate的安装目录

#-------------------------------------------------------------------------------

# Specify true to start the manager after installation.

#-------------------------------------------------------------------------------

START_MANAGER=false

是否在配置完成后自动启动mgr进程，是就选true，否就选false

#-------------------------------------------------------------------------------

# Specify a free port within the valid range for the manager process.

# Required only if START_MANAGER is true.

#-------------------------------------------------------------------------------

MANAGER_PORT=

在start_manager为true时添加，选择mgr启动端口号

#-------------------------------------------------------------------------------

# Specify the location of the Oracle Database.

# Required only if START_MANAGER is true.

#-------------------------------------------------------------------------------

DATABASE_LOCATION=

在start_manager为true时添加，写上$ORACLE_HOME的值

################################################################################

##                                                                            ##

## Specify details to Create inventory for Oracle installs                    ##

## Required only for the first Oracle product install on a system.            ##

##                                                                            ##

################################################################################

如果在安装goldengate前没有安装过其他Oracle产品再填写以下两个参数

#-------------------------------------------------------------------------------

# Specify the location which holds the install inventory files.

# This is an optional parameter if installing on

# Windows based Operating System.

#-------------------------------------------------------------------------------

INVENTORY_LOCATION=

指定inventory目录的位置，在使用windows操作系统时是一个可选参数。

#-------------------------------------------------------------------------------

# Unix group to be set for the inventory directory.  

# This parameter is not applicable if installing on

# Windows based Operating System.

#-------------------------------------------------------------------------------

UNIX_GROUP_NAME=

指定一个组，windows系统时不需要写

4.启动静默安装

./runInstaller -silent -responseFile /ogg/fbo_ggs_Linux_x64_shiphome/Disk1/response/oggcore.rsp

之后开始安装

这时候会提示一个安装日志，

You can find the log of this install session at:

/oracle/app/oraInventory/logs/installActions2016-07-08_11-26-16AM.log

可以使用 tail -100f   /oracle/app/oraInventory/logs/installActions2016-07-08_11-26-16AM.log来查看安装情况

安装完成后，安装命令执行页面会输出以下内容：

The installation of Oracle GoldenGate Core was successful.

Please check '/oracle/app/oraInventory/logs/silentInstall2016-07-08_11-26-16AM.log' for more details.

Successfully Setup Software.

5.进入到goldengate目录创建子目录

GGSCI (rac1) 2> create subdirs

Creating subdirectories under current directory /goldengate

Parameter files                /goldengate/dirprm: already exists

Report files                   /goldengate/dirrpt: created

Checkpoint files               /goldengate/dirchk: created

Process status files           /goldengate/dirpcs: created

SQL script files               /goldengate/dirsql: created

Database definitions files     /goldengate/dirdef: created

Extract data files             /goldengate/dirdat: created

Temporary files                /goldengate/dirtmp: created

Credential store files         /goldengate/dircrd: created

Masterkey wallet files         /goldengate/dirwlt: created

Dump files                     /goldengate/dirdmp: created

至此goldengate12c静默安装完成

配置MGR进程

GGSCI>edit params mgr

port 7809

DYNAMICPORTLIST 7840-7850

PURGEOLDEXTRACTS /ogg/software/dirdat/e_tab/*,usecheckpoints,minkeepdays 7

创建defgen文件

a.编辑defgen参数

GGSCI> edit params defgen

defsfile /ogg/software/dirdef/tab.def

userid goldengate,password goldengate

table EAS2.CT_DSY_REPORTSYN001;

table EAS2.CT_DSY_REPORTSYN002;

table EAS2.CT_DSY_REPORTSYN003;

table EAS2.CT_DSY_REPORTSYN004;

table EAS2.CT_DSY_REPORTSYN005;

table EAS2.CT_DSY_REPORTSYN006;

table EAS2.CT_DSY_REPORTSYN007;

table EAS2.CT_DSY_REPORTSYN008;

table EAS2.CT_DSY_REPORTSYN009;

table EAS2.CT_DSY_REPORTSYN010;

table EAS2.CT_DSY_REPORTSYN011;

table EAS2.CT_DSY_REPORTSYN012;

table EAS2.CT_DSY_REPORTSYN013;

table EAS2.CT_DSY_REPORTSYN014;

table EAS2.CT_DSY_REPORTSYN015;

table EAS2.CT_DSY_REPORTSYN016;

table EAS2.CT_DSY_REPORTSYN017;

table EAS2.CT_DSY_REPORTSYN018;

table EAS2.CT_DSY_REPORTSYN019;

table EAS2.CT_DSY_REPORTSYN020;

table EAS2.CT_DSY_REPORTSYN020S1;

table EAS2.CT_DSY_REPORTSYN021;

table EAS2.CT_DSY_REPORTSYN021S1;

table EAS2.CT_DSY_REPORTSYN022;

table EAS2.CT_DSY_REPORTSYN023;

table EAS2.CT_DSY_REPORTSYN024;

table EAS2.CT_DSY_REPORTSYN025;

table EAS2.CT_DSY_REPORTSYN026;

table EAS2.CT_DSY_REPORTSYN027;

table EAS2.CT_DSY_REPORTSYN028;

table EAS2.CT_DSY_REPORTSYN029;

table EAS2.CT_DSY_REPORTSYN030;

table EAS2.CT_DSY_REPORTSYN031;

table EAS2.CT_DSY_REPORTSYN032;

table EAS2.CT_DSY_REPORTSYN033;

table EAS2.CT_DSY_REPORTSYN034;

table EAS2.CT_DSY_REPORTSYN035;

table EAS2.CT_DSY_REPORTSYN036;

b.生成defgen文件

./defgen paramfile /ogg/software/dirprm/defgen.prm

c.将tab.def复制到目标端dirdef目录下

添加表附加日志

GGSCI>dblogin userid goldengate, password goldengate

add trandata   EAS2.CT_DSY_REPORTSYN001

add trandata   EAS2.CT_DSY_REPORTSYN002

add trandata   EAS2.CT_DSY_REPORTSYN003

add trandata   EAS2.CT_DSY_REPORTSYN004

add trandata   EAS2.CT_DSY_REPORTSYN005

add trandata   EAS2.CT_DSY_REPORTSYN006

add trandata   EAS2.CT_DSY_REPORTSYN007

add trandata   EAS2.CT_DSY_REPORTSYN008

add trandata   EAS2.CT_DSY_REPORTSYN009

add trandata   EAS2.CT_DSY_REPORTSYN010

add trandata   EAS2.CT_DSY_REPORTSYN011

add trandata   EAS2.CT_DSY_REPORTSYN012

add trandata   EAS2.CT_DSY_REPORTSYN013

add trandata   EAS2.CT_DSY_REPORTSYN014

add trandata   EAS2.CT_DSY_REPORTSYN015

add trandata   EAS2.CT_DSY_REPORTSYN016

add trandata   EAS2.CT_DSY_REPORTSYN017

add trandata   EAS2.CT_DSY_REPORTSYN018

add trandata   EAS2.CT_DSY_REPORTSYN019

add trandata   EAS2.CT_DSY_REPORTSYN020

add trandata   EAS2.CT_DSY_REPORTSYN020S1

add trandata   EAS2.CT_DSY_REPORTSYN021

add trandata   EAS2.CT_DSY_REPORTSYN021S1

add trandata   EAS2.CT_DSY_REPORTSYN022

add trandata   EAS2.CT_DSY_REPORTSYN023

add trandata   EAS2.CT_DSY_REPORTSYN024

add trandata   EAS2.CT_DSY_REPORTSYN025

add trandata   EAS2.CT_DSY_REPORTSYN026

add trandata   EAS2.CT_DSY_REPORTSYN027

add trandata   EAS2.CT_DSY_REPORTSYN028

add trandata   EAS2.CT_DSY_REPORTSYN029

add trandata   EAS2.CT_DSY_REPORTSYN030

add trandata   EAS2.CT_DSY_REPORTSYN031

add trandata   EAS2.CT_DSY_REPORTSYN032

add trandata   EAS2.CT_DSY_REPORTSYN033

add trandata   EAS2.CT_DSY_REPORTSYN034

add trandata   EAS2.CT_DSY_REPORTSYN035

add trandata   EAS2.CT_DSY_REPORTSYN036

配置抽取进程

a.创建trail文件目录

mkdir -p /ogg/software/dirdat/e_tab

b.添加抽取进程

GGSCI>add extract e_tab,tranlog,threads 1,begin now

GGSCI>add exttrail /ogg/software/dirdat/e_tab/ex,extract e_tab,megabytes 200

GGSCI>edit param e_tab

extract e_tab

SETENV (ORACLE_HOME = "/data/oracle/product/11.2.0/db_1")

SETENV (ORACLE_SID = "eastest")

SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")

userid goldengate,password goldengate

exttrail /ogg/software/dirdat/e_tab/ex

TRANLOGOPTIONS DBLOGREADER

EOFDELAYCSECS 50

FLUSHCSECS 50

dynamicresolution

--defsfile /ogg/software/dirdef/tab.def

userid goldengate,password goldengate

table EAS2.CT_DSY_REPORTSYN001;

table EAS2.CT_DSY_REPORTSYN002;

table EAS2.CT_DSY_REPORTSYN003;

table EAS2.CT_DSY_REPORTSYN004;

table EAS2.CT_DSY_REPORTSYN005;

table EAS2.CT_DSY_REPORTSYN006;

table EAS2.CT_DSY_REPORTSYN007;

table EAS2.CT_DSY_REPORTSYN008;

table EAS2.CT_DSY_REPORTSYN009;

table EAS2.CT_DSY_REPORTSYN010;

table EAS2.CT_DSY_REPORTSYN011;

table EAS2.CT_DSY_REPORTSYN012;

table EAS2.CT_DSY_REPORTSYN013;

table EAS2.CT_DSY_REPORTSYN014;

table EAS2.CT_DSY_REPORTSYN015;

table EAS2.CT_DSY_REPORTSYN016;

table EAS2.CT_DSY_REPORTSYN017;

table EAS2.CT_DSY_REPORTSYN018;

table EAS2.CT_DSY_REPORTSYN019;

table EAS2.CT_DSY_REPORTSYN020;

table EAS2.CT_DSY_REPORTSYN020S1;

table EAS2.CT_DSY_REPORTSYN021;

table EAS2.CT_DSY_REPORTSYN021S1;

table EAS2.CT_DSY_REPORTSYN022;

table EAS2.CT_DSY_REPORTSYN023;

table EAS2.CT_DSY_REPORTSYN024;

table EAS2.CT_DSY_REPORTSYN025;

table EAS2.CT_DSY_REPORTSYN026;

table EAS2.CT_DSY_REPORTSYN027;

table EAS2.CT_DSY_REPORTSYN028;

table EAS2.CT_DSY_REPORTSYN029;

table EAS2.CT_DSY_REPORTSYN030;

table EAS2.CT_DSY_REPORTSYN031;

table EAS2.CT_DSY_REPORTSYN032;

table EAS2.CT_DSY_REPORTSYN033;

table EAS2.CT_DSY_REPORTSYN034;

table EAS2.CT_DSY_REPORTSYN035;

table EAS2.CT_DSY_REPORTSYN036;

配置投递进程

GGSCI >add extract p_tab,EXTTRAILSOURCE /ogg/software/dirdat/e_tab/ex

GGSCI >add rmttrail E:\ogg\software\dirdat\r_tab\re,ext p_tab,megabytes 200

GGSCI >edit param p_tab

extract p_tab

userid goldengate,password goldengate

rmthost 196.1.121.73,mgrport 7809,compress

FLUSHCSECS 40

EOFDELAYCSECS 10

rmttrail   E:\ogg\software\dirdat\r_tab\re

table EAS2.CT_DSY_REPORTSYN001;

table EAS2.CT_DSY_REPORTSYN002;

table EAS2.CT_DSY_REPORTSYN003;

table EAS2.CT_DSY_REPORTSYN004;

table EAS2.CT_DSY_REPORTSYN005;

table EAS2.CT_DSY_REPORTSYN006;

table EAS2.CT_DSY_REPORTSYN007;

table EAS2.CT_DSY_REPORTSYN008;

table EAS2.CT_DSY_REPORTSYN009;

table EAS2.CT_DSY_REPORTSYN010;

table EAS2.CT_DSY_REPORTSYN011;

table EAS2.CT_DSY_REPORTSYN012;

table EAS2.CT_DSY_REPORTSYN013;

table EAS2.CT_DSY_REPORTSYN014;

table EAS2.CT_DSY_REPORTSYN015;

table EAS2.CT_DSY_REPORTSYN016;

table EAS2.CT_DSY_REPORTSYN017;

table EAS2.CT_DSY_REPORTSYN018;

table EAS2.CT_DSY_REPORTSYN019;

table EAS2.CT_DSY_REPORTSYN020;

table EAS2.CT_DSY_REPORTSYN020S1;

table EAS2.CT_DSY_REPORTSYN021;

table EAS2.CT_DSY_REPORTSYN021S1;

table EAS2.CT_DSY_REPORTSYN022;

table EAS2.CT_DSY_REPORTSYN023;

table EAS2.CT_DSY_REPORTSYN024;

table EAS2.CT_DSY_REPORTSYN025;

table EAS2.CT_DSY_REPORTSYN026;

table EAS2.CT_DSY_REPORTSYN027;

table EAS2.CT_DSY_REPORTSYN028;

table EAS2.CT_DSY_REPORTSYN029;

table EAS2.CT_DSY_REPORTSYN030;

table EAS2.CT_DSY_REPORTSYN031;

table EAS2.CT_DSY_REPORTSYN032;

table EAS2.CT_DSY_REPORTSYN033;

table EAS2.CT_DSY_REPORTSYN034;

table EAS2.CT_DSY_REPORTSYN035;

table EAS2.CT_DSY_REPORTSYN036;

创建服务

>INSTALL ADDSERVICE

编辑GLOBALS

GGSCI >edit param ./GLOBALS

checkpointtable dbo.ckpttab

创建checkpoint表

GGSCI >dblogin sourcedb   ogg_odbc userid goldengate password goldengate

GGSCI >add checkpointtable dbo.ckpttab

配置MGR进程

GGSCI >edit params mgr

port 7809

DYNAMICPORTLIST 7840-7850

ACCESSRULE, PROG SERVER, ALLOW

autorestart er *, retries 5, waitminutes 3

purgeoldextracts F:\OGG\dirdat\*,usecheckpoints, minkeepdays 7

配置复制进程

a. 创建trail存放目录

E:\OGG\software\dirdat\r_tab

b.添加复制进程

GGSCI >add replicat r_tab,exttrail E:\OGG\software\dirdat\r_tab\re,begin now,checkpointtable dbo.ckpttab

GGSCI >edit param r_tab

replicat r_tab

sourcedefs E:\OGG\software\dirdef\tab.def

targetdb OGG_ODBC   userid goldengate , password goldengate

reperror default,discard

discardfile E:\OGG\software\dirrpt\remssql.dsc,append,megabytes 100

HANDLECOLLISIONS

ASSUMETARGETDEFS

map   EAS2.CT_DSY_REPORTSYN001,     target      dbo.CT_DSY_REPORTSYN001;       

map   EAS2.CT_DSY_REPORTSYN002,     target      dbo.CT_DSY_REPORTSYN002;       

map   EAS2.CT_DSY_REPORTSYN003,     target      dbo.CT_DSY_REPORTSYN003;       

map   EAS2.CT_DSY_REPORTSYN004,     target      dbo.CT_DSY_REPORTSYN004;       

map   EAS2.CT_DSY_REPORTSYN005,     target      dbo.CT_DSY_REPORTSYN005;       

map   EAS2.CT_DSY_REPORTSYN006,     target      dbo.CT_DSY_REPORTSYN006;       

map   EAS2.CT_DSY_REPORTSYN007,     target      dbo.CT_DSY_REPORTSYN007;       

map   EAS2.CT_DSY_REPORTSYN008,     target      dbo.CT_DSY_REPORTSYN008;       

map   EAS2.CT_DSY_REPORTSYN009,     target      dbo.CT_DSY_REPORTSYN009;       

map   EAS2.CT_DSY_REPORTSYN010,     target      dbo.CT_DSY_REPORTSYN010;       

map   EAS2.CT_DSY_REPORTSYN011,     target      dbo.CT_DSY_REPORTSYN011;       

map   EAS2.CT_DSY_REPORTSYN012,     target      dbo.CT_DSY_REPORTSYN012;       

map   EAS2.CT_DSY_REPORTSYN013,     target      dbo.CT_DSY_REPORTSYN013;       

map   EAS2.CT_DSY_REPORTSYN014,     target      dbo.CT_DSY_REPORTSYN014;       

map   EAS2.CT_DSY_REPORTSYN015,     target      dbo.CT_DSY_REPORTSYN015;       

map   EAS2.CT_DSY_REPORTSYN016,     target      dbo.CT_DSY_REPORTSYN016;       

map   EAS2.CT_DSY_REPORTSYN017,     target      dbo.CT_DSY_REPORTSYN017;       

map   EAS2.CT_DSY_REPORTSYN018,     target      dbo.CT_DSY_REPORTSYN018;       

map   EAS2.CT_DSY_REPORTSYN019,     target      dbo.CT_DSY_REPORTSYN019;       

map   EAS2.CT_DSY_REPORTSYN020,     target      dbo.CT_DSY_REPORTSYN020;       

map   EAS2.CT_DSY_REPORTSYN020S1,   target      dbo.CT_DSY_REPORTSYN020S1;     

map   EAS2.CT_DSY_REPORTSYN021,     target      dbo.CT_DSY_REPORTSYN021;       

map   EAS2.CT_DSY_REPORTSYN021S1,   target      dbo.CT_DSY_REPORTSYN021S1;     

map   EAS2.CT_DSY_REPORTSYN022,     target      dbo.CT_DSY_REPORTSYN022;       

map   EAS2.CT_DSY_REPORTSYN023,     target      dbo.CT_DSY_REPORTSYN023;       

map   EAS2.CT_DSY_REPORTSYN024,     target      dbo.CT_DSY_REPORTSYN024;       

map   EAS2.CT_DSY_REPORTSYN025,     target      dbo.CT_DSY_REPORTSYN025;       

map   EAS2.CT_DSY_REPORTSYN026,     target      dbo.CT_DSY_REPORTSYN026;       

map   EAS2.CT_DSY_REPORTSYN027,     target      dbo.CT_DSY_REPORTSYN027;       

map   EAS2.CT_DSY_REPORTSYN028,     target      dbo.CT_DSY_REPORTSYN028;       

map   EAS2.CT_DSY_REPORTSYN029,     target      dbo.CT_DSY_REPORTSYN029;       

map   EAS2.CT_DSY_REPORTSYN030,     target      dbo.CT_DSY_REPORTSYN030;       

map   EAS2.CT_DSY_REPORTSYN031,     target      dbo.CT_DSY_REPORTSYN031;       

map   EAS2.CT_DSY_REPORTSYN032,     target      dbo.CT_DSY_REPORTSYN032;       

map   EAS2.CT_DSY_REPORTSYN033,     target      dbo.CT_DSY_REPORTSYN033;       

map   EAS2.CT_DSY_REPORTSYN034,     target      dbo.CT_DSY_REPORTSYN034;       

map   EAS2.CT_DSY_REPORTSYN035,     target      dbo.CT_DSY_REPORTSYN035;       

map   EAS2.CT_DSY_REPORTSYN036,     target      dbo.CT_DSY_REPORTSYN036;       

初始化数据

a.在SQLSERVER创建相应表

b.源端导出相应表初始化数据

GGSCI> edit param exinit

SOURCEISTABLE

userid goldengate , password goldengate

rmthost 196.1.121.73, mgrport 7809

RMTFILE E:\OGG\software\dirdat\r_tab\ex,MAXFILES 1024, MEGABYTES 1024

table EAS2.CT_DSY_REPORTSYN001;

table EAS2.CT_DSY_REPORTSYN002;

table EAS2.CT_DSY_REPORTSYN003;

table EAS2.CT_DSY_REPORTSYN004;

table EAS2.CT_DSY_REPORTSYN005;

table EAS2.CT_DSY_REPORTSYN006;

table EAS2.CT_DSY_REPORTSYN007;

table EAS2.CT_DSY_REPORTSYN008;

table EAS2.CT_DSY_REPORTSYN009;

table EAS2.CT_DSY_REPORTSYN010;

table EAS2.CT_DSY_REPORTSYN011;

table EAS2.CT_DSY_REPORTSYN012;

table EAS2.CT_DSY_REPORTSYN013;

table EAS2.CT_DSY_REPORTSYN014;

table EAS2.CT_DSY_REPORTSYN015;

table EAS2.CT_DSY_REPORTSYN016;

table EAS2.CT_DSY_REPORTSYN017;

table EAS2.CT_DSY_REPORTSYN018;

table EAS2.CT_DSY_REPORTSYN019;

table EAS2.CT_DSY_REPORTSYN020;

table EAS2.CT_DSY_REPORTSYN020S1;

table EAS2.CT_DSY_REPORTSYN021;

table EAS2.CT_DSY_REPORTSYN021S1;

table EAS2.CT_DSY_REPORTSYN022;

table EAS2.CT_DSY_REPORTSYN023;

table EAS2.CT_DSY_REPORTSYN024;

table EAS2.CT_DSY_REPORTSYN025;

table EAS2.CT_DSY_REPORTSYN026;

table EAS2.CT_DSY_REPORTSYN027;

table EAS2.CT_DSY_REPORTSYN028;

table EAS2.CT_DSY_REPORTSYN029;

table EAS2.CT_DSY_REPORTSYN030;

table EAS2.CT_DSY_REPORTSYN031;

table EAS2.CT_DSY_REPORTSYN032;

table EAS2.CT_DSY_REPORTSYN033;

table EAS2.CT_DSY_REPORTSYN034;

table EAS2.CT_DSY_REPORTSYN035;

table EAS2.CT_DSY_REPORTSYN036;

在源端OGG目录下执行（这个过程会在目标端生成E:\OGG\software\dirdat\r_tab\ex文件）：

$ ./extract paramfile ./dirprm/exinit.prm reportfile ./dirrpt/exinit.rpt

c.启动源端各进程

GGSCI>start *

–目标: 初始加载配置

GGSCI(MSSQL)> EDIT PARAMS INLOAD

SPECIALRUN

END RUNTIME

targetdb ogg_odbc   userid goldengate , password goldengate

EXTFILE E:\OGG\software\dirdat\r_tab\ex

SOURCEDEFS E:\OGG\software\dirdef\tab.def

map   EAS2.CT_DSY_REPORTSYN001,     target      dbo.CT_DSY_REPORTSYN001;       

map   EAS2.CT_DSY_REPORTSYN002,     target      dbo.CT_DSY_REPORTSYN002;       

map   EAS2.CT_DSY_REPORTSYN003,     target      dbo.CT_DSY_REPORTSYN003;       

map   EAS2.CT_DSY_REPORTSYN004,     target      dbo.CT_DSY_REPORTSYN004;       

map   EAS2.CT_DSY_REPORTSYN005,     target      dbo.CT_DSY_REPORTSYN005;       

map   EAS2.CT_DSY_REPORTSYN006,     target      dbo.CT_DSY_REPORTSYN006;       

map   EAS2.CT_DSY_REPORTSYN007,     target      dbo.CT_DSY_REPORTSYN007;       

map   EAS2.CT_DSY_REPORTSYN008,     target      dbo.CT_DSY_REPORTSYN008;       

map   EAS2.CT_DSY_REPORTSYN009,     target      dbo.CT_DSY_REPORTSYN009;       

map   EAS2.CT_DSY_REPORTSYN010,     target      dbo.CT_DSY_REPORTSYN010;       

map   EAS2.CT_DSY_REPORTSYN011,     target      dbo.CT_DSY_REPORTSYN011;       

map   EAS2.CT_DSY_REPORTSYN012,     target      dbo.CT_DSY_REPORTSYN012;       

map   EAS2.CT_DSY_REPORTSYN013,     target      dbo.CT_DSY_REPORTSYN013;       

map   EAS2.CT_DSY_REPORTSYN014,     target      dbo.CT_DSY_REPORTSYN014;       

map   EAS2.CT_DSY_REPORTSYN015,     target      dbo.CT_DSY_REPORTSYN015;       

map   EAS2.CT_DSY_REPORTSYN016,     target      dbo.CT_DSY_REPORTSYN016;       

map   EAS2.CT_DSY_REPORTSYN017,     target      dbo.CT_DSY_REPORTSYN017;       

map   EAS2.CT_DSY_REPORTSYN018,     target      dbo.CT_DSY_REPORTSYN018;       

map   EAS2.CT_DSY_REPORTSYN019,     target      dbo.CT_DSY_REPORTSYN019;       

map   EAS2.CT_DSY_REPORTSYN020,     target      dbo.CT_DSY_REPORTSYN020;       

map   EAS2.CT_DSY_REPORTSYN020S1,   target      dbo.CT_DSY_REPORTSYN020S1;     

map   EAS2.CT_DSY_REPORTSYN021,     target      dbo.CT_DSY_REPORTSYN021;       

map   EAS2.CT_DSY_REPORTSYN021S1,   target      dbo.CT_DSY_REPORTSYN021S1;     

map   EAS2.CT_DSY_REPORTSYN022,     target      dbo.CT_DSY_REPORTSYN022;       

map   EAS2.CT_DSY_REPORTSYN023,     target      dbo.CT_DSY_REPORTSYN023;       

map   EAS2.CT_DSY_REPORTSYN024,     target      dbo.CT_DSY_REPORTSYN024;       

map   EAS2.CT_DSY_REPORTSYN025,     target      dbo.CT_DSY_REPORTSYN025;       

map   EAS2.CT_DSY_REPORTSYN026,     target      dbo.CT_DSY_REPORTSYN026;       

map   EAS2.CT_DSY_REPORTSYN027,     target      dbo.CT_DSY_REPORTSYN027;       

map   EAS2.CT_DSY_REPORTSYN028,     target      dbo.CT_DSY_REPORTSYN028;       

map   EAS2.CT_DSY_REPORTSYN029,     target      dbo.CT_DSY_REPORTSYN029;       

map   EAS2.CT_DSY_REPORTSYN030,     target      dbo.CT_DSY_REPORTSYN030;       

map   EAS2.CT_DSY_REPORTSYN031,     target      dbo.CT_DSY_REPORTSYN031;       

map   EAS2.CT_DSY_REPORTSYN032,     target      dbo.CT_DSY_REPORTSYN032;       

map   EAS2.CT_DSY_REPORTSYN033,     target      dbo.CT_DSY_REPORTSYN033;       

map   EAS2.CT_DSY_REPORTSYN034,     target      dbo.CT_DSY_REPORTSYN034;       

map   EAS2.CT_DSY_REPORTSYN035,     target      dbo.CT_DSY_REPORTSYN035;       

map   EAS2.CT_DSY_REPORTSYN036,     target      dbo.CT_DSY_REPORTSYN036;   

d.目标段导入相应初始化数据并启动进程

进入OGG目录执行初始化数据：

replicat paramfile ./dirprm/reinit.prm

最后启动复制进程：

GGSCI>start *