In earlier versions when we had to do an Oracle database table instantiation or initial load, we had to perform a number of steps – basically to handle DML changes which were occurring on the source table while the export was in progress. So we had to first ensure that there were no open or […]
Let us look at an example of using Oracle Golden Gate to achieve a near zero (not zero!) downtime for performing an upgrade from Oracle 9i (9.2.0.5) to Oracle 11g (11.2.0.4) as well as a platform migration from Solaris SPARC to Linux X86-64. With no downtime for the application we have performed the following tasks: […]
At one of my recent client sites, there was a requirement to enable GoldenGate Change Data Capture for a schema with over 800 tables and also application tables were frequently added which also required to have CDC enabled without the need to stop and restart the extract because we had made a change to the […]
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 GoldenGate Direct Load over network […]
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 mode is that the Extract […]
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 with the database log mining […]
Recently a question was posed to me as to how do we handle changes that are happening to the data while the initial data load extract process is in operation. Sometimes it may not be possible to have an application outage just to peform an initial data load and in most cases we will need […]
I would like to share a simple test case which explains how we can use GoldenGate to replicate data between a Microsoft SQL Server 2005 source and an Oracle 11g target database on a Red Hat Linux platform. We can use a number of third party tools as well as Oracle’s SQL Developer to generate […]
In addition to providing replication support for all DML statements, we can also configure the GoldenGate environment to provide DDL support as well. A number of prerequisite setup tasks need to be performed which we willl highlight here. Run the following scripts from the directory where the GoldenGate software was installed. The assumption here is […]
The Data Pump (not to be confused with the Oracle Export Import Data Pump) is an optional secondary Extract group that is created on the source system. When Data Pump is not used, the Extract process writes to a remote trail that is located on the target system using TCP/IP. When Data Pump is configured, […]
This example illustrates using the GoldenGate direct load method to extract records from an Oracle 11g database on Red Hat Linux platform and load the same into an Oracle 11g target database on an AIX platform. The table PRODUCTS in the SH schema on the source has 72 rows and on the target database the […]
The Oracle GoldenGate Manager performs a number of functions like starting the other GoldenGate processes, trail log file management and reporting. The Manager process needs to be configured on both the source as well as target systems and configuration is carried out via a parameter file just as in the case of the other GoldenGate […]
