Total Pageviews

Sunday, February 05, 2012

ORACLE ADVANCED REPLIATION

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

Featured Post

ORACLE ADVANCED REPLIATION

Oracle Advanced Replication is one of several oracle database replication technologies that supports bidirectional replication, multiple m...