Logical Standby Database : SQL Apply Architecture

Oracle DataGuard supports logical and physical standby databases.

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.

To read more about Physical Standby Database

Physical Standby Database: Redo Apply Architecture

A thing that got clear to us till now is, Physical Standby works on the redo, while Logical Standby have an extra layer of conversion and it converts redo to SQL statements and those SQL statements then applied to Logical Standby Database. That is called log mining process.

Now, what happens when Redo to SQL conversion takes place.

Image Source

We can see Six processes for Logical Standby in Above Image.It is categorized in two parts. Log Mining Process and SQL apply process.

1. Log Mining Process

  • Reader Process: It reads redo records from the archived redo log files or standby redo log files.
  • Preparer Process: This converts block changes contained in redo records into logical change records (LCR). Multiple PREPARER processes can be active for a given redo log file. The LCRs are kept in the system global area (SGA), known as the LCR cache.
  • Builder Process: This process groups LCRs into transactions, and performs other tasks, such as memory management in the LCR cache, checkpointing related to SQL Apply, restart and filtering out of uninteresting changes.

2. Apply Process

  • Analyzer Process: This process identifies dependencies between different transactions.
  • Coordinator Process: This process assigns transactions to different appliers and coordinates among them to ensure that dependencies between transactions are honored. It is also known as LSP process. Main Process in the logical standby database.
  • Applier Process: This process applies transactions to the logical standby database under the supervision of the coordinator process.

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

 

 

Tagged:

About The Author

I am 11g OCP and OCE(RAC and GRID Infrastructure). Currently working as Oracle Database Administrator at _VOIS and Blogger (Freelancer) at Oracle-help . Previously I worked with Acute Informatics pvt ltd. and Mobile Tornado where I handled Banking Data Migration , created DR using log shipping , Golden Gate and Data Guard. I have experience of handling planned and unplanned DB role switchover and failovers and monitoring and troubleshooting Database Performance. Key skills : RMAN , GG , DG , RAC , Virtualization in OVMM.I have experience in Banking and Telecom domain. Reach me at : https://www.linkedin.com/in/jagruti-jasleniya

Leave a Reply

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