您好,欢迎访问一九零五行业门户网

GoldenGate双向复制配置

先进入goldengate软件安装目录,以sysdba身份登录oracle执行以下脚本,执行脚本过程中,需要输入的用户全部是ogg,安装模式为ini
一、双向复制节点2配置:
1)添加附加的redolog信息
 dblogin userid ogg, password ogg
add trandata scott.*
2)配置extract
ggsci (cuug97) 11> edit params eora_1
extract eora_1
setenv (nls_lang=american_america.zhs16gbk)
userid ogg, password ogg
tranlogoptions excludeuser ogg (双向复制的配置关键)
exttrail ./dirdat/aa
table scott.*;
ggsci (cuug97) 11> add extract eora_1, tranlog, begin now
extract added.
ggsci (cuug97) 12> add exttrail ./dirdat/aa, extract eora_1, megabytes 5
exttrail added.
ggsci (cuug97) 13> start extract eora_1
3)配置pump进程
ggsci (cuug97) 15> edit params pora_1
extract pora_1
setenv (nls_lang=american_america.zhs16gbk)
passthru
rmthost cuug95, mgrport 7809
rmttrail ./dirdat/pa
table scott.*;
ggsci (cuug97) 16> add extract pora_1, exttrailsource ./dirdat/aa
extract added.
ggsci (cuug97) 17> add rmttrail ./dirdat/pa, extract pora_1, megabytes 5
rmttrail added.
ggsci (cuug97) 18> start extract pora_1
4、第一节点(原来的源数据库)
1、配置checkpoint
ggsci (cuug95) 1> edit params ./globals
checkpointtable ogg.ggschkpt
ggsci (cuug95) 1> exit
ggsci (cuug95) 1> dblogin userid ogg, password ogg
successfully logged into database.
ggsci (cuug95) 2> add checkpointtable
2、配置replicate
ggsci (cuug95) 4> edit param rora_1
replicat rora_1
setenv (nls_lang=american_america.zhs16gbk)
userid ogg, password ogg
handlecollisions
assumetargetdefs
discardfile ./dirrpt/rora_aa.dsc, purge
map scott.*, target scott.*;
ggsci (cuug95) 4> add replicat rora_1, exttrail ./dirdat/pa
ggsci (cuug95) 6> start replicat rora_1

其它类似信息

推荐信息