In the previous article, we have seen basics about the architecture of Oracle Dataguard.

Oracle Dataguard Architecture

Oracle Data Guard works on physical standby and logical standby sites.

  • Physical Standby: When primary database generates redo entries, those redo are transferred to standby database and then redo is applied to standby database.
  • Logical Standby: When primary database generates any redo entries it is transferred to standby database and then redo data are converted into SQL statements and then those SQL statements are applied to standby database.

In this article, we are going to see Redo Apply Architecture of Oracle Dataguard.

By default, apply services wait for the full archived redo log file to arrive on the standby database before applying it to the standby database.

But we have the option to enable real-time apply. For that, we need to configure standby log files. which allows Data Guard to recover redo data from the current standby redo log file as it is being filled.

In above diagram, we can see LNS process is responsible for transferring redo data from primary database’s Redo Buffer or Online redo log files to RFS process of the standby database.

Then RFS process will write that redo to standby log files.

Then MRP process will read that redo and directly apply redo data to Standby Database.

Stay tuned for More articles on Oracle DataGuard

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

 

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.