7. Advanced Configuration | Oracle Goldengate 12c Implementers Guide

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Oracle Goldengate 12c Implementers Guide

By : John P Jeffries

4.4 (10)

Oracle Goldengate 12c Implementers Guide

4.4 (10)

By: John P Jeffries

Overview of this book

The book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Getting Started

1. Getting Started

What is GoldenGate?

Oracle GoldenGate evolution

Oracle GoldenGate solutions

Oracle GoldenGate technology overview

Oracle GoldenGate architecture

12c new features

Supported platforms and databases

Oracle GoldenGate topology

Design considerations

What to replicate?

Summary

2. Installing and Preparing GoldenGate

2. Installing and Preparing GoldenGate

Prerequisites

The Oracle virtual machine

The software installation

Preparing the environment

Creating the initial configuration

Patching the GoldenGate home

GoldenGate deinstallation from Linux/Unix

Summary

3. Design Considerations

3. Design Considerations

Replication methods

Networking

Non-functional requirements

Hardware considerations

Changed data management

Changed data recovery

Summary

4. Configuring Oracle GoldenGate

4. Configuring Oracle GoldenGate

GoldenGate parameters

The GoldenGate instantiation

Performing the initial load

Configuring change data capture

Configuring change delivery

Testing change data capture and delivery

Stopping GoldenGate processes

More about trail files

Configuring Oracle Manager process

Configuring the downstream mining database

Summary

5. Configuration Options

5. Configuration Options

Using BATCHSQL

Data compression

Security features

Event-based processing

Bidirectional configuration options

The DDL support

Heterogeneous environments

Oracle Streams to GoldenGate Migration

Summary

6. Configuring GoldenGate for HA

6. Configuring GoldenGate for HA

GoldenGate on RAC

GoldenGate on Exadata

Failover

7. Advanced Configuration

7. Advanced Configuration

Mapping your data

Data selection and filtering

Data transformation

DDL support

The SQLEXEC parameter

Using and defining macros

User tokens

User exits

Using logic in the data replication

Replicating data between different GoldenGate versions

Licensing

Oracle Data Integrator 12c

Summary

8. Managing Oracle GoldenGate

8. Managing Oracle GoldenGate

The Oracle Management Pack for GoldenGate

Command-level security

Managing the trail file

Managing the process startup

Managing TCP/IP errors

Reporting and statistics

Summary

9. Performance Tuning

9. Performance Tuning

Before tuning GoldenGate

Tuning data delivery

Viewing integrated parameters

Controlling the memory consumption

Tracing processes to find wait events

Diagnosing a slow Extract

Static data dictionary views

Tuning the network

Hardware upgrades

Summary

10. Troubleshooting GoldenGate

10. Troubleshooting GoldenGate

Troubleshooting tips

GoldenGate health check

The GoldenGate dynamic performance views

Investigating network issues

Investigating Oracle errors

Exception handling

Handling Oracle Sequences

Using LOGDUMP

Upgrading GoldenGate

Dynamic Rollback

Summary

11. The Future of GoldenGate

11. The Future of GoldenGate

Cloud computing

GoldenGate and Big Data

Deprecation of the nonCDB architecture

Oracle GoldenGate 12c Release 2

Summary

A. GGSCI Commands

A. GGSCI Commands

B. GoldenGate Installed Components

B. GoldenGate Installed Components

C. Acronyms

C. Acronyms

Index

Index

Data selection and filtering

In addition to column mapping, GoldenGate offers two data filtering options:

Complex: Complex data evaluations use the FILTER clause. FILTER can select rows and columns for a given operation, whereas WHERE just selects rows. FILTER can also use GoldenGate's built-in functions.
Noncomplex: This filtering is achieved through the WHERE clause in a TABLE (Extract) or MAP (Replicat) statement.

As a rule of thumb, it is best practice to adopt the following strategy to avoid any performance overhead associated with data selection and filtering:

Avoid data filtering on the primary Extract group, thus avoiding slow extract of LCRs from the database redo logs.
Use a secondary Extract group (data pump) to filter data and potentially reduce data volume for transmission to the target system.
Use a data pump on an intermediate system to filter data, thus avoiding any performance overhead on the source and target systems.
Use a Replicat to optimize data filtering on the target....

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Oracle Goldengate 12c Implementers Guide

Search

Your notes and bookmarks