2 Master Replication Concepts and Architecture< /h3>

Master Replication Concepts

What is Master Replication?

Why Use Multimaster Replication?

Multimaster Replication Pr ocess

Conflict Resolution Concepts

How Replication Works with Object Types and Collections

Master Replication Architecture

Master Site Mechanisms

Administrative Mechanisms

Organizational Mechanisms

Propagation Mechanis m

Performance Mechanisms

Replication Protection Mechanisms

Conflict Resolution Mechanisms

3 Materialized View Conce pts and Architecture

Materiali zed View Concepts

What is a Materialized View?

Why Use Materialized Views?

Read-Only, Updatable, and Writeable Materialized Views

Available Materialize d Views

Required Privileges for Materialized View Operations

Data Subsetting with Materialized Views

Determining the Fast Refresh Capabilities of a Materialized View

Multitier Materialized Views

How Materialized Views Work with Object Types and Collect ions

Materialized View Registration at a Master Site or Master Materialized V iew 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 Arc hitecture

Mass Deployment Challen ge

Deployment Templates and the Mass Deployment Goal

Oracle Deployment Templates Concepts < dl class="H2TOC">
Deployment Template Elements

Deployment Template Packaging and Instantiation

Deployment Template Architecture

Template Defi nitions 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 Reso lution Concepts and Architecture

Conflict Resolution Concepts

Understanding Your Da ta and Application Requirements

Types of Replication Conflicts

Conflict Detection

Conflict Resolut ion

Techniques for Avoiding Conflicts

~~Conflict Resolution Architecture~~

< a href="repconfl.htm#23859">Support Mechanisms

Common Update Conflict Resolut ion Methods

Additional Update Conflicts Resolution Methods

Uniqueness Conflicts Resolution Methods

Delete Conflict Resolution Methods

Send and Compare Old Values

6 Planning Your Replication Env ironment

Considerations for Rep licated Tables

Primary Keys

Foreign Keys

Datatype Considerations

Row-Level Dependency Tracking

Initialization Parameters

Master Sites and Materialized View Sites

Advantage s of Master Sites

Advantages of Materialized View Sites

Preparing for Materialized Views

Creating a M aterialized View Log

Creating a Materialized View Environment

Avoiding Problems When Adding a New Materialized View Site

Interoperability in an Advanced Replication Environment

Guidelines for Scheduled Links

Scheduling Periodic Pushes

Scheduling Cont inuous Pushes

Guidelines for Scheduled Purges o f a Deferred Transaction Queue

Scheduling Periodic Pur ges

Scheduling Continuous Purges

Serial and Parallel Propagation

Deployment Templates

Preparin g Materialized View Sites for Instantiation of Deployment Templates

Conflict Resolution

Securit y

Designing for Survivability

Oracle Real Application Clusters versus Replication

Designing a Replication Environment for Survivability

Implementing a Survivable System

7 Introduction to the Replication Management Tool

Usage Scenarios for the Replication Management Tool

Logging into the Replication Management Tool

The Replication Management Tool Interface

Navigator Pane

Right Pane

The Replication Management Tool Wizards

Setup Wizard

Ma terialized View Group Wizard

Deployment Template Wizard

Template Script Generation Wizard

Copy Tem plate Wizard

Flowchart for Creating a Replicat ion Environment

A Troubleshooting Replication Problems

Diagnosing Problems with Database Links

Di agnosing Problems with Master Sites

Replicated Objects Not Created at New Master Site

DDL Changes Not Propagated to Master Site< /dd>
DML Changes Not Asynchronously Propagated to Other Sites

DML Cannot be Applied to Replicated Table

Bulk U pdates and Constraint Violations

Re-creating a Replicated Object

Unable to Generate Replication Support for a Table

Problems with Replicated Procedures or Triggers

Diagnosing Problems with the Deferred Transaction Queue

Check Jobs for Scheduled Links

Distributed Transaction Probl ems 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 an d Unicode

Column Length Semant ics for Replication Sites and Table Columns

Mul timaster Support for Column Length Semantics

Column L ength Semantics Support for Tables Generated by Advanced Replication

Column L ength Semantics Support for Precreated Tables

Materialized View Support for Column Length Semantics

Materialized Views with Prebuilt Container Tables

Column Length Semantics Su pport for Updatable Materialized Views

DDL Pro pagation and Column Length Semantics

Replicatio n Support for Unicode

Replication of NCLOB Datatype C olumns

Index