Contents

Title and Copyright Information

Send Us Your Comments

Preface

Audience

Organization

Related Documentation

Conv entions

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

Subsetti ng with Streams

Capture and Streams Replicati on

Change Capture Using a Capture Process

< dd class="H2TOC">Change Capture Using a Custom Application

Propagation and Streams Replication

LCR Staging

LCR Propagation

< dd class="H1TOC">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

< a href="gen_rep.htm#1008985">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< /a>

Overview of Instantiation and Stream s Replication

Capture Process Rules and Prepar ation for Instantiation

DBMS_STREAMS_ADM Package Pro cedures Automatically Prepare Objects

When Preparing for Instantiation Is Re quired

Oracle Data Pump and Streams Instantia tion

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 St reams Environment

Conflicts and Transaction Ordering in a Streams Environment

Conflict De tection in a Streams Environment

Control Over Confl ict Detection for Nonkey Columns

Rows Identification During Conflict Detect ion in a Streams Environment

Conflict Avoida nce 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 a n Apply Process

Streams Tags in a Replication Environment

Each Databases Is a Source and Destina tion Database for Shared Data

Primary Database Sharing Data with Several Se condary Databases

Primary Database Sharing Data with Several Extended Secon dary 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 Ora cle 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-Orac le 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 Singl e Source Environment

Creating a New Streams M ultiple Source Environment

Configuring Populated Da tabases When Creating a Multiple Source Environment

Adding Shared Objects t o Import Databases When Creating a New Environment

Complete the Multiple So urce Environment Configuration

Adding Shared Objects to an Existing Multiple Source Environment

Configuring Populated Databases When Adding Shared Objects

Adding Shared O bjects to Import Databases in an Existing Environment

Complete the Adding O bjects 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

Creati ng an Apply Process That Applies LCRs

Managing the Substitute Key Columns f or a Table

Managing a DML Handler

Managing the DDL Handler for an Apply Process

Managing Str eams Conflict Detection and Resolution

Repli cating 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 Multipl e Source Environment

Performing Database Poin t-in-Time Recovery in a Streams Environment

Perform ing Point-in-Time Recovery on the Source in a Single Source Environment

Per forming 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< /strong>

Instantiating Objects in a Streams Environment Using Da ta Pump Export/Import

Instantiating Objects in a Streams Environment Using Transportable Tablespaces

Instantiating Objects in a Streams Environment Us ing Original Export/Import

Instantiating an Entire Database in a Streams En vironment Using RMAN

Setting Instantiation S CNs at a Destination Database

Setting Instantiation SCNs Using Export/Import

Setting Instantiation SCNs Using the DBMS_APPLY_A DM Package

9 Ma naging Logical Change Records (LCRs)

Requirements for Managing LCRs

Const ructing and Enqueuing LCRs

Managing LCRs Cont aining LONG, LONG RAW, or LOB Columns

Requirements for Processing LCRs Containing LONG and LONG RAW Columns

Requirements for C onstructing and Processing LCRs Containing LOB Columns

Apply Process Behavi or for LCRs Containing LOBs

Example Script for Constructing and Enqueuing L CRs Containing LOBs

10 Monitoring Streams Replication

Monitoring Supplemental Logging

Displaying Supplemental Log Groups at a Source Database

Displaying Database Supplementa l Logging Specifications

Monitoring an Apply Process in a Streams Replication Environment

Display ing the Substitute Key Columns Specified at a Destination Database

Displayin g Information About DML and DDL Handlers

Displaying Information About Confli ct Detection

Displaying Information About Update Conflict Handlers

< /dl>

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

D isplaying Performance Statistics For Propagations That Receive Captured Events

Viewing the Apply Processes Dequeuing LCRs From Each Buffered Queue

Monitoring Streams Tags

Di splaying the Tag Value for the Current Session

Displaying the Default Tag Va lue for Each Apply Process

Monitoring Instant iation

Determining Which Database Objects Are Prepar ed for Instantiation

Determining the Tables for Which an Instantiation SCN H as Been Set

Running Flashback Queries in a St reams 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 Par ameter

ORA-23607 Invalid Column

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

ORA-26687 Instantiation SCN Not Set

ORA-26688 Missin g Key in LCR

ORA-26689 Column Type Mismatch

Part III Example Replication Environments

12 Simple Single Source Repl ication 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 Exampl e

Prerequisites

Part IV Appendixes

A Migrating Advanced Replication to Streams< /a>

Overview of the Migration Process

Migration Script Generation and Use

Modification of the Migration Script

Actions Performed by the Generated Script

Migration Script Errors

< dd class="H2TOC">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 S cript

Recreating Master Sites to Retain Mater ialized View Groups

I ndex