Oracle8i Replication

Overview of the Oracle8i Replication Manual

Audience

Knowledge Assumed of the Reader

How The Oracle8i Replication Manual Is Organized

Conventions Used in This Manual

Special Notes

Text of the Manual

Code Examples

Your Comments Are Welcome

What Is Replication?

Replication Objects, Groups, and Sites

Multimaster Replication

Uses for Multimaster Replication

Snapshot Replication

Read-only Snapshots

Updateable Snapshots

Uses of Snapshot Replication

Multimaster and Snapshot Hybrid Configurations

Administering a Replicated Environment

Replication Catalog

Replication Management API and Administration Requests

Oracle Replication Manager

Replication Conflicts

Specialized Replication Options

Oracle's Multimaster Replication Architecture

Row-Level Replication

Generated Replication Objects

Asynchronous (Store-and-Forward) Data Propagation

Serial Propagation

Parallel Propagation

Purging of the Deferred Transaction Queue

Replication Administrators, Propagators, and Receivers

Quick Start: Building a Multimaster Replication Environment

A Simple Example

Preparing for Multimaster Replication

The Replication Setup Wizard

Starting SNP Background Processes

Managing Scheduled Links

Creating a Scheduled Link

Editing a Scheduled Link

Viewing the Status of a Scheduled Link

Deleting a Scheduled Link

Purging a Site's Deferred Transaction Queue

Specifying a Site's Purge Schedule

Manually Purging a Site's Deferred Transaction Queue

Managing Master Groups

Creating a Master Group

Deleting a Master Group

Suspending Replication Activity for a Master Group

Resuming Replication Activity for a Master Group

Adding Objects to a Master Group

Altering Objects in a Master Group

Identifying Subset Columns

Removing Objects from a Master Group

Adding a Master Site to a Master Group

Removing a Master Site from a Master Group

Generating Replication Support for Master Group Objects

Viewing Information About Master Groups

Other Master Site Administration Issues

Advanced Multimaster Replication Options

Planning for Parallel Propagation

Understanding Replication Protection Mechanisms

Snapshot Concepts

What is a Snapshot?

Why use Snapshots?

Available Snapshots

Data Subsetting with Snapshots

Snapshot Architecture

Master Site Mechanisms

Snapshot Site Mechanisms

Organizational Mechanisms

Refresh Process

Prepare for Snapshots

Create Snapshot Site Users

Create Master Site Users

Schema

Database Link

Privileges

Schedule Purge at Master Site

Schedule Push

SNP Background Processes and Interval

Create a Snapshot Log

Using Filter Columns

Create Snapshot Environment

Replication Manager

Replication Management API

Mass Deployment Challenge

Deployment Goals

Oracle Deployment Templates Concepts

Deployment Template Elements

Package Deployment Template

Deployment Template Instantiation

Deployment Template Architecture

Template Definitions Stored in System Tables

Packaging Process

Instantiation Process

Post-Instantiation

Deployment Template Design

Horizontal Partitioning with Assignment Tables

Vertical Partitioning

Data Sets

Additional Design Considerations

Creating a Deployment Template

Overview

Create Template

Add Template Objects

Edit Template Objects

Add New Objects to Template

Template Parameters

Finish Deployment Template Wizard

Modifying a Deployment Template

Template Properties

Add Template Objects

Modify Existing Template Objects

Remove Template Objects

Deploying a Template

Package Template

Prepare Remote Snapshot Site for Instantiation

Remote Snapshot Site Instantiation

After Deployment

Local Control of Snapshot Creation

Overview

Setting Up Snapshot Site

Creating Snapshot Groups

Using a WHERE Clause

Using a Storage Clause

Managing Snapshot Groups

Editing a Snapshot Group

Regenerating Replication Support for an Updateable Snapshot

Deleting a Snapshot Group

Managing Individual Snapshots

Creating a Snapshot

Altering a Snapshot

Deleting a Snapshot

Managing Refresh Groups

Creating a Refresh Group

Adding Snapshots to a Refresh Group

Deleting Snapshots from a Refresh Group

Changing Refresh Settings for a Snapshot Group

Manually Refreshing a Group of Snapshots

Deleting a Refresh Group

Other Snapshot Site Administration Issues

Data Dictionary Views

Introduction to Replication Conflicts

Understanding Your Data and Application Requirements

Types of Replication Conflicts

Avoiding Conflicts

Conflict Detection at Master Sites

Conflict Resolution

Conflict Resolution Methods

Overview of Conflict Resolution Configuration

Design and Preparation Guidelines for Conflict Resolution

Implementing Conflict Resolution

Configuring Update Conflict Resolution

Creating a Column Group

Adding and Removing Columns in a Column Group

Dropping a Column Group

Managing a Group's Update Conflict Resolution Methods

Prebuilt Update Conflict Resolution Methods

Using Priority Groups for Update Conflict Resolution

Using Site Priority for Update Conflict Resolution

Sample Timestamp and Site Maintenance Trigger

Configuring Uniqueness Conflict Resolution

Assigning a Uniqueness Conflict Resolution Method

Removing a Uniqueness Conflict Resolution Method

Prebuilt Uniqueness Resolution Methods

Configuring Delete Conflict Resolution

Assigning a Delete Conflict Resolution Method

Removing a Delete Conflict Resolution Method

Guaranteeing Data Convergence

Avoiding Ordering Conflicts

Minimizing Data Propagation for Update Conflict Resolution

Minimizing Communication Examples

Further Reducing Data Propagation

User-Defined Conflict Resolution Methods

Conflict Resolution Method Parameters

Resolving Update Conflicts

Resolving Uniqueness Conflicts

Resolving Delete Conflicts

Restrictions

Example User-Defined Conflict Resolution Method

User-Defined Conflict Notification Methods

Creating a Conflict Notification Log

Creating a Conflict Notification Package

Viewing Conflict Resolution Information

Advanced Management of Master and Snapshot Groups

Executing DDL Within a Master Group

Relocating a Master Group's Definition Site

Changing a Snapshot Group's Master Site

Monitoring an Advanced Replication System

Managing Administration Requests

Managing Deferred Transactions

Managing Error Transactions

Managing Local Jobs

Database Backup and Recovery in Replication Systems

Performing Checks on Imported Data

Auditing Successful Conflict Resolution

Gathering Conflict Resolution Statistics

Viewing Conflict Resolution Statistics

Canceling Conflict Resolution Statistics

Deleting Statistics Information

Determining Differences Between Replicated Tables

DIFFERENCES

RECTIFY

Managing Snapshot Logs

Troubleshooting Common Problems

Diagnosing Problems with Database Links

Diagnosing Problems with Master Sites

Diagnosing Problems with the Deferred Transaction Queue

Diagnosing Problems with Snapshots

Updating The Comments Fields in Views

Using Procedural Replication

Restrictions on Procedural Replication

Serialization of Transactions

Generating Support for Replicated Procedures

Using Synchronous Data Propagation

Understanding Synchronous Data Propagation

Adding New Sites to an Advanced Replication Environment

Altering a Master Site's Data Propagation Mode

Designing for Survivability

Oracle Parallel Server versus Advanced Replication

Designing for Survivability

Implementing a Survivable System

Snapshot Cloning and Offline Instantiation

Snapshot Cloning for Basic Replication Environments

Offline Instantiation of a Master Site in an Advanced Replication System

Offline Instantiation of a Snapshot Site in an Advanced Replication System

Security Setup for Multimaster Replication

Trusted vs. Untrusted Security

Security Setup for Snapshot Replication

Trusted vs. Untrusted Security

Avoiding Delete Conflicts

Using Dynamic Ownership Conflict Avoidance

Workflow

Token Passing

Locating the Owner of a Row

Obtaining Ownership

Applying the Change

Modifying Tables without Replicating the Modifications

Disabling the Advanced Replication Facility

Re-enabling the Advanced Replication Facility

Triggers and Replication

Enabling/Disabling Replication for Snapshots

Listing Information about Deferred Transactions

Creating a Deferred Transaction

Security

Specifying a Destination

Initiating a Deferred Transaction

Deferring a Remote Procedure Call

Queuing a Parameter Value for a Deferred Call

Adding a Destination to the DEFDEFAULTDEST View

Removing a Destination from the DEFDEFAULTDEST View

Executing a Deferred Transaction

LOB Storage

DEFLOB View of Storage for RPC

Oracle8 -- New Features

Performance Enhancements

Data Subsetting Based on Subqueries

Large Object Datatypes (LOBs) Support

Improved Management and Ease of Use

Enhanced, System-Based Security Model

New Replication Manager Features

Oracle8i -- New Features

Performance Improvements

Improved Mass Deployment Support

Improved Security

Replication Manager

Migration Overview

Migrating All Sites at Once

Incremental Migration

Preparing Oracle7 Master Sites for Incremental Migration

Incremental Migration of Snapshot Sites

Incremental Migration of Master Sites

Migration Using Export/ Import

Upgrading to Primary Key Snapshots

Primary Key Snapshots Conversion at Master Site(s)

Primary Key Snapshot Conversion at Snapshot Site(s)

Features Requiring Migration to Oracle8/Oracle8i

Obsolete procedures

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Understanding Replication

2 Using Multimaster Replication

3 Snapshot Concepts & Architecture

4 Creating Snapshots with Deployment Templates

5 Directly Create Snapshot Environment

6 Conflict Resolution

7 Administering a Replicated Environment

8 Advanced Techniques

9 Using Deferred Transactions

A New Features

B Migration and Compatibility

Index