Oracle GoldenGate: Monitoring “Things” That Affect Replication Stability

Introduction There have been a lot of escalations to A-Team where Oracle GoldenGate outages could have been avoided if System and Database Administrators had been properly monitoring their environments. In this article we’re going to discuss various areas that should be monitored regularly to avoid degradations in performance and unscheduled outages. The concepts, scripts, and information […]

Oracle GoldenGate: Security Best Practices

Introduction Securing platforms, applications, and data from unauthorized access is of great importance to IT organizations. In this article we shall detail the product features and best practices for securing your Oracle GoldenGate environment. The concepts presented in this article are for educational purposes only. Before applying any changes presented in this article to your environment, […]

Oracle GoldenGate Best Practices: HP Nonstop Audited Data Replication

Introduction Oracle GoldenGate for HP Nonstop provides capabilities for the manipulation of transactional data and the replication of selected TMF Audited Enscribe, SQL/MP, SQL/MX, and Non-Audited Enscribe data to a variety of applications and platforms. In this article we shall present a series of “best practices” for the configuration and operation of Oracle GoldenGate when […]

Oracle GoldenGate: SQL Server to SQL Server Instantiation

Introduction The target database instantiation, or initial load, process is key to a successful Oracle GoldenGate implementation. In this article we shall present best practices when instantiating a target Microsoft SQL Server database from a source SQL Server database when implementing Oracle GoldenGate. Main Article When planning a target database instantiation, there are several questions […]

Oracle GoldenGate: How to Configure On-Premises to GoldenGate Cloud Services (GGCS) Replication with Corente VPN

Introduction Important Update as of 20171201: There’s a new article that covers an updated procedure on how to setup OPC Cloud Gateway VPN using Corente. The article’s title is This document will walk you through how to configure Oracle GoldenGate replication between On-Premises to GoldenGate Cloud Service (GGCS) on Oracle Public Cloud (OPC) via Virtual […]

Oracle GoldenGate Best Practices: Configuring Oracle GoldenGate Monitor 12c

Introduction Oracle GoldenGate provides data capture from transaction logs and delivery for heterogeneous databases and messaging systems. Oracle GoldenGate (OGG) provides a flexible, de-coupled architecture that can be used to implement virtually all database replication scenarios. Oracle GoldenGate Monitor provides secure viewing, management, and alerting capabilities for GoldenGate with end-to-end topology solution displays and customizable […]

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: 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: NFS Mount options for use with Oracle GoldenGate

Introduction The purpose of this document is to outline the file system mount options to use when configuring GoldenGate to run with NFS mounted file system. Main Article Unless IO buffering is OFF, NFS mounts should not be used when running any Oracle GoldenGate processes.  The danger occurs when one process registers the end of a trail file or transaction log […]

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 Best Practices: Creating History Tables

Introduction Oracle GoldenGate’’s flexible architecture provides built-in functionality for the transformation of captured transactional data. This data manipulation may take place anywhere in the Oracle GoldenGate stream; but is most commonly performed in the Change Data Apply (Replicat) process during data apply to the target. Main Article In this document we shall use this functionality […]

Oracle GoldenGate Best Practices: Oracle GoldenGate for SQL Server

Introduction Oracle GoldenGate for SQL Server allows users to capture changes made to a specific set of tables in one database and deliver those changes to corresponding tables in another database in near real time. Main Article Replication can serve several purposes in database information management: Replication can provide a backup of specified table data […]

Oracle GoldenGate Best Practices: Oracle GoldenGate for ETL Tools

Introduction This document outlines the best practices for implementing Oracle GoldenGate real-time data integration solution to stage data for consumption by an ETL tool. The three different approaches that will be discussed are: Live Reporting database – The basic assumption with this approach is that there is already a Live Reporting database being maintained that can be […]

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 […]