||Oracle Replication Tips by Burleson
Monitoring with Oracle Enterprise Manager
OEM has become a powerful tool, and where it really shines is in
monitoring replication. If you sign on as REPADMIN
and navigate down to the Advanced Replication Administration folder, OEM
displays a graphic of the replication scheme, identifying sites with
errors and sites currently propagating transactions (Figure 6.13). You
will quickly learn the different icons, but until you do, click on the
Legend button for a listing.
In Figure 6.13
you can see that the database link is active and that no master site
currently has transactions in the error queue. You can also see
that the MYDB.WORLD master site supports 2 tables, replicating to
another site as materialized views.
This one quick view gives you a detailed report of your replication
status. The only detail lacking is the state of the replication
jobs at each site. If a job is broken, transactions will build up
in the deferred transaction queue, but they will not generate
errors. For that reason, you need to implement a script like the
ones detailed in Chapter 5 to monitor jobs at each master site.
OEM Replication Administration
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.