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