Introduction Oracle GoldenGate is the strategic replication solution for Oracle Database and for heterogeneous databases. Given the strategic nature of Oracle...
Introduction Oracle GoldenGate is the strategic replication solution for Oracle Database and for heterogeneous databases. Given the strategic nature of Oracle GoldenGate, Oracle Streams will continue to be supported, but will not be enhanced. For this reason, some Oracle Streams customers may prefer to migrate their replication environments to Oracle GoldenGate. Main Article The goal of this document is to provide a step-by-step explanation of the migration process for a...
Introduction Oracle GoldenGate is the strategic replication solution for Oracle Database and for heterogeneous databases. Given the strategic nature of Oracle GoldenGate, Oracle Streams will continue...
Introduction In a Database Vault Environment, the Oracle GoldenGate Extract and Replicat users will require additional permissions in order to access Redo Log...
Introduction In a Database Vault Environment, the Oracle GoldenGate Extract and Replicat users will require additional permissions in order to access Redo Log Information, System views and Table Data. Main Article Both Extract and Replicat will require access to the table data. Extract may need to fetch certain data and Replicat will need to apply data to the target tables. In order to do this, the OGG user must have Access to the Database Vault (DV) Realm. The DV Realm is...
Introduction In a Database Vault Environment, the Oracle GoldenGate Extract and Replicat users will require additional permissions in order to access Redo Log Information, System views and Table...
Introduction In systems where you dont have direct access to the source system you can now take advantage of remote data mining using Oracle Archive log files...
Introduction In systems where you dont have direct access to the source system you can now take advantage of remote data mining using Oracle Archive log files only. You can use this method of data extraction against the Source Oracle Database, Standby database, Meta data database or even BCV copy of the source database. One advantage of extracting from archive log files is that the whole process can be offloaded to another system and literally have zero impact on the...
Introduction In systems where you dont have direct access to the source system you can now take advantage of remote data mining using Oracle Archive log files only. You can use this method of data...
Introduction In a multi-master database environment where the occurrence of conflicts is possible during replication, it is highly desirable to have a conflict...
Introduction In a multi-master database environment where the occurrence of conflicts is possible during replication, it is highly desirable to have a conflict management scheme which is enforced as an exception rather than as a norm. Typically, the chances of conflicts occurring during replication are low and hence, checking for conflicts every time before a record is applied on the target is not efficient. However, at the same time it is highly important to ensure that...
Introduction In a multi-master database environment where the occurrence of conflicts is possible during replication, it is highly desirable to have a conflict management scheme which is enforced as...
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 This document outlines the best practices for implementing Oracle GoldenGate real-time data integration solution to stage data for consumption by...
Introduction This document outlines the best practices for implementing Oracle GoldenGate real-time data integration solution to stage data for consumption by an ETL tool. The three different approaches that will be discussed are: Live Reporting database - The basic assumption with this approach is that there is already a Live Reporting database being maintained that can be modified to support the additional requirements for feeding data into the ETL tool being used....
Introduction This document outlines the best practices for implementing Oracle GoldenGate real-time data integration solution to stage data for consumption by an ETL tool. The three different...
Introduction Oracle GoldenGate provides data capture from transaction logs and delivery for heterogeneous databases and messaging systems. Oracle GoldenGate...
Introduction Oracle GoldenGate provides data capture from transaction logs and delivery for heterogeneous databases and messaging systems. Oracle GoldenGate (OGG) provides a flexible, de-coupled architecture that can be used to implement virtually all replication scenarios. Main Article In version 11.2.1, OGG released a feature that enables downstream capture of data from a single source or multiple sources. This feature is specific to Oracle databases only. This feature...
Introduction Oracle GoldenGate provides data capture from transaction logs and delivery for heterogeneous databases and messaging systems. Oracle GoldenGate (OGG) provides a flexible, de-coupled...
Introduction This document will outline the Best Practice approach for Instantiating a DB2 target database from a DB2 or other database source system. Main...
Introduction This document will outline the Best Practice approach for Instantiating a DB2 target database from a DB2 or other database source system. Main Article One of the biggest challenges in creating a DB2 target database for replication is to insure that no collisions or data loss will occur when applying the change data after the initial instantiation of the target database. Oracle GoldenGate has addressed this issue by including functionality to apply the change data...
Introduction This document will outline the Best Practice approach for Instantiating a DB2 target database from a DB2 or other database source system. Main Article One of the biggest challenges in...
Introduction This document is an introduction to Oracle GoldenGate’s best practices and guidelines for instantiation of a target database from an Oracle Source...
Introduction This document is an introduction to Oracle GoldenGate’s best practices and guidelines for instantiation of a target database from an Oracle Source Database. Main Article The method outlined in this document will allow the customer to start Replicat at a specific point in the trail file created by Extract by using CSN number so the Replicat will not hit any "duplicate" records. The complete document can be found on the Oracle Support site under the document...
Introduction This document is an introduction to Oracle GoldenGate’s best practices and guidelines for instantiation of a target database from an Oracle Source Database. Main Article The method...
