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...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate's flexible architecture provides...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. 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...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate's flexible architecture provides built-in functionality for...
This article has been deprecated as it is no longer valid for Oracle GoldenGate Microservices version 19.1, and above.