A brief talk on data synchronization scheme between Oracle database

With the rapid development of information technology and the deepening of enterprise information construction, the number of enterprise business system is increasing. At this time, the data interaction between the business systems, the data interaction between each child business system and the core business system, and so on, the application demand of these scenarios are constantly appearing. As a result, it is increasingly under pressure to respond to such demands. The main problems are the conflict between real-time and performance, the security and robustness of data interaction scheme. The following is a brief discussion of the data synchronization scheme between Oracle database, which does not involve the choice of scheme or not. Data synchronization scenarios provided by Oracle: 1, compared to the original, trigger/job + dblink mode, can be synchronized and timed to refresh. 2, materialized view refresh mode, there are incremental refresh and full refresh two modes, timed refresh. 3, advanced replication, divided into multiple master replication and materialized view replication two modes. Multi-master replication can be bidirectional synchronous replication and asynchronous replication, materialized view for one-way replication, timed refresh, similar to 2. 4, stream replication, real-time and Non-real time synchronization. 5,goldengate replication, Oracle's newly purchased replication product, should be replaced by streaming replication later. It not only provides data replication support between Oracle databases, it also supports data synchronization between different kinds of databases, and can also set up real-time and Non-real time synchronization. 6,datagurd, this technology is mainly used in disaster preparedness, but in the latest 11GR2 version of the library to add a real-time application log, while open to provide read only access to the function. Therefore, it can be used as a separation of reading and writing, or as a database, a good solution to reduce the load of the system. The above 1,2,3 is implemented by the internal mechanism of Oracle database, and 4,5,6 is realized by mining database log. As a result, the following 3 methods are better at performance. Data synchronization scenarios provided by third parties: Mainly according to the implementation mechanism is divided into two major categories: 1, using the method of mining database log to realize The market is used more, such as Quest Shareplex, DSG RealSync. This type of software is similar to Oracle's newly acquired Goldengate tool. 2, the use of related software at the storage level to replicate Storage vendors such as IBM,EMC can be implemented using Third-party storage management software, such as Veritas replication. This type of scenario is similar to the above 6.