Oracle8i Replication
Release 8.1.5







Title and Copyright Information

Send Us Your Comments


Overview of the Oracle8i Replication Manual
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

1 Understanding Replication

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

2 Using Multimaster Replication

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

3 Snapshot Concepts & Architecture

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
Database Link
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

4 Creating Snapshots with Deployment Templates

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
Deployment Template Design
Horizontal Partitioning with Assignment Tables
Vertical Partitioning
Data Sets
Additional Design Considerations
Creating a Deployment Template
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
Template Parameters
Copy Template
Compare Template
Remove Template
Deploying a Template
Package Template
Prepare Remote Snapshot Site for Instantiation
Remote Snapshot Site Instantiation
After Deployment
Local Control of Snapshot Creation

5 Directly Create Snapshot Environment

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

6 Conflict Resolution

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
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

7 Administering a Replicated Environment

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
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

8 Advanced Techniques

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
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

9 Using Deferred Transactions

Listing Information about Deferred Transactions
Creating a Deferred Transaction
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

A New Features

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

B Migration and Compatibility

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


Copyright © 1999 Oracle Corporation.

All Rights Reserved.