导航：首页 > 数据库 >

OGG搭建步骤

发表于：2025-02-02 作者：千家信息网编辑

千家信息网最后更新 2025年02月02日，AIX-->HP-UX1，下载GGS安装tar -xvf ggs_AIX_ppc_ora102_64bit_v11_1_1_0_0_078.tar2，创建目录GGSCI (test4-154) 1>

千家信息网最后更新 2025年02月02日OGG搭建步骤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

很赞哦！