Contents

Title and Copyright Information

Send Us Your Comments

Preface

What's New in Advanced Replication?

1 Introduction to Advanced Replication

Replication Overview

Applications That Use Replication

Replication Objects, Groups, and Sites

Replication Objects

Replication Groups

Replication Sites

Types of Replication Environments

Multimaster Replication

Materialized View Replication

Multimaster and Materialized View Hybrid Configurations

Administration Tools for a Replication Environment

Replication Management Tool in Oracle Enterprise Manager

Replication Management API

Replication Catalog

Distributed Schema Management

Replication Conflicts

Other Options for Multimaster Replication

Synchronous Replication

Procedural Replication

2 Master Replication Concepts and Architecture

Master Replication Concepts

What is Master Replication?

Why Use Multimaster Replication?

Multimaster Replication Process

Conflict Resolution Concepts

Replication of User-Defined Types

Master Replication Architecture

Master Site Mechanisms

Administrative Mechanisms

Organizational Mechanisms

Propagation Mechanism

Performance Mechanisms

Replication Protection Mechanisms

Conflict Resolution Mechanisms

3 Materialized View Concepts and Architecture

Materialized View Concepts

What is a Materialized View?

Why Use Materialized Views?

Read-Only, Updatable, and Writeable Materialized Views

Available Materialized Views

Required Privileges for Materialized View Operations

Data Subsetting with Materialized Views

Determining the Fast Refresh Capabilities of a Materialized View

Multitier Materialized Views

Materialized Views with User-Defined Types

Materialized View Registration at a Master Site or Master Materialized View Site

Materialized View Architecture

Master Site and Master Materialized View Site Mechanisms

Materialized View Site Mechanisms

Organizational Mechanisms

Refresh Process

4 Deployment Templates Concepts and Architecture

Mass Deployment Challenge

Deployment Templates and the Mass Deployment Goal

Oracle Deployment Templates Concepts

Deployment Template Elements

Deployment Template Packaging and Instantiation

Deployment Template Architecture

Template Definitions Stored in System Tables

Packaging and Instantiation Process

After Instantiation

Deployment Template Design

Column Subsetting with Deployment Templates

Row Subsetting

Data Sets

Additional Design Considerations

Local Control of Materialized View Creation

5 Conflict Resolution Concepts and Architecture

Conflict Resolution Concepts

Understanding Your Data and Application Requirements

Types of Replication Conflicts

Conflict Detection

Conflict Resolution

Techniques for Avoiding Conflicts

Conflict Resolution Architecture

Support Mechanisms

Common Update Conflict Resolution Methods

Additional Update Conflicts Resolution Methods

Uniqueness Conflicts Resolution Methods

Delete Conflict Resolution Methods

Performance Mechanisms and Conflict Resolution

6 Planning Your Replication Environment

Considerations for Replicated Tables

Primary Keys

Foreign Keys

Datatype Considerations

Row-Level Dependency Tracking

Initialization Parameters

Master Sites and Materialized View Sites

Advantages of Master Sites

Advantages of Materialized View Sites

Preparing for Materialized Views

Creating a Materialized View Log

Creating a Materialized View Environment

Avoiding Problems When Adding a New Materialized View Site

Guidelines for Scheduled Links

Scheduling Periodic Pushes

Scheduling Continuous Pushes

Guidelines for Scheduled Purges of a Deferred Transaction Queue

Scheduling Periodic Purges

Scheduling Continuous Purges

Serial and Parallel Propagation

Deployment Templates

Preparing Materialized View Sites for Instantiation of Deployment Templates

Conflict Resolution

Security

Designing for Survivability

Oracle Real Application Clusters versus Replication

Designing a Replication Environment for Survivability

Implementing a Survivable System

7 Replication Management Tool Introduction

Usage Scenarios for the Replication Management Tool

Logging in to the Replication Management Tool

The Replication Management Tool Interface

Navigator Pane

Right Pane

The Replication Management Tool Wizards

Setup Wizard

Materialized View Group Wizard

Deployment Template Wizard

Template Script Generation Wizard

Copy Template Wizard

Flowchart for Creating a Replication Environment

A Troubleshooting Replication Problems

Diagnosing Problems with Database Links

Diagnosing Problems with Master Sites

Replicated Objects Not Created at New Master Site

DDL Changes Not Propagated to Master Site

DML Changes Not Asynchronously Propagated to Other Sites

DML Cannot be Applied to Replicated Table

Bulk Updates and Constraint Violations

Recreating a Replicated Object

Unable to Generate Replication Support for a Table

Problems with Replicated Procedures or Triggers

Problems With ON DELETE CASCADE and Integrity Constraints

Diagnosing Problems with the Deferred Transaction Queue

Check Jobs for Scheduled Links

Distributed Transaction Problems with Synchronous Replication

Incomplete Database Link Specifications

Incorrect Replication Catalog Views

Diagnosing Problems with Materialized Views

Problems Creating Replicated Objects at Materialized View Site

Problems Performing Offline Instantiation of a Deployment Template

Refresh Problems

Advanced Troubleshooting of Refresh Problems

B Column Length Semantics and Unicode

Column Length Semantics for Replication Sites and Table Columns

Multimaster Support for Column Length Semantics

Column Length Semantics Support for Tables Generated by Advanced Replication

Column Length Semantics Support for Precreated Tables

Materialized View Support for Column Length Semantics

Materialized Views with Prebuilt Container Tables

Column Length Semantics Support for Updatable Materialized Views

DDL Propagation and Column Length Semantics

Replication Support for Unicode

Replication of NCLOB Datatype Columns

Index