GoldenGate Software Guides – The Index

GoldenGate 12c: New Features
With the release of Oracle GoldenGate 12c, management of the Replication environment has been eased further. In addition to this, it provides support for Oracle 12c multitenant database, a more secure authentication mechanism and much better performance. Most of these features require the database to be 11.2.0.4 or above.

GoldenGate 12c Software Installation

GoldenGate 12c: OUI installation
]A number of new features have been introduced with the release of Oracle GoldenGate 12c. Using the Oracle Universal Installer(OUI) to install the binaries, is one of them. Previously this was performed using the untar/unzip utility to extract the files into the home directory. This feature appears in line with the effort by Oracle to standardized the look and feel of their products and to make installation easier in the different database environments.

GoldenGate 12c: Silent Install
Starting with GoldenGate 12c, Oracle has moved the installation mechanism into the familiar Oracle Universal Installer, GUI framework. It’s a good move not only in terms of ease of use but also for the uniformity of the install process across all Oracle products.

Deinstalling GoldenGate 12c
In GoldenGate 12c, the installation and the de-installation process has been standardized to use the Oracle Universal Installer (OUI) interface. In this article we will look at how can we deinstall Oracle GoldenGate.

Goldengate: Concepts and Architecture
Oracle Goldengate supports the replication of data across various heterogeneous platforms. The Goldengate replication topology includes the capture and transfer of the extracted data from the source database, across to the destination database. Below are the topologies which can be used to fulfill various data transfer requirements using data replication.

GoldenGate: Best Practices
For replication to be robust, well tuned and secure, some out of the box settings need to modified. Here is a list of these items, focusing on the Goldengate Best Practices and Security, in areas such as the Database, Parameters, processes, etc. Read more here.

GoldenGate: How is Data Guard different?
When the economy is still faltering and unpredictable, what more could you wish for than to have a Gate made of Gold. Though Oracle GoldenGate may not be the physical Gold but the ease with which it solves the peer to peer replication problems, it’s flexibility, robustness, speed and scalability – it’s certainly worth its weight in Gold. It is an integral part of Oracle’s Maximum Availability Architecture which together with several other products allows your data center to function with zero downtime and high availability.

50 Goldengate Interview Questions
Want to quickly brush up on Golden Gate Replication for that Interview. Most questions here are solutions to the real world issue which a GoldenGate Admin has to address. Read more about there ..

Replication Pre-requisites

GoldenGate Replication Pre-requisites
Certain prerequisites should be met to prepare an environment for the Goldengate installation. The steps here are applicable to both Linux and Windows environments and must be satisfied on both source and target servers.

Source

GoldenGate Manager
Learn how to set up, tune & troubleshoot Goldengate Replication. Read more on topics in Goldengate.

GoldenGate Integrated Extract 12c/11g
The Integrated Capture GoldenGate Mode in Goldengate 11gr2 is one of the more interesting and useful feature released with this version. This capture process is the component responsible for extracting the DML transactional data and DDL’s from the source database redo log files. This data is then written to local trail files which eventually is move to the destination database to be applied there.

GoldenGate Classical Extract
Read simple steps on setting up, tuning & troubleshooting Goldengate Replication.

GoldenGate Pump
Find out how easy it is to setup GoldenGate pump process to send the extracted data to the destination.

Target

GoldenGate Replicat
The Oracle Goldengate Replicat process also known as the apply process, is a mandatory process in the Goldengate setup. This data delivery process is the last component to be setup on the the target database. It reads the data from a file known an EXTTRAIL file which contains data changes made on the source. In addition to applying the data on the target, the Goldengate replicat also posts its exact location of the trail file while processing records. This is used for recovery from crashes, allowing it to start from the exact point where it left off, without any data loss.

One-way Replication

Uni-directional Replication Summary
Replication between two databases requires the setting up of the Manager, Extract and Pump processes on the source database and setting up the Manager and Replicat processes on the target database. Prior to adding and starting these processes ensure that the Goldengate binaries have been installed and other

Advanced Replication

Configure GoldenGate DDL Replication
Goldengate supports the replication of DDL commands, operating at a schema level, from one database to another. By default the DDL replication is disabled on the source database (extract side) but is enabled on the target Database (replicat side). The commands below are used to activate the DDL replication. Read more ..

Configure GoldenGate Data Transformation
Oracle GoldenGate Replication supports data transformation of data as it is read from the trail file and before it is put inside the database. This data mapping and manipulation is enabled by using the MAPPING parameter options. Read more …

GoldenGate Not Keeping Up? Split the Process Using GoldenGate Range Function

In most of the environments, one set of OGG processes (1 Extract & 1 Replicat process) is sufficient for change data synchronization. But if your source database generates a huge volume of data then a single process may not be sufficient to handle the data volume. Read more …

Upgrade

Upgrade Classic Extract to Integrated Capture
The Integrated Capture Mode provides enhanced integration with new Oracle Features and improvement in usage of the resources and performance enhancement. Below are the steps required to upgrade a new or an existing GoldenGate Classical Extract process. Read more …

Oracle GoldenGate 11gr2 Upgrade
This article demonstrates the steps to perform an in-place Oracle GoldenGate 11gr2 Upgrade (11.2.0.2). Read more …

Goldengate upgrade to 11.1.1.2
What are the steps required to upgrade GoldenGate? Read about a real life upgrade and the steps required. Read more …

GGSCI

GoldenGate: GGSCI Commands I
Oracle GoldenGate GGSCI commands to manage the mgr, extract, pump and replicat processes. Read more ..

GoldenGate: GGSCI Commands II
More GGSCI commands. Read more ..

GoldenGate: GGSCI Commands III
Here is a collection of individual GGSCI command references. Read more ..

LogDump

Goldengate 12c: Troubleshoot Using LogDump
Oracle GoldenGate Software includes the Logdump utility for viewing data directly from the trail files. Without the Logdump, it is not possible to read the content of the Oracle GoldenGate trail files, as the trail files are in a binary format. Read more ..

GoldenGate: Skipping Transactions
Suppose we perform some DDL or DML transaction on our source database, for example altering an existing table or inserting records into the table but the table does not exist on the target side. This will cause the Replicat process on the destination side to abend. Read more ..

GoldenGate: Finding Open Database Transactions
Oracle Golden Gate Replication will not propagate transactions to the destination which have NOT been committed on the source yet. However Oracle Golden gate will write the open transaction data to the dirtemp directory in the home directory. Read more ..

GoldenGate: How to use handle Collisions correctly?
The Goldengate HANDLECOLLISIONS parameter is configured on the Replicat side to continue processing of the data when there are data integrity issues on the destination side and is okay to do so. It is utilized when there is a possibility of an overlap of the trail data being applied by the replicat process (replicat) where the data already exists in the destination tables. Otherwise without this parameter, the REPLICAT will abend when it tries to process the inserts from the trail into the table which already has the rows (PK or unique constraint violation). Read more ..

If you are trying to setup a test environment to replicate data using GoldenGate on Unix, Linux, Solaris or other OS environments, you can quickly have the host and the database ready for use in as short a time as 10 minutes. Unbelievable?

Just install the VirtualBox and download the Pre-Built templates and import them to create a VM VirtualBox machine. The OS is already installed, the database configured and it starts up as soon as the Virtual Machine is bought to life.

No hassles with the pre-requisites or fulfilling other requirements. Just follow the simple steps below. Then unzip the GoldenGate binaries and add the processes as you normally do. Have a portable environment which you can have running on your Laptop!

Provision VirtualBox using Pre-Built Developer VMs
Step by step guide to setup the Oracle VM VirtualBox and import the prebuilt template to quickly create a portable (on your laptop) testing environment in 10 minutes!

Adding Disk Storage to Oracle VirtualBox
Need more space on your VirtualBox? Follow the instructions and use the drive space on your host machine to share space with the VM Virtual Box

Connecting Applications from Desktop to your VirtualBox Database
If you are trying to connect between VirtualBox Machines or trying to setup the network to communicate from the Desktop to the VirtualBox machines, follow the simple to use instructions here


Complete list of 12c GoldenGate Articles including information on GoldenGate Software 12c new features, basic configuration, advanced configuration, upgrade, etc…

Complete list of GoldenGate Articles.

How GoldenGate Works?

Monitoring GoldenGate – By Oracle

Some historical information on Goldengate before being bought by Oracle Corporation.

Author’s Oracle GoldenGate Software Blog pick: Upgrade Classic Extract to Integrated Capture.