Oracle Dataguard Architecture -2

Hi,

I will continue to tell Oracle Dataguard Architecture in this post.

 

dataguard3

 

Read first article before this article.

 

Data Guard has 2 different modes of operation: Synchronous and Asynchronous.

We can explain 2 different ways of Data Guard According to the architecture above on a Transaction as follows:

Synchronous Data Guard

  1. When a Transaction is started in the database, it is first written to the Redo Buffer section. When user commits the transaction, the LGWR process writes the redo data in the Redo Buffer field to the Online Redo Logs then LNS process waits for the verification that redo data is written to the Standby database.
  2. The LNS (Log Network Service) process reads the same Redo data from the Redo Buffer section and reports to the RFS (Remote File Service) process via the ONS (Oracle Net Service). The LNS process automatically reads the Online redo logs of the Primary database if the corresponding Redo data cannot be accessed from Redo Buffer.
  3. RFS Process writes Redo data ( coming from LNS ) to the Standby Redo Logs.
  4. Managed Recovery Process uses the Redo data from the Standby Redo Logs and applied to the Standby database.
  5. Finally, RFS process sends confirmation that sent redo data has been successfully written to the Standby. LNS process sends the message to the LGWR process and then user is now informed that the Commit operation is successful.

 

Asynchronous Data Guard

  1. When a Transaction is started in the database, it is first written to the Redo Buffer section. When this transaction is committed, the LGWR process writes Redo Data from Redo Buffer section to the Online Redo Logs.
  2. The LNS (Log Network Service) process reads the same Redo data from the Redo Buffer section and reports to the RFS (Remote File Service) process via the ONS (Oracle Net Service). The LNS process automatically reads the Online redo logs of the Primary database if the corresponding Redo data cannot be accessed from Redo Buffer.
  3. RFS Process writes Redo data ( coming from LNS ) to the Standby Redo Logs.
  4. Managed Recovery Process uses the Redo data from the Standby Redo Logs and applied to the Standby database.

 

In the Asynchronous Dataguard method, confirmation that the RFS process has successfully processed the redo data is not sent to the LNS, so there is no loss of Zero data and the data is recovered with minimal data loss.

In the Synchronous Dataguard method, this method guarantees zero data loss because all the data that has been committed is sent to the Standby side and it is guaranteed to be applied.

However, there are some problems with Synchronous according to Asynchronous Synchronous Data Guard, less performance than the Asynchronous Data Guard method because in the Synchronous Data guard method, the LGWR process always waits for the verification from the LNS process and Leads to loss of time. However,  Zero Data Loss Solution is more advantageous than the Asynchronous method in the very critical databases.

 

Oracle Dataguard technology provides us with 3 protection modes according to different options for protecting our data. We will explain what these are in the next post.

 

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

One thought on “Oracle Dataguard Architecture -2

Leave a Reply

Your email address will not be published. Required fields are marked *