Home   FAQs   New Arrivals   Specials   Pricing & Shipping   Location   Corporate Services   Why Choose Bookware?  
 Search:   
Call our store: 9922 6266 (from within Sydney) or 1800 734 567 (from outside Sydney)
 View Cart   Check Out   
 
Browse by Subject
 Nepean TAFE 2012
I.T
 .NET
 Windows 7
 Adobe CS5
 Cisco
 CCNA 2012
 CCNP 2012
 Java
 VB
 ASP
 Web Design
 E-Commerce
 Project Management
 ITIL
 Macintosh
 Linux
 Windows Server 2008
 SAP
 Sharepoint 2010
Certification
 MCITP
 MCTS
Economics and Business
 Accounting
 Business Information Systems
 Economics
 Finance
 Management
 Marketing
 TAX
 Human Resources
Academic
 Law
 Nursing
 Medical

Oracle Replication: Snapshot, Multi-Master & Materialized View Scripts

by: John Garmany ; Robert Freeman

Notify me when in stock

On-line Price: $45.95 (includes GST)

Paperback package 208

15%Off Retail Price

You save: $8.00

Usually Ships in 7-10 working days from US.

Prices/avail can change...but we will always notify you first and get your approval.

Retail Price: $53.95

Publisher: ,2003/12/30

Category: ORACLE Level: I/A

ISBN: 0972751335
ISBN13: 9780972751339

Add to Shopping Cart

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.


          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


    Colonel 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