Oracle]data Guard's redo transmission detailed explanation

Source: Internet
Author: User

Data Guard offers two main services:
1 Redo Transport service: The Primay end of the redo log transmission to one or more standby destinations.
2 Redo Application Service: The redo log which is transmitted from the Primay end is applied to the standby end.
This article first discusses the redo transport services.

1, the use of ARCN transmission redo log
by default, the redo log is transferred using ARCN, but only in the most high-performance mode can the ARCN be used (refer to thethree protection mode descriptions of Oracle] Data Guard), The schematic diagram using Arch transmission redo log is as follows:

The approximate process is as follows:
1 primay segment ARC0 Once the log switch is completed, ARC1 transmits the newly generated archive log to the standby end;
2 Standby driven by RFS process to accept the log, if configured Standby redo log, log to Standby redo log, and so Standby redo log to do log switch to form an archive log, and then apply the archive log for recovery If you do not configure the standby redo Log,rfs process to receive the log, put it in the standby-side archive directory and standby reapply the archive log for recovery.

2, the use of LGWR transmission redo log
the use of LGWR process and ARCN is very different, the most obvious difference is that it does not need to wait for the primary completion of the log switch after the transfer, the diagram is as follows:

The process is generally as follows:

1 Once primary has redo log generation, LGWR will trigger LNSN process transfer redo only standby redo log; Note: This cannot be transmitted directly from LGWR because the entire database instance has only one lgwr, in order to ensure its primary performance is not affected, cannot be transmitted directly by it)

2 Network transmission mode can choose Sync or async,sync refers to when primary commits, must have to wait for redo transmission to standby successful, can return. So if you set sync, we recommend that you set the Net_timeout parameter at the same time, the timeout is not responding, then return an error. Async refers to the success of primary commits and the success of the log transmission, which has the least impact on the performance of primary.

3 Standby end of the RFS process to redo write standby redo log, if the real-time application, will be redo to apply to the standby database, if not open real-time applications, such as standby redo Log is archived and then applied to the standby database.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.