Skip Headers

Table of Contents Image Oracle9i Advanced Replication
Release 2 (9.2)

Part Number A96567-01
Go To Documentation Library
Go To Product List
Book List
Go To Index

Master Index


Go to next page


Title and Copyright Information

Send Us Your Comments


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


Go to next page
Copyright © 1996, 2002 Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Go To Product List
Book List
Go To Index

Master Index