GOLDENGATE
孙海龙_1982
这个作者很懒,什么都没留下…
展开
-
通向架构师之路 --Victor Guan 源表字段修改以后引发GoldenGate同步失败
前天接到一客户电话,说他们的数据库同步报错了,错误信息如下:ERROR OGG-01163 Bad column length (3) specified for column col81 in table XXX.TT, maximum allowable length is 1.经询问,得知是由于他们系统升级,有些表增加并修改了部分字段,其中的一个表同步失败,报上面的错误。我转载 2012-10-25 00:46:07 · 2831 阅读 · 0 评论 -
DSG重新全同步操作步骤
DSG有时莫名奇妙的挂起或出错,如果数据量小可以考虑重新全同步!该手册适用于DSG复制目标端和源端数据不一致或链路报错无法启动,需要进行全同步时操作,该步骤将破坏原有复制链路的可用性操作时务必谨慎。source(30):1.$DSG_HOME/script/stop vagent2. $DSG_HOME/script/check3. $DSG_HOME/script/cle原创 2012-10-29 12:04:54 · 1436 阅读 · 0 评论 -
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
配置ORACLE->MYSQL时目标端使用dblogin登陆mysql时报错2013-02-07 10:12:59 WARNING OGG-00769 MySQL Login failed: . SQL error (2002). Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2).ERROR原创 2013-02-07 10:13:39 · 768 阅读 · 0 评论 -
How to See the OGG Extract BR (Bounded Recovery) Checkpoint Information in GGSCI [ID 1373138.1]
Applies to: Oracle GoldenGate - Version: 11.1.1.1.0 and later [Release: 11.1.1.1 and later ]Information in this document applies to any platform.GoalHow can the Extract BR (bounded recovery)转载 2013-03-05 08:03:52 · 854 阅读 · 0 评论 -
DDL Replication is not supported for this database.
DDL Replication is not supported for this database.今天配置ORACLE->MYSQL复制,由于源端与ORACLE->ORACLE的extract进程共用而且extract抽取DDL但是DDL复制到ORACLE上可以,复制到mysql中却报错,在目标端使用了禁用DDL的参数也没有生效DDLERROR DEFAULT IGNO原创 2013-03-24 16:29:00 · 1036 阅读 · 0 评论 -
format RELEASE 10.4/11.1 to output file .. with format RELEASE 错误解决
配置ORACLE->MYSQL时,PUMP进程报错:2013-03-24 15:31:53 ERROR OGG-01411 Oracle GoldenGate Capture for Oracle, edp118.prm: Cannot convert input file /oracle/app/goldengate/dirdat/mm000000 with format RELE原创 2013-03-24 16:15:11 · 1539 阅读 · 0 评论