This article introduces several major technologies and solutions for Oracle Database Remote replication and Remote Disaster Tolerance.
Currently, the following technologies or solutions are available for remote replication and Disaster Tolerance of oracle databases:
(1) Disaster recovery replication solution based on the storage layer
The replication mechanism of this technology is based on the SAN-based storage LAN for replication for each IO, the copied data volume is relatively large; the system can implement synchronous or asynchronous data replication. it has great advantages for systems with large data volumes (with a daily log volume of more than 60 GB), but the requirements for hosts, operating systems, and database versions are consistent, the requirements for the network environment are relatively high.
The target system does not need a host, as long as there is a storage device. If the target system needs to be readable, additional configurations and devices are required, which is troublesome.
(2) logical volume-based disaster recovery replication Solution
The mechanism of this technology is to replicate the network environment based on TCP/IP, and the operating system process captures the changes in the logical volume for replication. Its features are similar to the replication solution based on storage devices. You can also choose synchronous or asynchronous modes to ensure high consistency of the host's software and hardware environments, it is advantageous for applications with large data volumes. If the target system is readable, a third-party image must be created. I personally think that this technology is more suitable for systems with large data volumes or disaster recovery replication of application systems than the storage-based replication technology mentioned above.
(3) oracle redo log-based logical Replication
This method mainly involves third-party software and the logical Standby in oracle's own volume uard. At present, there are already many mature products and success stories in foreign countries, and there are similar products in China, but there is still a gap with foreign countries in terms of product maturity and success stories.
The principles of such products are basically the same. The working process can be divided into the following processes:
| [Content navigation] |
| Page 1st: technical solutions for oracle remote replication and Remote Disaster Tolerance |
Page 2nd: technical solutions for oracle remote replication and Remote Disaster Tolerance |