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

Key Features:

• Presents working syntax examples for all area of Oracle replication.

• Describes the architecture of Oracle multimaster replication in simple terms and provides illustrative examples.

• Shows working examples of snapshot creation, refresh, and error detection scripts.

• Details real-world techniques for implement conflict resolution in multi-master replication.

• Comes with an online code depot with working code examples.

About the Authors:

 

John Garmany		John Garmany is a graduate of West Point, an Airborne Ranger and a retired Lt. Colonel with 20+ years of IT experience. John is an OCP Certified Oracle DBA with a Master Degree in Information Systems, a Graduate Certificate in Software Engineering, and a BS degree (Electrical Engineering) from West Point.  A respected Oracle expert and author, John serves as a writer for Oracle Internals, DBAZine and Builder.com.  John is the author of "Logical Database Design - Principles & Practices" by CRC Press, the "Oracle9iAS Administration Handbook" by Oracle Press and "Oracle Replication - Snapshot, Multi-master & Materialized Views Scripts" and "Oracle SQL*Plus Reports - Fast reporting with SQL and SQL*Plus" by Rampant TechPress.
		Robert Freeman is one of the most famous Oracle experts and author of five popular Oracle books, including Oracle9i RMAN Backup & Recovery and the bestselling Oracle9i New Features book. A master of Martial Arts and a Black Belt in Karate, Freeman is an Oracle7 and Oracle8 Oracle Certified Professional with more than a decade of Oracle experience.  An exciting and dynamic speaker, Robert Freeman has taught extensively and is a popular speaker at Oracle conferences.

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