ogg
zhaojian1988
这个作者很懒,什么都没留下…
展开
-
ERROR OGG-01820 Could not enable workspace
【OGG-01820】Description:Could not enable workspaceCause:An attempt to handle transient duplicates in an update statement failed.Action:Restart Replicat. If the pro原创 2014-09-17 10:14:05 · 1952 阅读 · 0 评论 -
skip a transaction in goldengate(跳过一个事务OGG)
我们现在用OGG做两个ORACLE OLTP数据库的A-A同步含DDL,刚发现Replicat进程ABENDING了,下面分析一下原因ggserr.log日志2012-10-31 17:09:05 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, ricme.prm: OCI Error ORA-02292: int转载 2014-11-21 12:42:30 · 4627 阅读 · 0 评论 -
ERROR OGG-00524 DDL trace log file [\ggs_ddl_trace.log], error code -20782 error message ORA-207
GGSCI (zydb) 12> info allProgram Status Group Lag Time SinceChkptMANAGER RUNNING EXTRACT ABENDED ESOURCE 14:14:06原创 2014-11-21 10:57:51 · 3158 阅读 · 0 评论 -
WARNING OGG-01223 TCP/IP error 78 (Connection timed out)
2015-01-3012:38:02 INFO OGG-01226 Socket buffer size set to 27985 (flush size 27985).2015-01-3012:39:18 WARNING OGG-01223 TCP/IP error 78 (Connection timed out).2015-01-3012:39:28 INFO O原创 2015-01-30 12:46:19 · 3382 阅读 · 0 评论 -
Oracle GoldenGate software 下载地址
http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.htmlNote: Oracle GoldenGate software for other databases and platforms is available at Oracle E-Delivery.com.原创 2014-12-12 17:03:31 · 870 阅读 · 0 评论 -
ogg增加表
步骤:stop ESOURCEstop PSOURCE$ pwd/zyhome/oracle/ogg/dirprm$ lsesource.prm mgr.prm psource.prm$vi esource.prmTABLE GISTAR.RM_PRODUCT_OSS;GGSCI>dblogin userid oggadm, pass原创 2014-12-30 16:35:38 · 839 阅读 · 0 评论 -
ogg同步表
oracle11.2.0.4 Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 1.stop r_bj2.查看scncol GET_SYSTEM_CHANGE_NUMBER for 999999999999999999999999select dbms_flashback.get_system_cha原创 2015-05-06 18:32:42 · 1808 阅读 · 0 评论 -
怎样可以通过读trail文件得出OGG使用啥sql 同步数据的
Logdump 48 >ghdr onLogdump 49 >detail onLogdump 50 >detail dataLogdump 51 >open d:\trail1\tr000000LogTrail d:\trail1\tr000000 closedCurrent LogTrail is d:\trail1\tr000000Logdump 52 >filter原创 2015-06-15 17:14:45 · 3591 阅读 · 1 评论