ITPub博客

What Does The HANDLECOLLISIONS Parameter Do? [ID 966207.1] 修改时间 11-MAR-2011 类型 HOWTO 状态 PUBLISHED In this Document Solution Applies to: Oracle GoldenGate - Version: 4.0.0 and later [Release: 4.0.0 and later ]Information in this document applies to any platform. Solution QuestionWhat does HANDLECOLLISIONS do?AnswerHANDLECOLLISIONS is a Replicat parameter that is mainly used during initial loa

5.10 AIX Minimum Library RequirementsSome versions of AIX 5.3 do not have the latest runtime libraries required by Oracle GoldenGate. Please make sure the following minimums are met: xlC.aix50.rte 10.1.0.0 COMMITTED XL C/C++ Runtime for AIX 5.3 xlC.msg.en_US.rte 10.1.0.0 COMMITTED XL C/C++ Runtime xlC.rte 10.1.0.0 COMMITTED XL C/C++ RuntimeInstalled libraries can be found using the following command from a shell prompt: lslpp -l | g

修改时间 25-MAR-2011 类型 ANNOUNCEMENT 状态 PUBLISHED In this Document What is being announced? What do you need to do? Documentation: FAQ: Applies to: Management Pack for Oracle GoldenGate - Version: 2.0.0.0 and later [Release: 2.0 and later ]Information in this document applies to any platform. What is being announced? This includes references to documentation and the most commonly accessed Notes: What do

以下摘自goldengate v11.1.1 reference 第324页：Using COLMAPUse COLMAP to explicitly map source columns to target columns that have different namesor to specify default column mapping when source and target names are identical. COLMAPprovides instructions for selecting, translating, and moving column data. Do not use thisoption for tables being processed in pass-through mode by a data-pump Extract group.NOTE To create global rules for column mapping across all tables in subsequent TABLEstatements,

Valid for ExtractUse the COMPRESSUPDATES and NOCOMPRESSUPDATES parameters for Extract to control the waycolumns are written to the trail record for update operations.COMPRESSUPDATES, the default, causes Extract to write only the primary key and thechanged columns of a row to the trail for update operations. This provides enoughinformation to update the correct target record, while restricting the amount of data thatmust be processed.NOCOMPRESSUPDATES sends all of the columns to the trail. This b

关于goldengate无主键表的update的同步源端：windows 2003 sql2005 sp3目的端:rhel5.3 x64bit, db2 v9.7 x64bit源端表结构：（无主键无唯一索引）CREATE TABLE [lc0019999].[KCCKD2]( [KCCKD2_PJLX] [char](1) NOT NULL, [KCCKD2_LSBH] [varchar](10) NOT NULL, [KCCKD2_FLBH] [varchar](10) NOT NULL, [KCCKD2_WLBH] [varchar](30) NOT NULL, [KCCKD2_TSKC] [char](1) NOT NULL DEFAULT (' '), [KCCKD2_XGDX] [varchar](30) NOT NULL DEFAULT (' '), [KCCKD2_DDLS] [varchar](20) NULL DEFAULT (' '), [KCCKD2_

************************************************************************* Running with the following parameters *************************************************************************replicat msstargetdb BASE4, userid gg, password ******discardfile /db2/ggv11db2/dirrpt/rep.dsc, append, MEGABYTES 2147SOURCEDEFS /db2/ggv11db2/dirdef/source_defs.defreperror ( 100, IGNORE )--注意：（后有一个空格，）前也有一个空格。Source Context : SourceModule : [er.main]

1.在目的数据库的相关表中，添加字段。注意字段的数据类型。2. rep.prm中进行如下的添加map 'lc0019999.KCCKD2', target gguser.KCCKD2, COLMAP (USEDEFAULTS, ETL_FL_NM = "gg_online", BUSI_DATE = @COLSTAT (NULL), PPN_TMSTAMP = @COLSTAT (NULL), OPERATION_TYPE = @GETENV ("GGHEADER", "OPTYPE") , MODIFY_DATETIME = @GETENV ("GGHEADER", "COMMITTIMESTAMP"));值得注意的是：OPERATION_TYPE = @GETENV ("GGHEADER", "OPTYPE") 这一个列，在数据库表中，请

add trandata报错的前提条件：1.oracle 92 数据库2.源端的表没有主键，没有唯一键。3.源端的表的列数超过32个列。如下的例子：GGSCI (rhel41) 2> add trandata GYHT.GY_CLHTK2011-04-26 21:20:20 WARNING OGG-00869 No unique key is defined for table GY_CLHTK. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.2011-04-26 21:20:20 WARNING OGG-00706 Failed to add supplemental log group on table GYHT.GY_CLHTK due to ORA-02257: maxim

How to use NOALLOWNOOPUPDATES/ALLOWNOOPUPDATES Replicat parameter [ID 1144303.1] 修改时间 27-JUL-2010 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution Applies to: Oracle GoldenGate - Version: 10.0.0.0 and later [Release: 10.0.0 and later ]Information in this document applies to any platform. Goal Describes the usage of NOALLOWNOOPUPDATES/ALLOWNOOPUPDATES parameter Solution 1.Use ALLOWNOOPUPDATE

环境介绍： 源头：rhel5 32bit，oracle10.2.0.4 32bit ，goldengate v11.1.1 for oracle 10g 32bit 目的地：rhel5 32bit，oracle10.2.0.4 32bit ，goldengate v11.1.1 for oracle 10g 32bit 源头的goldengate 配置没有问题，info all 命令都是running 目的地的goldengate 配置看似没有问题，虽然info all 命令都是running 从源头做了几个dml操作后，查看源头extract进程和datapump进程的统计信息： stats extract ext 和 stats extract datapump，都反馈如下的结果 *** Daily statistics since 2011-04-15 21:12:07 ***