5. Configuration Options | Oracle Goldengate 12c Implementers Guide

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

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

Customer Reviews

4.4 (10)

5 star

50%

4 star

40%

3 star

10%

2 star

0%

1 star

0%

Event-based processing

It is important in any data replication environment to capture and manage events, such as trail records containing specific data or operations or maybe the occurrence of a certain error. These are known as Event Markers.

GoldenGate provides a mechanism to perform an action on a given event or condition. These are known as Event Actions and are triggered by Event Records. If you are familiar with Oracle Streams, Event Actions are like rules.

The Event Marker System

GoldenGate's Event Marker System, also known as event marker interface (EMI), allows custom DML-driven processing on an event. This comprises of an Event Record to trigger a given action. An Event Record can be either a trail record that satisfies a condition evaluated by a WHERE or FILTER clause or a record written to an event table that enables an action to occur. Typical actions are writing status information, reporting errors, ignoring certain records in a trail, invoking a shell script, or performing an...

Visually different images

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