||Oracle Replication Tips by
Oracle Multi-Master Replication Tips
We have discussed the basics of setting up and administrating a simple
replication scheme, as well as some additional items that need to be
considered when planning a multi-master
scheme, such as the trusted and untrusted security models. Some of the
main points included:
Plan your implementation in detail. Anticipate how you are
going to move the possibly
large amounts of data to remote master sites.
Build the replication and then test it thoroughly.
Develop a system to constantly monitor the replication status.
That about covers the basics of multi-master
replication. Your master sites should be happily replicating
transactions back and forth. But you are still not quite finished.
No matter how simple your replication scheme may be,
if it involves advanced replication, you should implement methods to
resolve key conflicts. And that is what we will cover in the next
Chapter 7 will discuss the causes of key conflicts and the available
methods to automatically resolve them.
This is an
excerpt from Oracle Replication By Rampant TechPress (only $19.95).
You can click here to order a copy and get instant access to the code
Get a Personal Oracle
The author is now offering personal mentors for
Oracle DBAs where you can have an Oracle expert right at your
fingertips, anytime day or night. We work with hundreds of Oracle
databases every year, so we know exactly how to quickly assist you
with any Oracle replication question.
You can get me personally, or any Oracle Certified replication DBA
with more than 20 years of full-time IT experience.