Skip Headers

Oracle® Streams Replication Administrator's Guide
10g Release 1 (10.1)

Part Number B10728-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to next page
Next
View PDF

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