In general, any replication tool replicates data in similar objects. We need an identical copy of the source and target if we want to do replication. Column Mapping Oracle Golden Gate is a strong tool which provides the capability to map columns between two dissimilarly structured database table. This feature can be implemented in Golden Gate […]
Monthly Archives: March 2019
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 […]
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 – ||
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 […]
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 […]
Upgrading 12cR1 to 12cR2 Non-CDB database
In this article, we will see upgrading Oracle Database from 12c Release 1 to 12C Release 2. Step 1: Check database details [oracle@localhost u01]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Mon Aug 27 04:08:28 2018 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 […]
Upgrading an Oracle Data Guard Broker Configuration
Step 1: Login to dgmgrl and disable configuration before upgradation DGMGRL> disable configuration; Disabled. Step 2: set dg_broker_start parameter to a false value. SQL> alter system set dg_broker_start=false; System altered. Step 3: upgrade database using dbua Step 4: Start dg_broker by setting dg_broker_start to the true value. SQL> alter system set dg_broker_start=true; System altered. Step […]