• Installing and Configuring GoldenGate Veridata Agent

    The GoldenGate Veridata Agents execute the database related requests to compare source and target database rows on behalf of the Veridata Server. At a minimum we need to install two agents – one to retrieve source rows and one to retrieve target rows from the database. There are two types…

  • Oracle GoldenGate Veridata Installation and Configuration

    Oracle GoldenGate Veridata is a product that enables us to compare two sets of data and identify and report on data that is out of synchronization. This is helpful in a 24×7 replication enviornment where takimg downtime to compare sets of data is not an option and Veridata can run…

  • 11g Release 2 Rolling Upgrade using Transient Logical Standby database

    This note illustrates how we can perform a rolling upgrade from Oracle 11g Release 1 to Oracle 11g Release 2 using a Transient Logical Standby database. This approach will miminise the downtime required for an upgrade which can potentially run into several hours down to just the time required to…

  • 11g Data Guard Broker DGMGRL Configuration quick steps

    This note describes the commands used to create a Data Guard broker configuration using the command line dgmgrl interface. This can also be done via the Enterprise Manager Grid Control GUI as well and the assumption is that there is a Physical Standby database in place and redo transport and…

  • Create Standby Database using 11g DUPLICATE FROM ACTIVE DATABASE

    Purpose This note explains the procedure of creating a Physical Standby database using 11g RMAN DUPLICATE FROM ACTIVE DATABASE feature which is now available in 11g Release 1 onwards. This enables us to create a physical standby database without having to take a backup of the primary database as a…

  • Oracle 11g External Tables to store results of OS commands

    In Oracle 11g, we can now use external tables to not only display data stored in flat files outside the database, but also store the result of any command executed at the OS level – for example in this case we have a shell script which basically runs the ‘uptime’…

  • Oracle GoldenGate – Using the Director Client

    To start the GoldenGate Director Server, we need to run the startWebLogic.sh script located in the “domain” sub-directory of the GoldenGate Director Server software installation directory. [oracle@redhat346 bin]$ cd /u01/oracle/gg-director [oracle@redhat346 gg-director]$ ls cds_current_db_config.xml cds-tool-error.log cds-tool.log domain domain-new.jar ggs.url notices.txt uninstall [oracle@redhat346 gg-director]$ cd domain [oracle@redhat346 domain]$ cd bin [oracle@redhat346…

  • Oracle GoldenGate – Installing GoldenGate Director Server and Client

    GoldenGate Director is a multi tier client server application that enables the configuration and management of the GoldenGate environment from a remote client which includes a web browser based client. There are a number of different components which go to make up the GoldenGate Director product. Let us briefly describe…

  • Oracle GoldenGate Tutorials now available …..

    GoldenGate Concepts and Architecture Installation on Red Hat Linux with Oracle 11g Configuring the Manager process Performing an initial data load Configuring online change synchronization Configuring the Data Pump process Configuring DDL Synchronization Filtering and Mapping data Monitoring Goldengate Performing a zero downtime cross platform database upgrade Installing the GoldenGate…

  • Oracle GoldenGate Tutorial 9 – Monitoring GoldenGate

    The following tutorial will briefly discuss the different commands we can use to monitor the GoldenGate environment and get statistics and reports on various extract and replicat operations which are in progress. More details can be obtained from Chapter 19 of the Oracle GoldenGate Windows and Unix Administration guide –…

  • Oracle Goldengate Tutorial 8 – Filtering and Mapping data

    Oracle GoldenGate not only provides us a replication solution that is Oracle version independent as well as platform independent, but we can also use it to do data transformation and data manipulation between the source and the target. So we can use GoldenGate when the source and database database differ…

  • Oracle GoldenGate Tutorial 7 – configuring DDL synchronization

    In addition to providing replication support for all DML statements, we can also configure the GoldenGate environment to provide DDL support as well. A number of prerequisite setup tasks need to be performed which we willl highlight here. Run the following scripts from the directory where the GoldenGate software was…

  • Oracle GoldenGate Tutorial 6 – configuring Data Pump process

    The Data Pump (not to be confused with the Oracle Export Import Data Pump) is an optional secondary Extract group that is created on the source system. When Data Pump is not used, the Extract process writes to a remote trail that is located on the target system using TCP/IP….

  • Oracle GoldenGate Tutorial 5 – configuring online change synchronization

    In our earlier tutorial, we examined how to create a GoldenGate environment for initial data capture and load. In this tutorial, we will see how by using GoldenGate change synchronization, changes that occur on the source (Oracle 11g on Linux) are applied near real time on the target (Oracle 11g…

  • Oracle GoldenGate Tutorial 4 – performing initial data load

    This example illustrates using the GoldenGate direct load method to extract records from an Oracle 11g database on Red Hat Linux platform and load the same into an Oracle 11g target database on an AIX platform. The table PRODUCTS in the SH schema on the source has 72 rows and…

  • GoldenGate Tutorial 3 – Configuring the Manager process

    The Oracle GoldenGate Manager performs a number of functions like starting the other GoldenGate processes, trail log file management and reporting. The Manager process needs to be configured on both the source as well as target systems and configuration is carried out via a parameter file just as in the…

  • GoldenGate Tutorial 2 – Installation (Oracle 11g on Linux)

    This example will illustrate the installation of Oracle GoldenGate on an RHEL 5 platform. We had in an earlier post discussed the architecture and various components of a GoldenGate environment. GoldenGate software is also available on OTN but for our platform we need to download the required software from the…

  • GoldenGate Tutorial 1 – Concepts and Architecture

    GoldenGate enables us to extract and replicate data across a variety of topologies as shown the diagram below as well as the exchange and manipulation of data at the transactional level between a variety of database platforms like Oracle, DB2, SQL Server, Ingres, MySQL etc. It can support a number…

  • Oracle GoldenGate – an introduction

    Oracle Corporation at the end of last year has acquired GoldenGate Software Inc which is one of the leading providers of real time data integration solutions. In the words of Hasan Rizvi, Senior Vice President, Oracle Fusion Middleware Product Development …. “GoldenGate also enables high availability and disaster tolerance with…