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...
Introduction Oracle GoldenGate is often used in mission-critical systems with stringent high availability requirements. In an Oracle to Oracle scenario, minimal...
Introduction Oracle GoldenGate is often used in mission-critical systems with stringent high availability requirements. In an Oracle to Oracle scenario, minimal latency between the source and the destination databases is important to achieve minimal downtime and minimal data loss in case of a failover. In an Oracle Real Application Cluster (RAC) configuration access to the database is not dependent on the availability of any one of the servers in the cluster. Oracle...
Introduction Oracle GoldenGate is often used in mission-critical systems with stringent high availability requirements. In an Oracle to Oracle scenario, minimal latency between the source and...
Introduction The goal of this paper is to describe the concepts related to globalization and provide best practice guidelines when configuring Oracle GoldenGate...
Introduction The goal of this paper is to describe the concepts related to globalization and provide best practice guidelines when configuring Oracle GoldenGate (OGG). Main Article We will begin by defining character set and discuss the various usage contexts of character sets which are referred to when configuring OGG. The complete document can be found on the Oracle Support site under the document ID:1500608.1
Introduction The goal of this paper is to describe the concepts related to globalization and provide best practice guidelines when configuring Oracle GoldenGate (OGG). Main Article We will begin...
Introduction This document is intended to help you implement the best practice for creating a heartbeat process that can be used to determine where and when lag...
Introduction This document is intended to help you implement the best practice for creating a heartbeat process that can be used to determine where and when lag is developing between a source and target system. Main Article This document will walk you thru the step-by-step process of creating the necessary tables and added table mapping statements needed to keep track of processing times between a source and target database. Once the information is added into the data flow,...
Introduction This document is intended to help you implement the best practice for creating a heartbeat process that can be used to determine where and when lag is developing between a source...
Introduction When working with new Oracle GoldenGate (OGG) customers we always get two questions: How can I ensure the referential integrity of my data? How can...
Introduction When working with new Oracle GoldenGate (OGG) customers we always get two questions: How can I ensure the referential integrity of my data? How can I ensure transactions are applied to my target database in the proper order? The key is to understand the difference between referential and transactional data, and how they relate to OGG. Main Article What is Referential Integrity? Definition: Referential integrity is a relational database concept which states that...
Introduction When working with new Oracle GoldenGate (OGG) customers we always get two questions: How can I ensure the referential integrity of my data? How can I ensure transactions are applied to my...
