最近2018中文字幕在日韩欧美国产成人片_国产日韩精品一区二区在线_在线观看成年美女黄网色视频_国产精品一区三区五区_国产精彩刺激乱对白_看黄色黄大色黄片免费_人人超碰自拍cao_国产高清av在线_亚洲精品电影av_日韩美女尤物视频网站

AIX-->HP-UX
1，下載GGS安裝
tar -xvf  ggs_AIX_ppc_ora102_64bit_v11_1_1_0_0_078.tar

2，創(chuàng)建目錄
GGSCI (test4-154) 1> create subdirs

3，源端添加附加日志
數(shù)據(jù)庫級：
SQL>alter database add supplemental log data;
表級：
GGSCI (test4-154) > dblogin userid goldengate,password goldengate
GGSCI (test4-154) > add trandata goldengate.TCU*

4，配置源端mgr進(jìn)程
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進(jìn)程
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進(jìn)程
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，啟動源端進(jìn)程
GGSCI (test4-154) > start  mgr
GGSCI (test4-154) > start *
---------------------------------
EXP|IMP同步數(shù)據(jù)
---------------------------------

8，配置目標(biāo)端mgr進(jìn)程
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，目標(biāo)端添加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進(jìn)程
ADD REPLICAT rep_jb01,EXTTRAIL /oracle/test/dirdat/jb CHECKPOINTTABLE goldengate.ggschkpoint

11，啟動目標(biāo)端進(jìn)程
start mgr
Start  rep_jb01 aftercsn  xxxxx


文章名稱：OGG搭建步驟
網(wǎng)站路徑：http://fisionsoft.com.cn/article/jheccs.html