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 […]
Articles Tagged: Goldengate
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 […]
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 […]
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 […]
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 […]
Preparing Environment for Oracle Golden Gate Extract and Replication Part – I
Preparing Environment for Oracle Golden Gate Extract and Replication Following Steps should be done to use Oracle Golden Gate Extract and Replication. Two Servers : 1 for extract and 1 for replicat. Oracle Installation in both Server [I am using Oracle 12C Release 2] Database Creation in both Servers Listener Configuration Oracle Golden Gate Installation […]
Oracle Golden Gate Components
Oracle Golden Gate Oracle GoldenGate offers a real-time, log-based replication software platform to meet the needs of today’s transaction-driven applications. The software provides capture, routing, transformation, and delivery of transactional data across heterogeneous databases in real time. Components in Oracle Golden Gate : Following Components are used in Oracle Golden Gate to perform its tasks. Extract […]
COLS & COLSEXCEPT FILTER in goldengate
Introduction:- We are going to have look at COLS & COLSEXCEPT FILTER in goldengate. First, we have mentioned the technical definition of COLS & COLSEXCEPT FILTER. after completing, we are going to learn about the steps use ofCOLS & COLSEXCEPT FILTER in goldengate . These parameters are used to Replicat only specific columns from the Source to […]
Schema replication using oracle goldengate
Being a DBA we are must aware of replication in DATA field. In this tutorial, we will explain how to do schema replication in goldengate. Schema replication means, replicating all the tables of a schema. This table explains about the HOST IP, DB_NAME, Goldengate Process, SCHEMA To Replicate. All steps mention the way to replication […]
Obey Command In Goldengate
Like we execute .sql file against SQL, we can write multiple golden gate commands inside a .oby file and execute it against GGSCI prompt using OBEY command. Use OBEY to process a file that contains a list of Oracle GoldenGate commands. OBEY is useful for executing commands that are frequently used in sequence. EXAMPLE: In the below […]