Oracle GoldenGate Online for Working professional by AMK Technologies

Chapter 1 Introduction to Oracle GoldenGate

Oracle GoldenGate supported processing methods and databases

Overview of the Oracle GoldenGate architecture

Overview of process types

Overview of groups

Overview of the Commit Sequence Number (CSN)

Chapter 2 Installing Oracle GoldenGate

Downloading Oracle GoldenGate

Setting ORACLE_HOME and ORACLE_SID

Specifying Oracle variables on UNIX and Linux systems

Specifying Oracle variables on Windows systems

Setting library paths for dynamic builds on UNIX

Preparing to install Oracle GoldenGate within a cluster

Installing as the Oracle user

Supported Oracle cluster storage

Deciding where to install Oracle GoldenGate binaries and files in the cluster

Installing Oracle GoldenGate on Linux and UNIX

Installing Oracle GoldenGate on Windows

Installing Oracle GoldenGate into a Windows Cluster

Installing the Oracle GoldenGate files

Specifying a custom Manager name

Installing Manager as a Windows service

Integrating Oracle GoldenGate into a cluster

General requirements in a cluster

Adding Oracle GoldenGate as a Windows cluster resource

Installing support for Oracle sequences

Chapter3 Configuring Manager and Network Communications

Overview of the Manager process

Assigning Manager a port for local communication

Maintaining ports for remote connections through firewalls

Choosing an internet protocol

Recommended Manager parameters

Creating the Manager parameter file

Starting Manager

Stopping Manager

Chapter4 Getting started with the Oracle GoldenGate process interfaces

Using the GGSCI commandline interface

Using UNIX batch and shell scripts

Using Oracle GoldenGate parameter files

Supported characters in object names

Specifying object names in Oracle GoldenGate input

Chapter5 Using Oracle GoldenGate for live reporting

Overview of the reporting configuration

Considerations when choosing a reporting configuration

Creating a standard reporting configuration

Creating a reporting configuration with a data pump on the source system

Creating a reporting configuration with a data pump on an intermediary system

Creating a cascading reporting configuration

Chapter6 Using Oracle GoldenGate for realtime data distribution

Overview of the datadistribution configuration

Considerations for a datadistribution configuration

Creating a data distribution configuration

Chapter7 Configuring Oracle GoldenGate for realtime data warehousing

Overview of the datawarehousing configuration

Considerations for a data warehousing configuration

Creating a data warehousing configuration

Chapter8 Configuring Oracle GoldenGate to maintain a live standby database

Overview of a live standby configuration

Considerations for a live standby configuration

Creating a live standby configuration

Moving user activity in a planned switchover

Moving user activity in an unplanned failover

Chapter9 Configuring Oracle GoldenGate for activeactive high availability

Overview of an activeactive configuration

Considerations for an activeactive configuration

Preventing data looping

Creating an activeactive configuration

Managing conflicts

Handling conflicts with the Oracle GoldenGate CDR feature

Configuring Oracle GoldenGate CDR

CDR example : All conflict types with USEMAX, OVERWRITE, DISCARD

CDR example : UPDATEROWEXISTS with USEDELTA and USEMAX

CRD example : UPDATEROWEXISTS with USEDELTA, USEMAX, and IGNORE

Chapter10 Mapping and manipulating data

Limitations of support

Parameters that control mapping and data integration

Mapping between dissimilar databases

Deciding where data mapping and conversion will take place

Globalization considerations when mapping data

Mapping columns

Selecting rows

Retrieving before values

Selecting columns

Selecting and converting SQL operations

Using transaction history

Testing and transforming data

Using tokens

Chapter11 Handling Oracle GoldenGate processing errors

Overview of Oracle GoldenGate error handling

Handling Extract errors

Handling Replicat errors during DML operations

Handling Replicat errors during DDL operations

Handling TCP/IP errors

Maintaining updated error messages

Resolving Oracle GoldenGate errors

Chapter12 Associating replicated data with metadata

Configuring Oracle GoldenGate to assume identical metadata

Configuring Oracle GoldenGate to assume dissimilar metadata

Configuring Oracle GoldenGate to use a combination of similar and dissimilar definitions

Chapter13 Configuring online change synchronization

Overview of online change synchronization

Configuring change synchronization to satisfy a specific topology

Naming conventions for groups

Creating a checkpoint table

Creating an online Extract group

Creating a trail

Creating a parameter file for online extraction

Creating an online Replicat group

Creating a parameter file for online replication

Controlling online processes

Deleting a process group

Chapter14 Running an initial data load

Overview of initial data load methods

Using parallel processing in an initial load

Prerequisites for initial load

Loading data with a database utility

Loading data from file to Replicat

Loading data from file to database utility

Loading data with an Oracle GoldenGate direct load

Loading data with a direct bulk load to SQL*Loader

Loading data with Teradata load utilities

Chapter15 Customizing Oracle GoldenGate processing

Overview of custom processing

Executing commands, stored procedures, and queries with SQLEXEC

Using Oracle GoldenGate macros to simplify and automate work

Using user exits to extend Oracle GoldenGate capabilities

Using the Oracle GoldenGate event marker system to raise database events

Chapter16 Monitoring Oracle GoldenGate processing

Overview of the Oracle GoldenGate monitoring tools

Using the information commands in GGSCI

Monitoring an Extract recovery

Monitoring lag

Monitoring processing volume

Using the error log

Using the process report

Using the discard file

Using the system logs

Reconciling time differences

Sending event messages to a NonStop system

Getting more help with monitoring and tuning

Chapter17 Performing administrative operations

Overview of administrative operations

Performing application patches

Adding process groups

Initializing the transaction logs

Shutting down the system

Changing database attributes

Changing the size of trail files

Chapter18 Undoing data changes with the Reverse utility

Overview of the Reverse utility

Reverse utility restrictions

Configuring the Reverse utility

Creating process groups and trails for reverse processing

Running the Reverse utility

Undoing the changes made by the Reverse utility