4. Configuring Oracle GoldenGate | 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

Configuring change data capture

Oracle recommends that CDC is configured and started before the initial load. This enables change synchronization to keep track of ongoing transactional changes while the load is being applied—a very useful feature when you cannot afford for your source system to be taken offline. In fact, GoldenGate can manage and combine the online transactional changes and the initial data extract with ease, ensuring no data loss or downtime.

So, let's now take a look at the steps required to configure and start CDC in the Oracle 12c multitenant container database environment. After this, we will look at the same for an Oracle database configured in the noncontainer database architecture.

The configuration summary

To summarize the configuration overview in this section, the following table describes the naming convention and mapping between roles, filenames, and processes used in the configuration examples:

Role	Process	Process group name	Parameter filename	Trail filename...

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