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 Oracle GoldenGate's flexible architecture provides built-in functionality for the transformation of captured transactional data. This data...
Introduction 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 functionality to build (1) a classic operation history table where all activity is recorder, and (2)...
Introduction 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...
Introduction Oracle GoldenGate for SQL Server allows users to capture changes made to a specific set of tables in one database and deliver those changes to...
Introduction Oracle GoldenGate for SQL Server allows users to capture changes made to a specific set of tables in one database and deliver those changes to corresponding tables in another database in near real time. Main Article Replication can serve several purposes in database information management: Replication can provide a backup of specified table data in the event of problems with the primary database. If the site is dual active, and one system becomes unavailable, the...
Introduction Oracle GoldenGate for SQL Server allows users to capture changes made to a specific set of tables in one database and deliver those changes to corresponding tables in another database in...
