![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
GoldenGate
文章平均质量分 81
Phoenix_99
这个作者很懒,什么都没留下…
展开
-
GolddenGate
一.原理图二、安装 1.Downloading Oracle GoldenGate software. 2.Setting ORACLE_HOME and ORACLE_SID 3.Setting library paths for dynamic builds 4.Installing Oracle GoldenGate software三、下载地址http://edelivery .oracle.com下载oracle GoldenGate on Oracle v11.1.1.0.0 Media Pac原创 2011-01-30 19:02:00 · 1794 阅读 · 0 评论 -
GoldenGate-数据分发
一、.准备前提:保证3台机器(A-源机,B-目标机,C-目标机),能够互相通信,且都装有oracle和GoldenGateA机:172.28.132.231B机:172.28.132.235C机:172.28.132.2361. 在A,B,C机器上配置管理进程 edit params mgr 输入:port 78092.数据初始化 A机:配置发送extract edit params einikk 如下: extract einikk userid system, password "原创 2011-05-10 18:22:00 · 1324 阅读 · 0 评论 -
GoldenGate--多对一
前提: 源1:192.168.0.100 源2:192.168.0.101 目标:192.168.0.99一、配置数据源添加ggusr用户下表的log,放到日志里 dblogin userid system, password oracle add trandata ggusr.*1.增加抽取extract sd1 add extract sd1, tranlog, begin now 2.关联trail文件 add exttrail ./dirdat/co, extract sd1, meg原创 2011-05-15 22:42:00 · 3183 阅读 · 3 评论 -
GoldenGate的基本操作
<br />1.查看帮助<br /> help, help add exttrail<br /> <br />2.显示当前的GoldenGate环境信息<br /> show<br /> <br />3.查看运行状态<br /> info all, info mgr, info extract einikk<br /> <br />4.启动和停止服务<br /> start mgr,stop mgr<br /> start extract einikk,stop extract einikk<br /原创 2011-04-20 21:24:00 · 1565 阅读 · 0 评论 -
GolddenGate的用户下所有表及DDL配置
1.gguser下所有表的变动情况及时反映到目的数据库源机: GGSCI (localhost.localdomain) 3> edit params eorakkEXTRACT EORAKKUSERID system, PASSWORD oracleRMTHOST 192.168.0.100, MGRPORT 7809RMTTRAIL ./dirdat/kkTABLE gguser.*;目标机: REPLICAT RORAKKUSERID system, PASSWORD oracleHANDLEC原创 2011-04-21 18:57:00 · 4189 阅读 · 0 评论 -
GoldenGate-增加datadump的数据同步
1.在GolddenGate文章中,如果网络断开的话,在目标机器上并不能生成trail文件,因此就会出现错误。2011-04-23 17:44:16 ERROR OGG-01033 There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (R原创 2011-04-24 00:08:00 · 3552 阅读 · 0 评论 -
GolddenGate-双向复制
<br />一、源机配置<br />1.增加extract<br /> add extract extb1, tranlog, begin now, threads 1<br /> <br />2.配置extract<br />extract extb1<br />userid system, password oracle ----该用户为同步用户<br />tranlogoptions excludeuser system ---排除同步用户,避免循环<br />rmthost 192.168.0原创 2011-04-26 23:01:00 · 3825 阅读 · 0 评论