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...
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...
