Is Oracle GoldenGate really designed for batch processing or “large” transactions? – not sure what the official Oracle take on this is but I would hazard a guess and say maybe no. Maybe that is something better suited to an ETL type of product like Oracle Data Integrator. Goldengate considers a transaction to be large […]
Oracle Goldengate 12.2 now provides support for replication of tables with INVISIBLE columns which was not possible in earlier releases. Let us look at an example. We create a table on both the source as well as target databases with both an INVISIBLE and VIRTUAL column COMMISSION. SQL> create table system.test_ogg 2 (empid number, salary […]
One of the top new features introduced in Oracle GoldenGate 12.2 is the Self-describing trail files feature. What this means is that no more do we have to worry about differences in table structures in the source and target databases and no more do we have to use the defgen utility or even the parameters […]
At the recent Oracle Open World 2015 conference I was fortunate to attend a series of very informative presentations on Oracle GoldenGate from senior members of the Product Development team. Among them was the presentation titled GoldenGate 12.2 New Features Deep Dive which is now available for download via the official OOW15 website. While no […]
Let us take a look at the process of configuring Goldengate 12c to work in an Oracle 12c Grid Infrastructure RAC or Exadata environment using DBFS on Linux x86-64. Simply put the Oracle Database File System (DBFS) is a standard file system interface on top of files and directories that are stored in database tables […]
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: […]
The GoldenGate Director (Server and Client) is part of the Oracle GoldenGate Management pack suite of products. Let us see how security is managed in the Director. We launch the Director Administration tool on Unix via the run-admin.sh shell script. If we are using Oracle WebLogic Server 12c and above the default admin user is […]
The Oracle online redo log files contain both committed as well as uncommitted transactions, but Oracle GoldenGate only writes committed transactions to the trail files. So the question which can be asked is what happens to the transactions which are not committed or especially what happens to those uncommitted long running transactions. Sometimes long running […]
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 […]
After a recent Oracle GoldenGate installation at a client site running on Solaris 11, we observed memory related errors in the GoldenGate error log like the ones mentioned below as well as extract processes were abending on start up. ERROR OGG-01841 CACHESIZE TOO SMALL: ERROR OGG-01843 default maximum buffer size (2097152) > absolute maximum buffer […]
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 based on the DOCUMENTS table […]
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 […]
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 schema. Steps Create the Initial […]
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 …. Please follow and like us:
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 is new in GoldenGate 12c […]
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 version 11.2.0.4 or later and […]
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 an extract or replicat parameter […]
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 configuring extract and replicat processes […]
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 more CDR examples involving DELETE […]
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 an UPDATE statement conflict was […]
