Oracle GoldenGate: Testing the Extract’s maximum read performance in extreme environments

MOS Doc ID 2193584.1 Version 1.2 10/14/16 If you have a requirement to be able to process over a Terabyte of redo per hour you may want to first run a simple test to figure out if your system is capable of reading that much data before you spend a large amount of time trying […]

Oracle GoldenGate database Schema Profile check script for Oracle Database

Introduction This script is intended to query the database by schema to identify current configuration and identify any unsupported data types or types that may need special considerations for Oracle GoldenGate in an Oracle environment   Main Article The complete script can found on the Oracle Support site as document ID:1296168.1     All content […]

Oracle GoldenGate Database Profile check script for MySQL Database

Introduction This script is intended to query a MySQL database to identify current configuration and identify any data types or types that may need special considerations for Oracle GoldenGate in a MySQL environment. Main Article  The complete script can be found in the Oracle Support Site under document ID:1501176.1 All content listed on this page […]

Oracle GoldenGate Best Practices: Testing Maximum Performance of Disks in UNIX

Introduction This document will detail how to calculate maximum disk read and write rates for a single process using the UNIX “dd” and “time” commands. Not covered in this document are performance differences using different RAID (redundantly arrayed independent disks) configurations, limitations of the system bus speeds and limitations of controller buffer speeds. Main Article […]

Oracle GoldenGate Best Practices: Using the GoldenGate Logdump Utility to Manually Load Balance across Multiple Processes

Introduction This technical document describes how to combine the GoldenGate logdump utility, UNIX shell scripting and MS Excel to generate a detailed summary report to aid in manual load balancing of tables across multiple GoldenGate replication processes. This document is not intended to be a comprehensive overview of all replication performance techniques; it is limited […]

Oracle GoldenGate Best Practices: Extracting object ID’s for ALTID Table Mapping

Introduction In some cases it may be necessary to use the object ID’s to extract table data. This document covers the steps necessary to convert a list of tables into a list of object ID’s that can be used in an extract process as ALTID’s.   ALTID’s can be used in the case where a source […]

Oracle GoldenGate Best Practices: Oracle Streams to Oracle GoldenGate Conversion for Reporting Databases

Introduction Oracle GoldenGate is the strategic replication solution for Oracle Database and for heterogeneous databases. Given the strategic nature of Oracle GoldenGate, Oracle Streams will continue to be supported, but will not be enhanced. For this reason, some Oracle Streams customers may prefer to migrate their replication environments to Oracle GoldenGate. Main Article The goal […]

Oracle GoldenGate Best Practices: Dual Apply

Introduction Oracle GoldenGate provides a real-time, log-based change data capture and replication software platform that enables high volumes of transactional data to be moved between homogenous and heterogeneous platforms and databases, even bi-directionally, in sub-second speed, with no impact. With this technology, Oracle provides continuous availability and real-time data integration solutions to deliver real-time access […]

Oracle GoldenGate Best Practices: Extracting from Oracle Archive log files (ALO Mode)

Introduction In systems where you don’t have direct access to the source system you can now take advantage of remote data mining using Oracle Archive log files only.  You can use this method of data extraction against the Source Oracle Database, Standby database, Meta data database or even BCV copy of the source database.  One […]

Oracle GoldenGate Best Practices: Oracle GoldenGate Conflict Management

Introduction In a multi-master database environment where the occurrence of conflicts is possible during replication, it is highly desirable to have a conflict management scheme which is enforced as an exception rather than as a norm.  Typically, the chances of conflicts occurring during replication are low and hence, checking for conflicts every time before a […]

Oracle GoldenGate – A Guide to Globalization aspects when working with OGG

Introduction The goal of this paper is to describe the concepts related to globalization and provide best practice guidelines when configuring Oracle GoldenGate (OGG). Main Article We will begin by defining character set and discuss the various usage contexts of character sets which are referred to when configuring OGG. The complete document can be found […]

Oracle GoldenGate Best Practices: Heartbeat Table for Monitoring Lag times

Introduction This document is intended to help you implement the best practice for creating a heartbeat process that can be used to determine where and when lag is developing between a source and target system. Main Article This document will walk you thru the step-by-step process of creating the necessary tables and added table mapping […]