OGG Extract entry in DBA_APPLY view

Introduction DBAs are often reviewing what items exist in their DBA views.  I was recently asked by a DBA if they could drop the Apply Process  in the DBA_APPLY view since they had no OGG Apply processes running on this particular system.  They only had OGG Capture processes on this particular server.  The short answer […]

OGG Replicat Abend with Error ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

Introduction Both Classic Replicat and Integrated Replicat can abend on this error.  This blog will discuss the causes of this abend and how you can resolve it. Main Article This error message, Error ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE, will appear in your replicat report file.  To some DBAs, a Domain Index is not something […]

Oracle GoldenGate Best Practices: Replication between Cloud and On-Premise Environments with Oracle GoldenGate Version 12c

Introduction Oracle GoldenGate Extract, Replicat and associated utilities enable you to create, load and refresh one database to another database.  This white paper will be utilizing examples for Oracle to Oracle homogenous replication, but it does not preclude the source and target environments being heterogeneous databases.   These examples also show data being replicated between a […]

Oracle® GoldenGate 12c Tutorial Oracle to Oracle Replication with Oracle Multitenant V12.1

Introduction Extract, Replicat and associated utilities enable you to create, load and refresh one Oracle database to another Oracle database. This tutorial provides a quick overview of Oracle to Oracle database replication using Integrated Extract and Integrated Replicat for version 12c and above. Extraction from a Multitenant database is only supported by Integrated Extract. This […]

How to force OGG to use ENABLED Invalid or Non-Validated Keys

Introduction If a table has a PK constraint or a Unique Constraint that is Non-Validated or Invalid, Oracle GoldenGate will by default not use those keys to uniquely identify a row.  It will use all columns to uniquely identify a row.  This may become an issue due to the increased space required for both trails […]

Oracle GoldenGate Best Practices: Active-Active Configuration with DDL and DML CDR

​Introduction This document is an introduction to Oracle GoldenGate’s best practices and guidelines for configuring Oracle GoldenGate (OGG) in an active-active environment with DDL replication enabled while also using the built in functionality of DML Conflict Detection and Resolution (CDR).  This document is intended for Oracle Database Administrators (DBAs), Oracle Developers with some basic knowledge […]

Oracle® GoldenGate Tutorial for Oracle to Oracle Version 11.2

Introduction Extract, Replicat and associated utilities enable you to create, load and refresh one Oracle database to another Oracle database. This tutorial provides a quick overview of Oracle to Oracle database replication using Extract and Replicat for version 11.2 and above.  Both Classic and Integrated Extract are demonstrated in this tutorial.  For more detailed information, […]

Oracle GoldenGate Database Profile Check Script for DB2 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 GoldenGate in a DB2 environment. Main Article The complete script can be found in the Oracle Support Site under document ID 1438514.1. All content listed on this page […]

Database Permissions Required For OGG Users in a Database Vault Environment

Introduction In a Database Vault Environment, the Oracle GoldenGate Extract and Replicat users will require additional permissions in order to access Redo Log Information, System views and Table Data. Main Article Both Extract and Replicat will require access to the table data.  Extract may need to fetch certain data and Replicat will need to apply […]

Oracle GoldenGate Best Practices: Configuring Oracle GoldenGate with Oracle Grid Infrastructure Bundled Agents (XAG)

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. The Oracle Grid Infrastructure provides the necessary components to manage high availability (HA)and resource management for any business critical […]

Oracle GoldenGate Best Practices: Configuring Downstream Integrated Extract

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 replication scenarios. Main Article In version 11.2.1, OGG released a feature that enables downstream capture of data from a single source or […]

Oracle GoldenGate Best Practices: Instantiation from a SQL Server Source Database

Introduction This document is an introduction to Oracle GoldenGate best practices and guidelines for instantiation of a target database from a SQL Server Source Database. Main Article This document is intended for SQL Server database administrators (DBAs), and SQL Server Developers with some basic knowledge of GoldenGate Software. The document is intended to be a […]

Oracle GoldenGate Best Practices: Instantiation from a DB2 Source Database

Introduction This document will outline the Best Practice approach for Instantiating a DB2 target database from a DB2 or other database source system. Main Article One of the biggest challenges in creating a DB2 target database for replication is to insure that no collisions or data loss will occur when applying the change data after the […]

Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database

Introduction This document is an introduction to Oracle GoldenGate’s best practices and guidelines for instantiation of a target database from an Oracle Source Database. Main Article The method outlined in this document will allow the customer to start Replicat at a specific point in the trail file created by Extract by using CSN number so the […]