Oracle Advanced Replication is one of several oracle database replication technologies that supports bidirectional replication, multiple masters, conflict resolution, etc.
- Advanced Replication is installed on all participating databases. If not, connect as SYS and run ORACLE_HOME/rdbms/admin/catrep.sql (catrep.sql is executed when you run catproc.sql as well).
- The following initialization parameters must be set:
- JOB_QUEUE_PROCESSES - set to at least 1
- JOB_QUEUE_INTERVAL - only required for oracle 8i and below
- GLOBAL_NAMES set to TRUE
Some of the common views used to monitor replication:
- DBA_REPSITES - Sites that participates in the replication
- DBA_REPGROUP - Replication groups
- DBA_REPOBJECT - Objects that are replicated (for each group)
- DBA_REPCONFLICT - Registered conflict handlers
- DBA_REPCATLOG - Outstanding Admin Requests and configuration errors
- DEFTRAN - Deferred transactions
- DEFERROR - Deferred transaction errors
- DEFERRCOUNT - Deferred transaction error counts
