-
-
-
超过十年Oracle数据库管理经验,擅长Oracle数据库诊断、优化。擅长产品包括 Oracle Database,RAC,RAT,ADG,Exadata,EM12c等
Gtalk&Mail: ricky.zhu#gmail.com Meta
-
Recent
Archive
- March 2016 (1)
- January 2016 (1)
- January 2014 (1)
- November 2013 (1)
- October 2013 (1)
- August 2013 (1)
- July 2013 (1)
- June 2013 (1)
- April 2013 (1)
- March 2013 (1)
- January 2013 (1)
- December 2012 (1)
- August 2012 (1)
- June 2012 (2)
- March 2012 (1)
- February 2012 (1)
- January 2012 (1)
- December 2011 (4)
- November 2011 (5)
- October 2011 (1)
- September 2011 (2)
- August 2011 (1)
- June 2011 (1)
- May 2011 (2)
- January 2011 (2)
- November 2010 (2)
- October 2010 (3)
- September 2010 (2)
- August 2010 (2)
- July 2010 (5)
- June 2010 (1)
- May 2010 (6)
- April 2010 (3)
- March 2010 (4)
- February 2010 (2)
- January 2010 (4)
- December 2009 (4)
- November 2009 (6)
- October 2009 (6)
- September 2009 (8)
- August 2009 (3)
- July 2009 (7)
- June 2009 (5)
- May 2009 (2)
- April 2009 (7)
- March 2009 (9)
- February 2009 (8)
- January 2009 (3)
- December 2008 (4)
- November 2008 (5)
- October 2008 (8)
- September 2008 (9)
- August 2008 (8)
- July 2008 (3)
- June 2008 (11)
- May 2008 (6)
- April 2008 (4)
- March 2008 (5)
- February 2008 (12)
- January 2008 (15)
- December 2007 (14)
- November 2007 (21)
- October 2007 (15)
- September 2007 (11)
- August 2007 (19)
- July 2007 (17)
- June 2007 (18)
- May 2007 (39)
- April 2007 (43)
- March 2007 (61)
- February 2007 (32)
- January 2007 (11)
- December 2006 (15)
Category
Oracle相关网站
博客圈子
数据库圈子
测试圈子
测试网站
Visitor
Tag Archives: GoldenGate
installment loans 如何在11gR2 RAC上配置GoldenGate (上)
Oracle 11gR2 RAC和GoldenGate都是Oracle比较热门的产品,经过简单的学习和阅读文档,配置单节点的GoldenGate进行数据的复制相信不是什么太有难度的事情,但是对于利用GoldenGate进行RAC系统到RAC系统的复制,还是有些配置的技巧和策略设置的,前阵子就遇到一个这样一个问题:假设源和目标分别是两节点的RAC系统,如何保证目标部分节点失效的时候replicate会自动切换? 其实如果了解GG的工作机制和RAC的资源管理,问题的解决就十分清晰了。 best installment loans for bad credit 今天就从系统的介绍下11gR2 RAC上OGG (Oracle GoldenGate的简称,下同)的完整配置步骤,并简单谈谈如何解决上面这个场景的问题。 第一阶段:下载OGG(可以参考之前的单节点的复制例子,不再赘述) OGG的下载地址 第二阶段:OGG的安装 1)登录源端的RAC系统中的任一个节点,并在ACFS上建立一个供OGG使用的共享目录,比如叫/cloudfs/goldengate 2)解压OGG的安装包到/cloudfs/goldengate目录 3) 设置好OGG工作的环境变量,比如 export LIBRARY_PATH=/cloudfs/goldengate:$ORACLE_HOME/lib:$LD_LIBRARY_PATH 4)启动ggsci并创建目录,然后进行必要的设置,启动manager $ ggsci GGSCI > create subdirs (optional, support for DDL/Sequence) Create and edit the parameter file … Continue reading
Oracle GoldenGate配置过程
在同一个库的不同schema之间进行GoldenGate的配置,下面是详细的步骤。 1, 解压ogg的zip包,ogg是绿色软件,直接解压即可。 2,建立ogg所需的目录,直接用ggsci,然后命令create subdirs [oracle@localhost base]$ ggsci Oracle GoldenGate Command Interpreter for Oracle Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100 Linux, x64, 64bit (optimized), Oracle 11g on Oct 4 2011 23:49:46 Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved. GGSCI … Continue reading
GoldenGate常见异常处理
今天花了整整一天,把Oracle GoldenGate配置了起来,期间遇到无数的问题,但是都是逢凶化吉,通过文档和Google搞定了,如下做个小小的总结。至于GoldenGate的配置过程暂且不表,待后续在做详细介绍。 源数据库在OEL5.4 64bit的虚拟机上,数据库版本是11.2.0.3 目标数据库也是同一个虚拟机上的数据库。 建了两个不同的schema,jjs和jjt 遇到的几个异常和解决方法在这篇中都有记载,现在转录如下: Scenario 1: Extract parameter file is invalid. EXTRACT ext1 USERID ggate, PASSWORD ggate TABLE jjs.j1 Source Context : SourceModule : [ggapp.parmscn] SourceID : [$Id: //depot/releases/OpenSys/v10.4.0/src/gglib/ggapp/parmscn.c#1 $] SourceFunction : [ci_get_next_cmd] SourceLine : [1800] ThreadBacktrace … Continue reading