Oracle Replication: Snapshot, Multi-master & Materialized Views Scripts

Description:

This book is an indispensable reference for any Oracle DBA who must ensure the consistency of data across distributed platforms. With the advent of cheap disk and fast worldwide connectivity, many Oracle professionals recognize the benefits of distributing Oracle data. However, Oracle multi-master replication is extremely complex and time-consuming to implant. This book addresses the complexity of Oracle replication by providing working code examples and illustration from working systems. The text covers all areas of Oracle replication, including snapshots, using dbms_job to refresh snapshots, multi-master replication and conflict resolution mechanisms.

Written by a distinguished graduate of West Point, Col. Garmany leverages his 20+ years of experience into an indispensable guide for any Oracle professional who must quickly implement Oracle snapshot and multimaster replication. A noted instructor, author and lecturer, Col. John Garmany leverages his ability to explain complex issues in Plain English into a one-of-a-kind book.

This handy reference contain working examples of snapshot and multimaster replication to allow you to get started quickly with your Oracle replication structure. Packed with useful notes and an online code deport, this reference show every aspect of Oracle snapshot replication including syntax for refresh intervals, managing snapshot logs, monitoring Oracle replication refresh timings and much more.

Best of all, this is the only book that describes the intricacies of Oracle multimaster replication and provides working code examples of complex multimaster replication. Includes a section on Oracle replication tuning and monitoring, this is a must-have book for all Oracle professionals who replicate their data.

Table of Contents:

Chapter 1: Introduction to the Oracle Replication Architecture   

The Oracle Replication Architecture  
Database links
Basics of distributed updates
Inside the two-phase commit
Basics of Snapshot and Multi-master Replication  
Manual Replication techniques  
 
Chapter 2: Installing Oracle Advanced Replication  

Overview of the replication packages
Checklist for installing advanced replication
   Creating the users
   Setting Oracle parameters
   Creating database links
   Managing replication security
   Testing replication

Chapter 3: Basic read-only Replication with snapshots  

Read-Only Snapshot architecture
Restrictions of read-only snapshots  
Snapshot Creation Basics  
Setting the refresh interval
Complex Snapshot creation  
Creating and managing snapshot logs  
Subquery Sub-setting in snapshots  
Refresh Groups for snapshots
 
Chapter 4: Using Oracle Updateable Snapshots  

Background in updateable snapshots  
Defining Updateable Snapshots  
Defining refresh intervals  

Chapter 5: Using Updateable Materialized Views
 
Defining updatable materialized views
 
Chapter 6: Monitoring Oracle Replication with Scripts

Goals of monitoring replication
Scripts to measure pending updates
Auto-correct script for broken snapshots

Chapter 7: Using Oracle Procedural Replication  

Introduction to procedural replication
Installing the replication packages  
Restrictions on Procedural Replication 
 
Chapter 8: Oracle Multi-Master Replication  

Background on multi-master replication
Restriction & limitations of multi-master replication
Using the Oracle-supplied packages
Defining Replication Groups  
Defining the master site
Defining propagation rules  
Using  the dbms_repcat package
Replication of data definitions (DDL)  
 
Chapter 9: Conflict Avoidance in multi-master replication  

The causes of data conflicts
The options for conflict resolution
Using Referential Integrity with multi-master replication
Techniques to avoid data conflicts
Implementing an automated conflict avoidance mechanism
Manual intervention and conflict detection