GoldenGate change data capture and replication of BLOB and CLOB data

Posted by Gavin Soorma
On May 22, 2014
0 Comments
BLOB, Change Data Capture, CLOB, data column, document, GoldenGate, image, replication

We will look at an example of GoldenGate replication of a table having a BLOB column and how an INSERT and UPDATE statement on the table with BLOB data is handled by GoldenGate. We create an APEX 4.2 application to illustrate this example where we create a form and report You need to be logged […]

Posted by Gavin Soorma
On April 1, 2014
0 Comments
BCP, BULK INSERT, extract, GoldenGate, Initial Load Methods, Oracle, sourceistable, SQL server 2012

In this post we will look at three different methods of performing an initial data load from an Oracle 11g source database running on an HP-UX IA64 platform to a SQL Server 2012 target database hosted on Windows 2012 Datacenter. The three methods we are using here are: 1) Oracle You need to be logged […]

Posted by Gavin Soorma
On March 11, 2014
0 Comments
ACTIVE STANDBY, ALO, ARCHIVEDLOGONLY, data guard, GoldenGate, SQL server 2012, tranlogoptions

This note describes how to run an Initial Load along with Change Data Capture from a source Oracle 11g R2 Active Standby database (ALO Archived Log Only mode capture) to a MS SQL Server 2012 target database. The table is a 6.3 million row table – AC_AMOUNT in the IDIT_PRD You need to be logged […]

Posted by Gavin Soorma
On February 26, 2014
0 Comments

This note describes the process of configuring a initial data load job as well as Change Data Capture from an Oracle 12c pluggable database source and a MS SQL Server 2012 target database. Download the note here …. You need to be logged in to see this part of the content. Please Login to access.

Posted by Gavin Soorma
On January 24, 2014
2 Comments
12c, coordinated, GoldenGate, integrated, new feature, performance, RANGE, replicat, thread

In one of the the earlier posts we had discussed the GoldenGate 12c Integrated Apply or Integrated Replicat feature. It enables high volume transactions to be applied in parallel. But it was only supported for Oracle databases and also required to be version 11.2.0.4 and higher. The Coordinated Replicat feature You need to be logged […]

Posted by Gavin Soorma
On January 21, 2014
0 Comments

One of the new features in Goldengate 12c is the Integrated Replicated or Integrated Apply feature. Note that Integrated Extract was introduced in GoldenGate 11g to go along with what is now termed as Classic Extract. Keep in mind that to use Integrated Replicat the target database needs to be You need to be logged […]

GoldenGate 12c New Feature – Credential Store and USERIDALIAS

Posted by Gavin Soorma
On January 15, 2014
0 Comments

The ADD CREDENTIALSTORE is a new command in Oracle GoldenGate 12c. The credential store eliminates the need to specify user names and clear-text passwords in the Oracle GoldenGate parameter files. It is implemented as an autologin wallet within the Oracle Credential Store Framework (CSF). We can use the USERIDALIAS in You need to be logged […]

Posted by Gavin Soorma
On January 15, 2014
1 Comments

This note illustrates an example of using GoldenGate 12c with Oracle 12c Multitenant Container databases. While in most ways, Oracle GoldenGate operates in a multitenant container database the same way that it operates in a regular Oracle database, we will examine some of the main differences when it comes to You need to be logged […]

GoldenGate Active-Active Replication with Conflict Detection and Resolution (CDR) – Part 4

Posted by Gavin Soorma
On April 16, 2013
0 Comments
active-active, bi-directional, cdr, comparecols, conflict resolution, resolveconflict

In the earlier post on GoldenGate Conflict Detection and Resolution, we had looked at an example where a conflict caused by an update happening at the same time for the same record from two different sites was handled using the RESOLVECONFLICT with the UPDATEROWEXISTS clause. Let us look at some You need to be logged […]

Posted by Gavin Soorma
On April 15, 2013
0 Comments
cdr, conflict resolution, GoldenGate, resolveconflict, usemin

In the earlier post we saw a case of GoldenGate Conflict Resolution using the Trusted Site Or Trusted Source method where one site is dedicated as the trusted or master site and in a CDR scenario will always prevail over other sites participating in the Active-Active Replication. We saw how You need to be logged […]

Posted by Gavin Soorma
On April 12, 2013
0 Comments
active-active, cdr, comparecols, conflict detection, resolveconflict

In the earlier post we looked at setting up a simple Active-Active GoldenGate configuration. Let us build on that by adding in some Conflict Detection and Resolution (CDR) mechanisms and look at some scenarios where conflicts do occur when a particular record in the table involved in active-active replication is You need to be logged […]

Posted by Gavin Soorma
On April 12, 2013
0 Comments
active-active, cdr, conflict resolution, getbeforecols, GoldenGate

Let us look at a simple example to illustrate GoldenGate’s Active-Active Replication with an introduction to Conflict Detection and Resolution. Let’s call the two sites we are going to use for Active-Active replication as Site A and Site B. On Site A we will have the following groups created • You need to be logged […]

Posted by Gavin Soorma
On April 10, 2013
0 Comments
GoldenGate, jagent, oem12c, plug-in

This note describes the procedure of implementing the GoldenGate plug-in for Oracle Cloud Control 12c. After deploying the GoldenGate Plug-in we can see a new Target Type “GoldenGate” appearing in the OEM 12c Targets menu and can now monitor the status and progress of the Extract, Manager and Replicat processes You need to be logged […]

Posted by Gavin Soorma
On February 11, 2013
0 Comments
classic capture, integrated capture, upgrade

In one of my earlier posts, we discussed how to setup and use Integrated Capture mode as well as how to use the Downstream Mining Database option of the integrated capture mode. Let us now see how to upgrade the classic capture to an integrated capture. To recap, the main You need to be logged […]

Posted by Gavin Soorma
On February 1, 2013
0 Comments
capture, downstream, extract, GoldenGate, logminer

In my earlier post, we had discussed the GoldenGate 11g Integrated Capture feature using the local deployment model. Let us now look at the Downstream Capture deployment model of the Integrated Capture mode. It should be noted that the main difference in the Integrated Capture mode and the Classic Capture You need to be logged […]

Posted by Gavin Soorma
On January 30, 2013
4 Comments
11G, extract, GoldenGate, integrated capture

One of the new features in GoldenGate 11g is the Integrated Capture mode. In the earlier classic capture mode, the Oracle GoldenGate Extract process captures data changes from the Oracle redo or archive log files on the source system. In integrated capture mode, the Oracle GoldenGate Extract process interacts directly You need to be logged […]

Oracle GoldenGate 11gR2 high availability with Oracle 11gR2 Clusterware

Posted by Gavin Soorma
On December 3, 2012
0 Comments
ASM, Clusterware, High Availability, Oracle GoldenGate, RAC, VIP

This note discusses how to achieve high availability in an Oracle 11g GoldenGate environment using Oracle 11gR2 Grid Infrastructure Clusterware services. The GoldenGate manager process has some configuration parameters which we can set to prevent outages like AUTOSTART and AUTORESTART which will ensure that GoldenGate Extract and Replicat processes will You need to be logged […]

Posted by Gavin Soorma
On July 20, 2012
0 Comments
GoldenGate, IGNOREDELETES, IGNOREUPDATES, LOGDUMP, trail file

Some time back I was asked the question as to how do we use GoldenGate in a situation where on the target database we only want to capture records inserted in the source database and ignore any updates being made to existing rows in the source database. For this we You need to be logged […]

Posted by Gavin Soorma
On June 26, 2012
0 Comments
11.2, GoldenGate, upgrade

In one of my earlier posts I had described how to handle GoldenGate version differences between the source and target environments. In that case my source was version 11.2 and the target was version 11.1. We had to use the FORMAT RELEASE parameter to handle such a version difference. You need to be logged […]

Posted by Gavin Soorma
On June 20, 2012
0 Comments
exttrail, format release. goldengate, rmttrail, trail file, version

Recently I encountered this error while doing a GoldenGate replication from an Oracle 11g R2 source database to an Oracle 10g R2 target database. ERROR OGG-01389 File header failed to parse tokens. File /u01/app/goldengate/dirdat/gv000000, last offset 915, data: 0x Reading the GoldenGate documentation I came across this section which read: You need to be logged […]

Page 2 of 4123 4

soujanya on Oracle 11g Advanced CompressionThanks for sharing info on Learn Oracle 11g, Advanced Compression
The Oracle DBA Girl on Oracle Database 12c Release 2 New Feature – Create Data Guard Standby Database Using DBCAOh wow...I didn't know Oracle had this feature, I'm about to load up Virtual Box now and test this out.
Thomas on RMAN Backup and Recovery scenarios involving loss of SPFILEGreat post! Have nice day ! :) ubhoi
Victor Kisovi on Oracle 11g Grid Control Agent DeploymentThanks Garvin. This is helpful.
shravan on DBA Monitoring MenuHi Gavin, One single script..will reduce much work of DBA's. Thanks for the script. really appreciated.
Subrahmanya Sarma Neralla on Speaker at OTN Yathra 2017Thank you Gavin Soorma for very nice presentation. I have attended your session @Hyderabad and it was very good.
skmanoharan10097859600 on Using GoldenGate 12c with an Oracle 12c Multitenant databaseHi Gavin Thanks a lot for your nice article. As Oracle 12C is more focused on Database consolidation I am
Chandra on DBA Monitoring MenuExcellent Work...can be easily deployed to make it work in our environment.
Gavin Soorma on Oracle 12c Release 2 (12.2.0.1.0) Grid Infrastructure UpgradeHi - it is mentioned in the MOS note "Patches to apply before upgrading Oracle GI and DB to 12.2.0.1
brian choy on RMAN 11g new feature – Backup Fast Recovery Area (FRA) to DiskExcellent feature that make our data more robust, I have yet to test it out

News

GoldenGate change data capture and replication of BLOB and CLOB data

GoldenGate Initial Load Methods Oracle source to SQL Server 2012 target

GoldenGate real-time replication from Active Standby Database to SQL Server 2012 target

Goldengate 12c – Configuring CDC between an Oracle 12c Multitenant Container Database and SQL Server 2012

12c GoldenGate New Feature – Coordinated Replicat

GoldenGate 12c New Feature – Integrated Replicat

GoldenGate 12c New Feature – Credential Store and USERIDALIAS

Using GoldenGate 12c with an Oracle 12c Multitenant database

GoldenGate Active-Active Replication with Conflict Detection and Resolution (CDR) – Part 4

GoldenGate Active-Active Replication with Conflict Detection and Resolution (CDR) – Part 3

GoldenGate Active-Active Replication with Conflict Detection and Resolution (CDR) – Part 2

GoldenGate Active-Active Replication with Conflict Detection and Resolution (CDR) – Part 1

Deploying the Oracle GoldenGate Plug-in on OEM 12c Cloud Control

Upgrading Classic Capture mode to Integrated Capture

GoldenGate Integrated Capture using downstream mining database

GoldenGate Integrated Capture Mode

Oracle GoldenGate 11gR2 high availability with Oracle 11gR2 Clusterware

GoldenGate IGNOREDELETES, IGNOREUPDATES and using the LOGDUMP utility

Performing a GoldenGate Upgrade to version 11.2

Using the FORMAT RELEASE parameter to handle GoldenGate Version Differences