10. Troubleshooting GoldenGate | 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%

The GoldenGate dynamic performance views

Like all database components, Oracle provides a set of dynamic performance views (known as the v$ views) that allow the DBA to investigate and diagnose performance bottlenecks on the fly. The v$ views may be queried with minimal overhead during heavy processing to determine the following information:

View name	Description
`V_$GOLDENGATE_CAPABILITIES`	This lists the enabled capabilities of GoldenGate in the database, such as `DBLOGREADER`, `TRIGGERSUPPRESSION`, `TRANSIENTDUPLICATE`, and `DDLTRIGGEROPTIMIZATION`.
`V_$GOLDENGATE_CAPTURE`	This is similar to `V_$STREAMS_CAPTURE` that provides the integrated capture process information.
`V_$GOLDENGATE_TABLE_STATS`	This lists the collision, detection, and resolution (CRD) statistics for the integrated apply process.
`V_$GOLDENGATE_TRANSACTION`	This lists the in-flight transaction statistics.
`V_$GOLDENGATE_MESSAGE_TRACKING`	This is available in Oracle database future Release 12.2...

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