Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conventions

Documentation Accessibility

Part I Streams Replication Concepts

1 Understanding Streams Replication

Overview of Streams Replication

Rules in a Streams Replication Environment

Non-Identical Replicas with Streams

Subsetting with Streams

Capture and Streams Replication

Change Capture Using a Capture Process

Change Capture Using a Custom Application

Propagation and Streams Replication

LCR Staging

LCR Propagation

Apply and Streams Replication

Overview of the Apply Process

Apply Processing Options for LCRs

Considerations for Applying DML Changes to Tables

Considerations for Applying DDL Changes

Instantiation SCN and Ignore SCN for an Apply Process

The Oldest SCN for an Apply Process

Low-Watermark and High-Watermark for an Apply Process

Trigger Firing Property

2 Instantiation and Streams Replication

Overview of Instantiation and Streams Replication

Capture Process Rules and Preparation for Instantiation

DBMS_STREAMS_ADM Package Procedures Automatically Prepare Objects

When Preparing for Instantiation Is Required

Oracle Data Pump and Streams Instantiation

Data Pump Export and Object Consistency

Oracle Data Pump Import and Streams Instantiation

Original Export/Import and Streams Instantiation

The OBJECT_CONSISTENT Export Utility Parameter and Streams

Original Import Utility Parameters Relevant to Streams

3 Streams Conflict Resolution

About DML Conflicts in a Streams Environment

Conflict Types in a Streams Environment

Update Conflicts in a Streams Environment

Uniqueness Conflicts in a Streams Environment

Delete Conflicts in a Streams Environment

Foreign Key Conflicts in a Streams Environment

Conflicts and Transaction Ordering in a Streams Environment

Conflict Detection in a Streams Environment

Control Over Conflict Detection for Nonkey Columns

Rows Identification During Conflict Detection in a Streams Environment

Conflict Avoidance in a Streams Environment

Use a Primary Database Ownership Model

Avoid Specific Types of Conflicts

Conflict Resolution in a Streams Environment

Prebuilt Update Conflict Handlers

Custom Conflict Handlers

4 Streams Tags

Introduction to Tags

Tags and Rules Created by the DBMS_STREAMS_ADM Package

Tags and Online Backup Statements

Tags and an Apply Process

Streams Tags in a Replication Environment

Each Databases Is a Source and Destination Database for Shared Data

Primary Database Sharing Data with Several Secondary Databases

Primary Database Sharing Data with Several Extended Secondary Databases

5 Streams Heterogeneous Information Sharing

Oracle to Non-Oracle Data Sharing with Streams

Change Capture and Staging in an Oracle to Non-Oracle Environment

Change Apply in an Oracle to Non-Oracle Environment

Transformations in an Oracle to Non-Oracle Environment

Messaging Gateway and Streams

Error Handling in an Oracle to Non-Oracle Environment

Example Oracle to Non-Oracle Streams Environment

Non-Oracle to Oracle Data Sharing with Streams

Change Capture and Staging in a Non-Oracle to Oracle Environment

Change Apply in a Non-Oracle to Oracle Environment

Instantiation from a Non-Oracle Database to an Oracle Database

Non-Oracle to Non-Oracle Data Sharing with Streams

Part II Configuring and Administering Streams Replication

6 Configuring Streams Replication

Creating a New Streams Single Source Environment

Adding Shared Objects to an Existing Single Source Environment

Adding a New Destination Database to a Single Source Environment

Creating a New Streams Multiple Source Environment

Configuring Populated Databases When Creating a Multiple Source Environment

Adding Shared Objects to Import Databases When Creating a New Environment

Complete the Multiple Source Environment Configuration

Adding Shared Objects to an Existing Multiple Source Environment

Configuring Populated Databases When Adding Shared Objects

Adding Shared Objects to Import Databases in an Existing Environment

Complete the Adding Objects to a Multiple Source Environment Configuration

Adding a New Database to an Existing Multiple Source Environment

Configuring Databases If the Shared Objects Already Exist at the New Database

Adding Shared Objects to a New Database

7 Managing Capture, Propagation, and Apply

Managing Capture for Streams Replication

Creating a Capture Process

Managing Supplemental Logging in a Streams Replication Environment

Managing Staging and Propagation for Streams Replication

Creating a SYS.AnyData Queue to Stage LCRs

Creating a Propagation That Propagates LCRs

Managing Apply for Streams Replication

Creating an Apply Process That Applies LCRs

Managing the Substitute Key Columns for a Table

Managing a DML Handler

Managing the DDL Handler for an Apply Process

Managing Streams Conflict Detection and Resolution

Replicating and Maintaining Tablespaces Using Streams

Managing Streams Tags

Managing Streams Tags for the Current Session

Managing Streams Tags for an Apply Process

Changing the DBID or Global Name of a Source Database

Resynchronizing a Source Database in a Multiple Source Environment

Performing Database Point-in-Time Recovery in a Streams Environment

Performing Point-in-Time Recovery on the Source in a Single Source Environment

Performing Point-in-Time Recovery in a Multiple Source Environment

Performing Point-in-Time Recovery on a Destination Database

8 Performing Instantiations

Preparing Database Objects for Instantiation at a Source Database

Aborting Preparation for Instantiation at a Source Database

Instantiating Objects in a Streams Replication Environment

Instantiating Objects in a Streams Environment Using Data Pump Export/Import

Instantiating Objects in a Streams Environment Using Transportable Tablespaces

Instantiating Objects in a Streams Environment Using Original Export/Import

Instantiating an Entire Database in a Streams Environment Using RMAN

Setting Instantiation SCNs at a Destination Database

Setting Instantiation SCNs Using Export/Import

Setting Instantiation SCNs Using the DBMS_APPLY_ADM Package

9 Managing Logical Change Records (LCRs)

Requirements for Managing LCRs

Constructing and Enqueuing LCRs

Managing LCRs Containing LONG, LONG RAW, or LOB Columns

Requirements for Processing LCRs Containing LONG and LONG RAW Columns

Requirements for Constructing and Processing LCRs Containing LOB Columns

Apply Process Behavior for LCRs Containing LOBs

Example Script for Constructing and Enqueuing LCRs Containing LOBs

10 Monitoring Streams Replication

Monitoring Supplemental Logging

Displaying Supplemental Log Groups at a Source Database

Displaying Database Supplemental Logging Specifications

Monitoring an Apply Process in a Streams Replication Environment

Displaying the Substitute Key Columns Specified at a Destination Database

Displaying Information About DML and DDL Handlers

Displaying Information About Conflict Detection

Displaying Information About Update Conflict Handlers

Monitoring Buffered Queues

Determining the Number of LCRs in Each Buffered Queue

Viewing the Capture Processes For the LCRs in Each Buffered Queue

Displaying General Information About Propagations That Send Captured Events

Displaying the Number of Events and Bytes Sent By Propagations

Displaying Performance Statistics For Propagations That Send Captured Events

Viewing the Propagations Dequeuing LCRs From Each Buffered Queue

Displaying Performance Statistics For Propagations That Receive Captured Events

Viewing the Apply Processes Dequeuing LCRs From Each Buffered Queue

Monitoring Streams Tags

Displaying the Tag Value for the Current Session

Displaying the Default Tag Value for Each Apply Process

Monitoring Instantiation

Determining Which Database Objects Are Prepared for Instantiation

Determining the Tables for Which an Instantiation SCN Has Been Set

Running Flashback Queries in a Streams Replication Environment

11 Troubleshooting Streams Replication

Is the Apply Process Encountering Contention?

Is the Apply Process Waiting for a Dependent Transaction?

Is an Apply Server Performing Poorly for Certain Transactions?

Are There Any Apply Errors in the Error Queue?

ORA-01031 Insufficient Privileges

ORA-01403 No Data Found

ORA-23605 Invalid Value for Streams Parameter

ORA-23607 Invalid Column

ORA-24031 Invalid Value, parameter_name Should Be Non-NULL

ORA-26687 Instantiation SCN Not Set

ORA-26688 Missing Key in LCR

ORA-26689 Column Type Mismatch

Part III Example Replication Environments

12 Simple Single Source Replication Example

Overview of the Simple Single Source Replication Example

Prerequisites

13 Single Source Heterogeneous Replication Example

Overview of the Single Source Heterogeneous Replication Example

Prerequisites

Add Objects to an Existing Streams Replication Environment

Add a Database to an Existing Streams Replication Environment

14 Multiple Source Replication Example

Overview of the Multiple Source Databases Example

Prerequisites

Part IV Appendixes

A Migrating Advanced Replication to Streams

Overview of the Migration Process

Migration Script Generation and Use

Modification of the Migration Script

Actions Performed by the Generated Script

Migration Script Errors

Manual Migration of Updatable Materialized Views

Advanced Replication Elements That Cannot Be Migrated to Streams

Preparing to Generate the Migration Script

Generating and Modifying the Migration Script

Example Advanced Replication Environment to be Migrated to Streams

Performing the Migration for Advanced Replication to Streams

Before Executing the Migration Script

Executing the Migration Script

After Executing the Script

Recreating Master Sites to Retain Materialized View Groups

Index