PacktLib: Oracle 11g Streams Implementer's Guide

Oracle 11g Streams Implementer's Guide

Credits

About the Authors

About the Reviewers

Preface

All the Pieces: The Parts of an Oracle 11g Streams Environment

Streams architecture overview

About those Queues

Capture process what are we supposed to stream?

Instantiation

Propagate process

Apply process

Combined Capture and Apply

SCN Coordination keeps it flowing smoothly

LCRs what they are and how they work

Oracle 11g memory and storage architecture (basic) relating to Streams

A word on performance

Streams Change tables

Oracle GoldenGate XSTREAMS

Summary

Plot Your Course: Design Considerations

Why?

What?

Where?

Who and How?

When and How?

Other factors to consider

Summary

Prepare the Rafts and Secure Your Gear: The pre-work before configuring Oracle 11g Streams

Network connectivity

Configure the database

Streams users and privileges

Understanding your Instantiation tools

Oracle Demo Schemas

Summary

Single-Source Configuration

The stream flows one way: Downhill

Summary

N-Way Replication

Pre-planning for N-way replication

Avoiding conflict

The setup

Conflict resolution

Extending the example

Rinse and repeat

Summary

Get Fancy with Streams Advanced Configurations

Synchronous Capture straight to the Queue

Subsetting — the micro side of replication

Tag! — you're it

RULES — they're what we live by

Downstream Capture — avoid white water at the source

Streams change tables — just tracking the "Facts" Ma'am

Automatic propagation split and merge — redirecting the current

Basic Heterogeneous Configuration

Basic XSTREAMS Configuration

Document What You Have and How It Is Working

Mapping the Stream

The Stream without a map

DBMS_STREAMS_ADVISOR_ADM

Basic Streams views

UTL_SPADV

Summary

Dealing with the Ever Constant Tides of Change

Affecting expected change effectively

Troubleshooting unexpected changes and resulting Streams errors

Summary

Appendix and Glossary

Oracle Streams Commander

Streams and Oracle RAC

Oracle GoldenGate

Glossary

Summary