PacktLib: Oracle GoldenGate 11g Implementer's guide

Oracle GoldenGate 11g Implementer's guide

Credits

Foreword

About the Author

About the Reviewers

www.PacktPub.com

Preface

Getting Started

What is GoldenGate?

Oracle GoldenGate evolution

Oracle GoldenGate solutions

Oracle GoldenGate technology overview

Oracle GoldenGate architecture

Supported platforms and databases

Oracle Goldengate topology

Design considerations

What to Replicate?

Summary

Installing and Preparing GoldenGate

Prerequisites

Software installation

Preparing the environment

Creating the initial configuration

Uninstalling GoldenGate from Linux/UNIX

Summary

Design Considerations

Replication methods

Networking

Non-functional requirements (NFRs)

Hardware considerations

Changed data management

Summary

Configuring Oracle GoldenGate

GoldenGate parameters

Configuring the Initial Load

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 the Manager process

Summary

Configuration Options

Using BATCHSQL

Data compression

Security features

Event Actions

Bi-directional configuration options

Heterogeneous environments

DDL replication

Summary

Configuring GoldenGate for HA

GoldenGate on RAC

GoldenGate on Exadata

Failover

Summary

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 data replication

Licensing

Summary

Managing Oracle GoldenGate

Command level security

Trail file management

Managing process startup

Managing TCP/IP errors

Reporting and statistics

Summary

Performance Tuning

Before tuning GoldenGate

Balancing the load across parallel process groups

Splitting large tables into row ranges across process groups

Configuring multiple parallel process groups

New releases

Tuning the network

Summary

Troubleshooting GoldenGate

Troubleshooting tips

Exception handling

Handling Oracle Sequences

Using LOGDUMP

Upgrading GoldenGate

Summary

GGSCI Commands

GoldenGate Installed Components

The Future of Oracle GoldenGate