|
Donald
K. Burleson is one of the world’s top Oracle Database experts
with more than 20 years of full-time DBA experience. He
specializes in creating database architectures for very large
online databases and he has worked with some of the world’s
most powerful and complex systems.
A former Adjunct
Professor, Don Burleson has written 30 books, published more
than 100 articles in National Magazines, and serves as
Editor-in-Chief of Rampant TechPress. Don is a popular lecturer
and teacher and is a frequent speaker at Oracle Openworld and
other international database conferences.
Steve Karam
 |
Steve Karam is one of less than 20 DBA's
worldwide to achieve the coveted Oracle 10g Certified
Master status and the world's youngest OCM and
Oracle ACE. A former senior instructor for Oracle
University, Steve has a proven track record in
performance and troubleshooting on dozens of high
profile Oracle systems, and complex Oracle 10g RAC
environments.
 |
Additionally, Steve has been developing against
Oracle databases for ten years in a variety of
platforms including PHP, Java, and Application
Express. |
He is
also a known speaker on both DBA and development
concepts and has presented at Oracle OpenWorld and other
conferences. |
John Garmany |
John Garmany is a
Senior Oracle DBA with Burleson Consulting. 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
SearchOracle and SELECT Magazine.
John is also the author of four bestselling Oracle books by
Rampant TechPress, Oracle Press and CRC Press and hosts a
popular Oracle Application Server Newsletter.
|
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
|
Errata:
Page 46
At the beginning of the book mention following
unless otherwise mentioned
"local" is the master site where base table is and "remote" is to
where table is replicated to. eg. whether "remote" is replicated
in "local" or vice versa. eg. Page 46 ch2 begin
Page 52
In the third example near the middle of
the page
Create
materialized view log on employee
tablespace users
with ROWID PRIMAY KEY;
This
should be:
Create
materialized view log on employee
tablespace users
with ROWID PRIMARY KEY;
PRIMARY
KEY is listed as PRIMAY KEY and shouldn't be represented as such
Page 57
sub-topic does not related to what it contains
Page 67
In the 10gR2
PL/SQL packages documentation we see:
"If you set
list_of_gnames to NULL, then the user is registered for all
replication groups, even replication groups that are not yet
known when this procedure is called. You must use named
notation in order to set list_of_gnames to NULL."
The repproxy user
should be able to see and use OPLINC_MASTER_REPage ROUP.
create_snap_proxy.sql
create user repproxy
identified by repproxy;
alter user repproxy default tablespace users;
alter user repproxy temporary tablespace temp;
grant create session to repproxy;
grant select any table to repproxy;
--
--
BEGIN
dbms_repcat_admin.register_user_rePage roup(
username => 'repproxy',
privilege_type => 'proxy_snapadmin',
list_of_gnames => NULL);
Page 84-105
subtopic(even footer) is "Ora8i or lower". Obvious questions comes
up what about "Ora9i" ?
Page 130
3/4para : job_queue_processes : is this noof processes or wake up
interval in seconds ?
typo : tip :
job_queue_processes
Page 131-134
para and Page
137-2/3/4para : some level of repetition
Page 142
Typo : 2nd script starting with "cat ..." : should be "xargs"
(replace e with s)
Page 162
Typo : 3rd row from bottom : "execute any"
Page 163
cmd set to create repprop does not have "grant execute any
procedure" as mentioned in Page 160/161
Page 164
last sentence : not in appendix
Page 168
Contrary to the text, there is a way to create Push/Purge
jobs.
In the Distribution->Advanced Replication->Schedule->Push
tab,
if the Push job for a database link is not scheduled, you can:
1. Highlight the database link and click Edit
2. Click the 'Periodic Push' radio button
3. Specify the start time, frequency etc
4. Click Ok
5. Click Apply
and this will create the push job.
Create a Purge job with a similar method.
Page 200
Top cannot understand text inside bold section square. does not
make sense. may be wrong context; may be it should come to Page 206
Page 201
2nd para from bottom : last sentence <== something wrong
Hear
what people are saying:
Jim
from Pittsburgh, PA says:
This is a great reference for Oracle replication and does
an excellent job of explaining the issues, especially
multimaster replication. I have Freemans's Oracle new features
book also, and I enjoy the style and cadence of the writing
style. The text is not preachy and shows with clear examples all
of the ways to set up and use Oracle replication. I highly
recommend this book, and the price is great too!
By
John: This is a great reference for Oracle
replication and does an excellent job of explaining the issues,
especially multimaster replication. I have Freeman's Oracle new
features book also, and I enjoy the style and cadence of the
writing style. The text is not preachy and shows with clear
examples all of the ways to set up and use Oracle replication. I
highly recommend this book, and the price is great too.
|
