Oracle RAC and DG

Time:2020-9-16

RAC

RAC: real application clustersrac

RAC: real application clustersrac

Single node database: one to one correspondence between data files and sample files

When an instance is damaged, the database is corrupted

RAC architecture database: data files corresponding to multiple instances

The most fundamental intention of Rac is instance level fault tolerance, not data-based

Instances are all data based.

DataGuard is based on data fault tolerance.

Core technology of Oracle database supporting grid computing environment

SAN storage area network: a high-speed storage network with centralized management
Oracle RAC and DG

Purpose of RAC

  • Provides instance level redundancy
  • Provide more system resources
  • Add more parallel processing

Advantages and disadvantages of RAC

advantage

  • Provide system redundancy
  • More system resources
  • Business segmentation processing

    shortcoming

  • Memory sharing and resource competition
  • The underlying technology is complex and requires high DBA technology

When does RAC need to be used?

  • Instance redundancy — the purpose of the first consideration
  • Improvement of processing capacity and performance

<!–more–>

DG

DataGuard, a database level high availability (HA) solution, is used as a data disaster recovery solution. For online transaction processing (OLTP, the amount of data is not too large), for online analytical processing (OLAP, the amount of data is too large), you can only select key data to create DG, conventional data, select other backup methods.

DG of disaster tolerance level:

Oracle RAC and DG

Local, same city, different places, multiple disaster recovery, creating a lot of standby

Protection mode of DataGuard

Maximum protection mode

The most secure mode, in which the data between the master database and the standby database is synchronized. That is, when the primary database is submitted, the standby database will be restored accordingly. The data integrity is guaranteed to the maximum extent. Data loss is not allowed.

If the network between the primary database and the standby database, or if there is a problem in the standby database, the operation of the primary database will be directly affected. The main database is down. Therefore, the maximum protection mode will not be selected.

Maximum performance mode

This mode ensures the maximum performance of the primary database, and the data between the primary database and the standby database is asynchronous. In other words, the primary and secondary logs will be transferred to the standby database after archiving, and the archive log files will be used for recovery operation on the standby database.

Highest availability mode

This mode is basically similar to “maximum protection”. Under normal circumstances, the primary and secondary databases are synchronized.

In case of network or standby database problems, the downtime of the primary database will not be affected. The primary database will automatically switch to the “maximum performance” mode. When the standby database is available, the archive will be transferred to the standby database for recovery.

This mode can be understood as the intermediate of “maximum protection” and “maximum performance”.

How to select the protection mode of DG

The biggest factor affecting the selection of DG protection mode is network quality. If the network quality is good, such as local LAN, the highest available mode can be selected. If the network quality is moderate, select the maximum performance mode. Generally, the maximum protection mode will not be selected, which damages the usability of the system.

Types of standby database in DG

Physical standby databases: Physical Standby Databases

Physical Standby is as like as two peas in Primary database.Maintain physical standby database through redo application (which belongs to block to block application)

Logical standby databases

Logical standby is also created through the primary database (or its backup, or its replication library, such as physical standby), so it is similar to the physical standby database at the beginning of creation. But becauseLogical standby applies redo data through SQL applicationTherefore, the physical file structure of logical standby and even the logical structure of data can be inconsistent with that of primary.

Attachment:

On DataGuard of oracle11gr2_ 03 the exploration of three protection modes can be seen in the following blog

Exploring DataGuard of oracle11gr2_ 03 three protection modes


Remember to give me some compliments!

Carefully sorted out the various directions of the computer from the entry, advanced, actual combat video courses and e-books, according to the catalog reasonable classification, you can always find the learning materials you need, what are you waiting for? Pay attention to download now!!!

Oracle RAC and DG

Never forget, there must be a response, friends help me point out a praise, thank you very much.

I am a professional bright brother, YY Senior Software Engineer, four years of work experience, refused salted fish strive to be the leading slash programmer.

Listen to me, more progress, a shuttle program life

If you are lucky enough to help you, please give me a “like” and give me a concern. If you can give me a comment and an encouragement, I will be very grateful.

List of articles by bright brother in the workplace:More articles

Oracle RAC and DG

All my articles and answers have cooperation with the copyright protection platform. The copyright belongs to the workplace Liang brother. Without authorization, reprint must be prosecuted!