ITPub博客

GoldenGate 不支持从oracle 11g的 active dataguard 目的端进行extractDoes GoldenGate Support Extract Reading Redo from Active Data Guard? [ID 1299805.1]SolutionNo. This is not supported in current version (v11). Extract must read the redo/archived logs from the primary database.[@more@]

Applies to: Oracle GoldenGate - Version: 5.0.0 and later [Release: 5.0.0 and later ]Information in this document applies to any platform. Goal To handle / replicate tables with no (without) primary key (PK) or unique index (UI) or UPI Solution By default, all the columns (except LOB, XML, UDT et al) will be used as the key. Supplemental logging of the table is required.For batch updates and deletes, one update/delete statement in source will becomes multiple ones in target. i

以下均是在ggsci提示符下执行,以下以extract抽取进程为例子1. send extract ext_name, status 2. info extract ext_name3. info extract ext_name, showch4. info extract ext_name, detail5. lag extract ext_name6. stats extract ext_name7. stats extract ext_name, table lc0019999.zwkmzd[@more@]

replicat screpsetenv ( NLS_LANG = " SIMPLIFIED CHINESE_CHINA.ZHS16GBK " )assumetargetdefsDBOPTIONS DEFERREFCONSTgettruncatesapplynoopupdatesuserid goldengate, password oracleddl include objname "scott.*" &INCLUDE OBJTYPE 'USER'ddlerror 600, ignorediscardfile ./dirrpt/scrini.dsc, append, megabytes 500map scott.*, target scott2.*;[@more@]

2011-09-14 09:25:06 WARNING OGG-00869 No unique key is defined for table BONUS. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.Using following columns in default map by name: ENAME, JOB, SAL, COMMUsing the following key columns for target table SCOTT2.BONUS: ENAME, JOB, SAL, COMM.[@more@]

以下语句（scott.bonus表无主键无唯一索引）若是在gg源端发出，会导致gg目的端abend(除非目的端复制进程参数文件有APPLYNOOPUPDATES 或者ALLOWNOOPUPDATES 参数) update scott.bonus set ename='lei2' where ename='lei2'; gg目的端abend时，dirrpt下的rpt文件报错如下：2011-09-14 09:35:23 ERROR OGG-01168 Encountered an update for target table SCOTT2.BONUS, which has no unique key defined. KEYCOLS can be used to define a key. Use ALLOWNOOPUPDATES to process the update without applying it to the target data

What Are The Considerations In Using "Batchsql"? [ID 1060546.1] 修改时间 04-APR-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 Issue: BatchSQL Implemantation and Limitations: Solution Overview: BATCHSQL is a Replicat parameter implementi

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 Oracle 10g introduced new flashback ability at several levels: database, dropped table, and committed transaction.Goldengate supports the flashback of committed transactions, but does not support flashback at the database or dropped table levels.Supportedflashback table ... to SCN ... flashback table ... to TIMESTAMP ...flashback tabl

Excessive REPLICAT LAG Times [ID 962592.1] 修改时间 01-MAR-2011 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution Applies to: Oracle GoldenGate - Version: 10.4.0.20 and later [Release: 10.4.0 and later ]Information in this document applies to any platform. Symptoms REPLICAT lag times often exceed 30 minutes; is there a way to improve REPLICAT performance/throughput? Cause CauseIn

goldengate rep进程abend 遇到 discard file (./dirrpt/rini.dsc) exceeded max bytes (705032704)rep进程的参数文件是这样写的：discardfile ./dirrpt/rini.dsc, append, megabytes 5000解决方法：在dirrpt目录下执行：mv rini.dsc rini.dscbak问题分析：discard file是辅助你定位问题的文件，说白了，作用类似于oracle数据库的alert日志文件。可以重命名。[@more@]

1.一定要从metalink上开个sr，索要相应操作系统下的相应数据库的最新的goldengate软件。别用老的goldengate软件。老的goldengate软件存在很多bug（比如，goldengate v11.1.1.0.1软件对oracle进行ddl复制时，对 oracle 的rename这个ddl操作，会忽略掉，这是个很严重的bug，此bug有metalink文章Goldengate Replicat Ignores "Alter Table Rename" DDL [ID 1216846.1]）2.goldengate v11.1.1.0.29 for hpux 11.31 oracle 10.2.0.4 rac 的目的端（只有1个replicat进程） 应用速度记录：1分钟大概会应用43M的trail文件（每个trail文件

一对双引号引发的goldengate血案：源是sql2005 ，目的是linux x64 下的db2 v9.7因为是测试环境，所以只同步了一个sql2005的表（注意，此时我并没有意识到sql2005是区分大小写的）源端和目的端配置完毕后，分别启动两端的mgr进程，状态是running。ok！extract 进程的状态是runningdatpump 进程的状态是runningreplicat进程的状态是runningok!在源端插入一条记录（此表已经被配置extract）,马上就看到了源端trail文件的修改时间变了。马上就看到了目的端trail文件的修改时间也变了。然后replicat进程的状态是running然后去目的库查看此条记录

CREATE TABLE U_DS.TB_SMS_SENDSTATUS ( SMSSENDSTATUSID NUMBER NOT NULL, MSGID NUMBER(19) NULL, CHANNELID NUMBER NULL, MISDNTYPE NUMBER NULL, PRIORITY NUMBER NULL, SOURCETYPE NUMBER NULL, CUSTOMERID NUMBER NULL, ORGANID VARCHAR2(20) NULL, USERID NUMBER NULL, SENDADDRESS VARCHAR2(20) NULL, MOBILE VARCHAR2(20)

AIX: 'GGS ERROR 190 ... : Received Signal: OMVS Shutdown (33).' [ID 969596.1]Applies to: Oracle GoldenGate - Version: 4.0.0 - Release: 4.0.0Information in this document applies to any platform. Solution Issue: GoldenGate process on AIX stops with the following message: GGS ERROR 190 GoldenGate Collector: Received signal: OMVS Shutdown (33). Solution Overview: This message means that AIX had a system-wide paging problem, which it reported to the GoldenGate component, in this case the

implementing replication of cyclic sequences in GoldenGate [ID 1321558.1]Purpose OGG has added support for replication of cyclic sequences in the 11.1.1.1.x builds. Backport: Any code prior to v11.1.1.x must contain patch 9428942 to reliably replicate cyclic sequences. Documentation for versions 10.0, 10.4 and 11.1 states that extract supports sequences. In fact, sequences were not intended to be supported @ were never tested – hide, customer does not need to know this

Oracle GoldenGate and compressed tables [ID 1266389.1] 修改时间 17-JUN-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution References Applies to: Oracle GoldenGate - Version: 11.1.1.0.0 and later [Release: 11.1.1 and later ]Information in this document applies to any platform. Goal Oracle GoldenGate and compressed tables Solution OGG does not support compressed tables or partitions, neith

How To Setup GoldenGate To Maintain A Heartbeat With The Database [ID 965415.1] 修改时间 31-MAY-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 PROBLEM Some user accounts in the database are setup with session timeo

Oracle GoldenGate - Heartbeat process to monitor lag and performance in GoldenGate [ID 1299679.1] 修改时间 24-MAY-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution Applies to: Oracle GoldenGate - Version: 10.4.0.0 and later [Release: 10.4.0 and later ]Oracle GoldenGate - Version: 10.4.0.0 and later [Release: 10.4.0 and later]Information in this document applies to any platform. Affected Datab

Impact Of U.S. Daylight Saving Time (DST) Change On GoldenGate [ID 970384.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 Q: Will the Daylight Saving Time (**) change impact my GoldenGate environment? Do I have to stop the Golde

Considerations For Choosing To Use A Datapump [ID 966106.1] 修改时间 24-MAY-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 Issue:Choosing Whether to Use Datapumps or NotSolution Summary:GoldenGate offers two types (among others) of Extracts to m