Data Selection and Filtering in Oracle Golden Gate

Oracle Golden Gate provides a variety of levels and conditions for selection and filtering data. Let’s start with the selection of table : We can map table1 with table2 so operation is done on table1 will be replicated on table2. map hr.table1 , target hr.table2; Data Selection with WHERE clause : Where () clause is […]

Read More

Configuring and Using String Substitution in DDL and DDL Error Handling

In the previous article, we have seen the configuration of DDL replication Configuring and Using Options for DDL Replication Today we will see Configuration of String Substitution in DDL replication. We can substitute strings within a DDL operation while it is being processed by Oracle Golden Gate. This feature provides convenience for changing and mapping […]

Read More

Configuring and Using Options for DDL Replication

As we have seen in previous article Oracle Golden Gate handles DDL operations for objects. DDL Replication in Golden Gate Objects are divided into scope for more simplicity as it shows how DDL operations on an object are handled by Oracle Golden Gate. There are mainly three scopes : Mapped : Objects which are specified […]

Read More

DDL Replication in Golden Gate

Till today, you have seen my all articles that show DML replication Golden Gate. I, U, D [Insert update and delete] three main operations which are replicated in Golden Gate. But, Golden Gate supports DDL replication too. It supports DDL synchronization from one database to another. Let us first see requirement and restrictions of DDL […]

Read More

Logdump Utility in Golden Gate

The logdump utility is used to access the Golden Gate trail file. The logdump utility is used to display or search for information that is stored in extract trail or extract files. We can even save part or a portion of the trail file into some other files. To start or to open logdump prompt […]

Read More

Architecture of Extract Trails and Files

Oracle Golden Gate trail supports continuous extraction and replication of database changes and stores them temporarily on disk. Extract process can write to the following type of files : 1. The extract can write to trail file on local disk, we know it as exttrail. 2. The extract can write to trail file on remote […]

Read More

Configuration Options in Oracle Golden Gate

As we know Golden Gate is very powerful when it comes to data replication between homogeneous and heterogeneous environment. I  wrote many articles on Golden Gate process group architectures, Golden Gate configuration, Configuring change capture, configuring change delivery and many more. You can see all my articles on Golden Gate here Today we will see […]

Read More

Configuring Change Capture

Extract Process :  Extract process captures all the changes made to all objects which we configure for Golden Gate for the synchronization process. It reads data either from transaction logs of database or archive log files. Once those transactions are completed, the Extract process sends all details of those transactions to trail files for propagation […]

Read More

Configuring Manager in Oracle Golden Gate

In this article we will see the Manager Process of Golden Gate, parameters that we can set using the manager process, starting and stopping manager process. Check out the previous article for installation and configuration for Oracle Golden Gate Preparing Environment for Oracle Golden Gate Extract and Replication Part – I   Preparing Environment for […]

Read More

Preparing Environment for Oracle Golden Gate Extract and Replication Part – ||

In the previous article, we have seen installing Golden Gate software. Preparing Environment for Oracle Golden Gate Extract and Replication Part – I In this article, we will see Creation of user for  Golden Gate extract process configuration Golden Gate replicat process configuration Enable Archive logging Enable Supplemental Logging We will start with User Creation […]

Read More