Oracle Replication Tips by Burleson

Oracle OEM Replication


Figure 4.19  Saving the Wizard Produced Script

Replication is now functioning.  To test, simply add or change data in the UMV, and after the refresh interval, verify that the data was replicated to the master table.

OEM provides an Advanced Replication Administration section.  Under Advanced Replication, select the Administration tab.  This will display a topography page that provides a graphic depiction of the replication and also shows errors, if present, in red in the DEFERROR queue.

Figure 4.20  Advanced Replication Administration Page

This shows that the Materialized Views are on mydb and that they are replicating with navdb.  In UMV, replication errors will normally be generated at the master site and will be shown in red. 

In the upper right, you will find the DBMS Jobs tab.  This is the only place OEM displays jobs and the only place you are allowed to change them.  Since UMV replication requires jobs to function, you can use this section to verify and maintain the replication jobs (Figure 4.21).

 
Figure 4.21 OEM dbms_jobs Page

To verify that the job is still functioning, confirm that the Next Date has not passed. The jobs background processes sometimes stall or get stuck behind a lock, and

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 depot:

http://www.rampant-books.com/book_2003_2_replication.htm

Get a Personal Oracle Replication Mentor

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.