Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) Macros provide functionality...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) Macros provide functionality for sharing parameters or other run-time configuration settings across multiple components and externalizing complex configuration settings in order to streamline parameter file contents. In this article we shall discuss how to create a Macro Library and access specific Macros via the OGG Group parameter file. Main...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) Macros provide functionality for sharing parameters or other run-time...
Introduction This document outlines the memory requirement for GoldenGate Integrated Extract. Main Article The shared memory that is used by Integrated...
Introduction This document outlines the memory requirement for GoldenGate Integrated Extract. Main Article The shared memory that is used by Integrated Extract(log mining server) comes from the "STREAMS POOL" portion of the System Global Area (SGA) in the database. Therefore, you must set it high enough to keep enough memory available for the number of Extract processes that you expect to run in Integrated mode against a given database instance. Note that "STREAMS POOL" is...
Introduction This document outlines the memory requirement for GoldenGate Integrated Extract. Main Article The shared memory that is used by Integrated Extract(log mining server) comes from the...
Introduction The way in which a schema is set up and objects are created in the source and target environments could impact Oracle GoldenGate DDL replication....
Introduction The way in which a schema is set up and objects are created in the source and target environments could impact Oracle GoldenGate DDL replication. This is illustrated by the example in this document. Main Article For Oracle GoldenGate (OGG) DDL replication to work correctly, the source and target schemas should be identical. Sometimes even if the sequence of operations used to create the schemas are different, it could impact DDL replication. For example the...
Introduction The way in which a schema is set up and objects are created in the source and target environments could impact Oracle GoldenGate DDL replication. This is illustrated by the example in...
Introduction Oracle’s customers are seeking the highest level of data protection and availability. In doing so, they have deployed complex configurations using...
Introduction Oracle’s customers are seeking the highest level of data protection and availability. In doing so, they have deployed complex configurations using the latest HA and DR solutions. The goal of this blog post is to discuss an approach of integrating Oracle GoldenGate Downstream Integrated Extract with Oracle Data Guard. Main Article Downstream Integrated Extract: In release 11.2.1, OGG released a feature which enables downstream capture of data from a single...
Introduction Oracle’s customers are seeking the highest level of data protection and availability. In doing so, they have deployed complex configurations using the latest HA and DR solutions. The...
Introduction This paper provides an example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication that complies with...
Introduction This paper provides an example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication that complies with recommended best practices. The example is generic and can serve as a starting point for a more customized Oracle GoldenGate implementation. Main Article Most Oracle GoldenGate functionality is controlled by means of parameters specified in parameter files. A parameter file is an ASCII file that is read by an...
Introduction This paper provides an example of Oracle GoldenGate parameter files that can be used to configure Oracle GoldenGate replication that complies with recommended best practices. The example...
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...
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 table was dropped and you have the original object ID and you want to extract historical data from archive log files. ALTID's can also be used to extract data from archive log files in ALO...
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...
Introduction Oracle GoldenGate provides a real-time, log-based change data capture and replication software platform that enables high volumes of transactional...
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 to real-time information. Main Article This...
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...
Introduction Oracle GoldenGate is Oracle's strategic replication solution for data distribution and data integration. Oracle Data Guard is Oracle's strategic...
Introduction Oracle GoldenGate is Oracle's strategic replication solution for data distribution and data integration. Oracle Data Guard is Oracle's strategic Disaster Recovery (DR) solution for the Oracle Database. It is common for customers to deploy both capabilities within the same configuration given the important role of each technology. For example, GoldenGate capture processes can be deployed on a source database that is also a primary or a standby database in a Data...
Introduction Oracle GoldenGate is Oracle's strategic replication solution for data distribution and data integration. Oracle Data Guard is Oracle's strategic Disaster Recovery (DR) solution for the...
