oracle golden gate 搭建,Oracle GoldenGate安装配置

3. 配置manager

在源端和目标端分别执行下面的步骤。

3.1 创建manager

[ggate@gridcontrol gg]$ ./ggsci

GGSCI (gridcontrol) 1> info all

Program    Status      Group      Lag          Time Since Chkpt

MANAGER    STOPPED

GGSCI (gridcontrol) 2> edit params mgr

PORT 7809

ggate (gridcontrol) 3> start manager

Manager started.

4. 配置源端复制队列

GGSCI (gridcontrol) 1> add extract ext1, tranlog,begin now

EXTRACT added.

GGSCI (gridcontrol) 2> add exttrail/Oracle/ggate/dirdat/lt, extract ext1

EXTTRAIL added.

GGSCI (gridcontrol) 3> edit params ext1

extract ext1

userid ggate@testdg, password ggate

tranlogoptions ASMUSER sys@+ASM,ASMPASSWORD 123456 (服务器用ASM增加此项，另listener.ora和tnsname.ora增加ASM，示例最后)

rmthost CentOS4, mgrport 7809

rmttrail /oracle/ggate/dirdat/lt

ddl include mapped objname sender.*;

table sender.*;

GGSCI (gridcontrol) 6> info all

Program    Status      Group      Lag          Time Since Chkpt

MANAGER    STOPPED

EXTRACT    STOPPED    EXT1        00:00:00      00:10:55

5. 配置目标端同步队列

5.1 在目标端添加checkpoint表

[oracle@centos4 ggate]$ ./ggsci

GGSCI (centos4) 1> edit params ./GLOBAL  –添加下列内容

GGSCHEMA ggate

CHECKPOINTTABLE ggate.checkpoint

GGSCI (centos4) 2> dblogin userid ggate@target

Password:

Successfully logged into database.

GGSCI (centos4) 3> add checkpointtableggate.checkpoint

Successfully created checkpoint tableGGATE.CHECKPOINT.

5.2 创建同步队列

GGSCI (centos4) 4> add replicat rep1, exttrail/u01/app/oracle/ggate/dirdat/lt, checkpointtable ggate.checkpoint

REPLICAT added.

GGSCI (centos4) 5> edit params rep1

replicat rep1

HANDLECOLLISIONS

ASSUMETARGETDEFS

userid ggate@testdg2, password ggatetranlogoptionsASMUSER sys@+ASM,ASMPASSWORD 123456 (客户端用ASM增加此项，另listener.ora和tnsname.ora增加ASM，示例如后)

discardfile /oracle/ggate/dirdat/rep1_discard.txt,append, megabytes 10

DDL INCLUDE ALL

DDLERROR DEFAULT IGNORE RETRYOP

map sender.*, target receiver.*;

discardfile /oracle/ggate/dirdat/rep1_discard.txt,append, megabytes 10

DDL

map sender.*, target receiver.*;