时间过的真快，2011马上就要结束了。回顾这一年来自己到底干了哪些有意义的事情呢？

   今年自己过的很匆忙，一个项目接着一个项目，到年底了还有一个项目还在继续忙活着。现在回顾一下今年自己做过的项目：

    1、国家电网DDL复制试点单位数据同步测试和全国GoldenGate实施技术支持；

    2、中国人民银行征信中心二期改版项目GoldenGate数据同步实施；

    3、中国外运公司海运业务系统和网上服务业务系统后台数据库在线迁移。

   今年做了几个项目虽然挺辛苦，但是也有收获：

    1、对GoldenGate的DDL复制有了进一步的了解；

    2、实现了基于GoldenGate的检查点清除归档日志的脚本；

    3、为人行项目编写了通过统计分析分析GoldenGate复制能力的脚本；

    4、完成了OCP考试的三门课程，就剩下培训了，呵呵；

    5、通过了GoldenGate、OWB、Exadata、RAC认证考试。

 &n

In this Document
  Goal
  Solution

Applies to:

Goal

In this Document
  Purpose
  Questions and Answers
     Oracle GoldenGate before 11.1 or Target Oracle Database Before 9.2.0.7
     Oracle GoldenGate 11.1 and up and Target Oracle Database

    最近一直在做项目，忙的没有时间整理资料了，告诉大家一个好消息，oracle的goldengate 11G，现在已经可以下载了，大家赶快去测试吧。我今天把它的一些新特性，整理了一下，分享给大家。

  1、新数据库库的支持

   DB2 for iSeries: Oracle GoldenGate supports the delivery of data changes from any
database that is supported as a source by Oracle GoldenGate to a DB2 iSeries target using
ODBC from an intermediate Windows system.

   SQL Server 2008: Oracle GoldenGate now supports extraction from and replication to
SQL Server 2008.

   MySQL Capture: Oracle GoldenGate now supports log based capture from MySQL
5.1.15 or higher.

  2、Database-specific enhancements
DB2 z/OS
Oracle GoldenGate now supports delivery to a DB2 z/OS target by using a remote
Replicat that is installed on any platform that can host a DB2 LUW instance and is
supported by Oracl

Purpose

Solution

Note: This KM doc applies to pre 10.0 versions of Oracle GoldenGate.

Issue:
When doing an initial load from an Oracle source to an Oracle target, you would normally use HANDLECOLLISIONS in the Replicat parameter file to process the overlapping records that result from ongoing replication during the load.

Solution Overview:

There are some drawbacks with HANDLECOLLISIONS:

Solution Details:
1. When there is primary key update (PKUpdate), the HANDLECOLLISIONS method may lose data. The solution in the case of a primary key update is for Extract to fetch whole row by making a flashback query. However, this is not efficient and may not be possible in certain environments.

2. When a table does not have any type of key, HANDLECOLLISIONS may introduce duplicate rows in the table. One workaround is to add a primary or unique key to the target table.

3. The exact timestamp when the

Symptoms

Cause

Solution

Download the correct “Microsoft Visual C++ 2005 SP1 Redistributable Package (x64)” from the following link:

http://www.microsoft.com/downloads/en/confirmation.aspx?familyId=eb4ebe2d-33c0-4a47-9dd4-b9a6d7bd44da&displayLang=en

Run the downloaded script on the server and the 64bit Veridata server should run correctly.

Symptoms

Cause

Solution