Oracle Database Data Synchronization scheme

First, the comparison of the original scheme: Trigger/job/snapshot +dblink way, can be synchronized and timed refresh;

Two different database servers, from one database server a user to read another database server B under a user's data, can be done by Dblink.

Second, through materialized view timed refresh to achieve data synchronization. Materialized view refresh mode has an incremental refresh and a full refresh of two modes;

Third, advanced replication, divided into multiple master replication and materialized view replication two modes. Multi-master replication can perform bidirectional synchronous replication and asynchronous replication; Materialized views are used for one-way replication, timed refreshes, and similar to the second;

Four, stream replication, can achieve real-time and non-real-time synchronization;

V. goldengate replication, Oracle's newly purchased copy product, should replace stream replication later. It not only provides data replication support between Oracle databases, but also supports data synchronization between different databases, and can also set up real-time and non-real-time synchronization.

Six, Datagurd, this technology is mainly used for disaster recovery backup, is the entire library level of backup.

The first to second and third are implemented within the framework of the Oracle database, while the fourth to fifth and six are implemented by mining database logs, and the latter three are better in performance.

Oracle Database Data Synchronization scheme