ogg
zhaojian1988
这个作者很懒,什么都没留下…
展开
-
ERROR OGG-01820 Could not enable workspace
【OGG-01820】 Description: Could not enable workspace Cause: An attempt to handle transient duplicates in an update statement failed. Action: Restart Replicat. If the pro原创 2014-09-17 10:14:05 · 1910 阅读 · 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 · 4606 阅读 · 0 评论 -
ERROR OGG-00524 DDL trace log file [\ggs_ddl_trace.log], error code -20782 error message ORA-207
GGSCI (zydb) 12> info all Program Status Group Lag Time SinceChkpt MANAGER RUNNING EXTRACT ABENDED ESOURCE 14:14:06原创 2014-11-21 10:57:51 · 3128 阅读 · 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 · 3358 阅读 · 0 评论 -
Oracle GoldenGate software 下载地址
http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html Note: Oracle GoldenGate software for other databases and platforms is available at Oracle E-Delivery.com.原创 2014-12-12 17:03:31 · 857 阅读 · 0 评论 -
ogg增加表
步骤: stop ESOURCE stop PSOURCE $ pwd /zyhome/oracle/ogg/dirprm $ ls esource.prm mgr.prm psource.prm $vi esource.prm TABLE GISTAR.RM_PRODUCT_OSS; GGSCI>dblogin userid oggadm, pass原创 2014-12-30 16:35:38 · 827 阅读 · 0 评论 -
ogg同步表
oracle11.2.0.4 Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 1.stop r_bj 2.查看scn col GET_SYSTEM_CHANGE_NUMBER for 999999999999999999999999 select dbms_flashback.get_system_cha原创 2015-05-06 18:32:42 · 1776 阅读 · 0 评论 -
怎样可以通过读trail文件得出OGG使用啥sql 同步数据的
Logdump 48 >ghdr on Logdump 49 >detail on Logdump 50 >detail data Logdump 51 >open d:\trail1\tr000000 LogTrail d:\trail1\tr000000 closed Current LogTrail is d:\trail1\tr000000 Logdump 52 >filter原创 2015-06-15 17:14:45 · 3578 阅读 · 1 评论