ITPub博客

首页 > 数据库 > Oracle > OGG搭建步骤

OGG搭建步骤

原创 Oracle 作者:xj951423274 时间:2017-12-06 19:40:51 0 删除 编辑
AIX-->HP-UX
1,下载GGS安装
tar -xvf  ggs_AIX_ppc_ora102_64bit_v11_1_1_0_0_078.tar

2,创建目录
GGSCI (test4-154) 1> create subdirs

3,源端添加附加日志
数据库级:
SQL>alter database add supplemental log data;
表级:
GGSCI (test4-154) > dblogin userid goldengate,password goldengate
GGSCI (test4-154) > add trandata goldengate.TCU*

4,配置源端mgr进程
GGSCI (test4-154) > edit params mgr
PORT 7809
dynamicportlist 7810-7815
autostart extract *
autorestart extract *,retries 5,waitminutes 7
purgeoldextracts ./dirdat/et,usecheckpoints,minkeepdays 1
lagreporthours 1
laginfominutes 10
lagcriticalminutes 15

5,配置EXTRACT进程
GGSCI (test4-154) > add extract ext1,tranlog,begin now
GGSCI (test4-154) > add exttrail /ogg/dirdat/et, extract ext1,megabytes 50
EXTTRAIL added.
GGSCI (test4-154) 19> edit params ext1
extract ext1
dynamicresolution
userid goldengate, password goldengate
exttrail /ogg/dirdat/jb
table goldengate.TCUSTMER;
table goldengate.TCUSTORD;

6,配置PUMP进程
GGSCI (test4-154) 21> add extract pump1,exttrailsource /ogg/dirdat/jb
EXTRACT added.
GGSCI (test4-154) 22> add rmttrail /oracle/test/dirdat/et,extract pump1,MEGABYTES  50
RMTTRAIL added.
GGSCI (test4-154) 23> edit params pump1
EXTRACT  pmpjb
PASSTHRU
UserId goldengate, Password goldengate
RMTHOST 10.118.88.22, MGRPORT 7809
RMTTRAIL /oracle/test/dirdat/jb
numfiles 50
DYNAMICRESOLUTION
TABLE goldengate.TCUSTMER;
TABLE goldengate.TCUSTORD;

7,启动源端进程
GGSCI (test4-154) > start  mgr
GGSCI (test4-154) > start *
---------------------------------
EXP|IMP同步数据
---------------------------------

8,配置目标端mgr进程
PORT 7809
dynamicportlist 7810-7815w params mgr
autorestart extract *,waitminutes 1,retries 5
lagreporthours 1
laginfominutes 3
lagcriticalminutes 5
purgeoldextracts /oracle/test/dirdat/jb*,usecheckpoints,minkeepdays 1

9,目标端添加chkpoint
GGSCI (HP-test1) 5> edit params ./GLOBAL
GGSCHEMA goldengate
CHECKPOINTTABLE  goldengate.ggschkpt
GGSCI (HP-test1) 9> dblogin userid goldengate,password goldengate
GGSCI (HP-test1) 10> add checkpointtable goldengate.ggschkpt

10,添加replicat进程
ADD REPLICAT rep_jb01,EXTTRAIL /oracle/test/dirdat/jb CHECKPOINTTABLE goldengate.ggschkpoint

11,启动目标端进程
start mgr
Start  rep_jb01 aftercsn  xxxxx

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/28275505/viewspace-2148368/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 拆分replicate
请登录后发表评论 登录
全部评论

注册时间:2013-07-29

  • 博文量
    22
  • 访问量
    29229