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

Appendix C. Acronyms

The following table of acronyms are used throughout this book and arranged in alphabetical order for ease of reference:

Abbreviations	Expansions
ACFS	This stands for ASM Cluster File System
ADG	This stands for Active Data Guard
AES	This stands for Advanced Encryption Security
API	This stands for application program interface
ASCII	This stands for American Standard Code for Information Interchange
ASM	This stands for Automatic Storage Management
AWR	This stands for Automatic Workload Repository
AWS	This stands for Amazon Web Services
BI	This stands for business intelligence
BR	This stands for bounded recovery
CBO	This stands for cost-based optimizer
CDB	This stands for container database
CDC	This stands for changed data capture
CDD	This stands for Changed Data Delivery
CDR	This stands for Conflict Detection and Resolution
CLS	This stands for Command-level security
CRS	This stands for Cluster Ready Services
CSN	This stands...

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