Comparison of Oracle backup functions

Oracle backup features include:

Advanced Replication)

Streaming Replication)

Slave uard)

One worker uard:

Dataguard is generally the first choice for dba in terms of high availability and Disaster Tolerance. After all, dataguard has an overwhelming advantage in this regard, whether it is a physical standby database (physical standby database) or the logical standby database, which all have some common features to be levied.

Configuration and management costs: replica uard is simpler and more convenient than stream replication; security and stability costs: replica uard is more stable and reliable than stream replication.

For a 24x7 system, these are very important. The increase in system downtime not only affects the company's image, but also the company's benefits. The adoption of dataguard, data security is quite guaranteed. The physical standby database can complete failover in the shortest time, while ensuring data security, the logical standby database can also undertake a large number of reports and other services; because the configuration and management of dataguard are relatively simple, the dba's work intensity is also reduced;

Second-stream replication:

Applicable to the following situations:

1. Partial replication stream can only replicate certain tables or certain modes

2. Fully utilize existing devices and technologies in heterogeneous environments

3. Remote Disaster Recovery stream has lower network requirements than mongouard

Stream replication has a flexible replication policy, which not only allows you to copy only some tables, but also allows you to copy only the ddl or dml of some tables. Compared with replica uard, you must copy the entire database, this can save considerable Storage Investment. After all, many of the massive data volumes do not need to be copied.

If it is in a heterogeneous environment, that is, different operating systems, then the replica uard will be helpless, and non-stream replication will not belong, so that you can make full use of the existing environment, configure high-availability solutions, in a heterogeneous environment, stream replication will be a strong competitor of advanced replication.

Stream replication transmits the logical change records (LCRs) that are mined and packaged by logmnr. Compared with the archived redo log transmitted by mongouard, The mview log of advanced replication and the mview refresh method, stream replication reduces network requirements a lot. In the remote Remote Disaster Recovery Process, renting network bandwidth is a high cost, and stream replication can appropriately reduce this cost.

Iii. Advanced Replication:

Compared with replicuard, advanced replication has the following Disadvantages: complicated configuration and management, insufficient security and stability; advantages: Local replication and heterogeneous environments. Advanced replication is a very mature technology that has been successfully applied in many key systems. Compared with stream replication launched by 9iR2, both parties are applicable in a similar environment, for example, local replication, heterogeneous replication, and Remote Disaster Tolerance can all be performed. advanced replication is now able to withstand the test of stability and security.

Compared with the underlying implementation technologies of stream replication and advanced replication, stream replication has more advantages in real-time, stability, high efficiency, and low consumption (less cpu/network resources, however, there are more or less uncertain factors in some new features.

In 10gR1, oracle has enhanced the weakness of stream replication. It not only provides scripts for migrating data from advanced replication to stream replication, but also provides configuration and monitoring tools for stream replication, stream replication will be intelligent and simple in terms of configuration and management, and it will take the responsibility of competing with shareplex for the enterprise data replication market.

1 2 Next Page