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 considerations and will also be addressed in this document. This architecture configuration using redo cascade is the most decoupled solution that can still provide realtime characteristics of change data capture. The focus of the document is intended for Oracle Database Administrators (DBAs), and Oracle Developers with basic knowledge of Oracle GoldenGate and Oracle DataGuard. The document is intended to be a supplement to the existing series of documentation available from Oracle.
The following assumptions have been made during the writing of this document:
» The reader has basic knowledge of Oracle GoldenGate products and concepts
» Referencing Oracle GoldenGate Version 12.2 and above
» Referencing Oracle RDBMS Version 220.127.116.11 and above
» Referencing OS: All Oracle GoldenGate supported platforms for Oracle
Oracle GoldenGate is the market leading data integration tool, it provides data capture from transaction logs and delivery for homogeneous/heterogeneous databases, big data and messaging systems. A key strength of Oracle GoldenGate is that it provides a flexible, de-coupled architecture that can be used to implement virtually any replication scenario.
This document will address how to configure Oracle GoldenGate to extract data from an ADG Standby by utilizing cascading redo log shipping and a downstream mining server. This document assumes that the user already has the following systems configured: 1) a source rdbms, 2) an ADG Standby for the source system and 3) a mining database. This document will outline the steps to enable those environments to work together for implementing downstream extraction from an ADG Standby.