Recent Posts by Tracy West

  Introduction This paper provides guidance and examples for setting up downstream extraction from an Oracle DataGuard Standby system that has been configured with cascading redo logs. We outline how to configure the cascade log shipping from the standby to the mining database as well has how to configure the extract process on the mining server to fetch necessary data from the DataGuard standby system. Instantiation of target systems from an DataGuard standby has special...

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 to that question is 'No', unless you can absolutely verify that the entry you wish to remove has nothing to do with an OGG Extract process. Main Article If you...

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 they see or use on a regular basis.  This type of error is usually due to one of two scenarios: 1) the index is invalid and needs to...

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 tutorial may be read to get a general overview of how Extract and Replicat operate. Alternatively,...

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 and redo logs.  It will also force all updates to become PK Updates.  This could become a performance issue on the target because it may not use an index to apply...

​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 of Oracle GoldenGate software product and Oracle GoldenGate...

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, please consult the Oracle GoldenGate Administration Guide. This tutorial may be read to get a...

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.

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 data to the target tables.  In order to do this, the OGG user must have Access to the Database Vault (DV) Realm.  The DV Realm is...