Data Guard Physical Standby and Logical Standby Database Architecture in...

In this tutorial, we will learn
-Types of Standby Databases
-Background Services
-Data Guard Architecture
-Protection mode of Data Guard

Types of Standby Database
-Physical Standby
-Logical Standby

Discuss Later
Snapshot Standby
Active-Standby

Background Process work behind the Data Guard Configuration
*LNS - Log Network Service ( Running on the Primary Database)
*RFS - Remote File Service (Running on the Standby Database)
*MRP - Media Recovery Process (Running on the Standby Database)
*LSP - Logical Standby Process (Running on Logical Standby Database)

Standby
*Standby is a block to block a copy of the production database.
*The Standby Database also called is Physical Standby.
*The MRP process Manage the recovery which applies the received redo on physical standby.

Logical Standby
*Convert received redo in SQL statement and execute on standby.
*Logical standby database read/write operations (not on the replicated tables)
*Structure not same .
*Involve a few extra processes.
*Not all data types are supported.

Redo Transport Services
*SYNC - Synchronous Redo Transport
*ASYNC - Asynchronous Redo Transport

Note:- Both have the same responsibility to transport redo from production to standby.

SYNC - Synchronous Redo Transport
*Zero Data Loss
*Performance impact

ASYNC - Asynchronous Redo Transport
*Data Loss
*Zero performance impact

Protection mode for Data Guard
Maximum Performance
*It uses ASYNC redo transport
*Priority given to performance
*Minimum data loss


Maximum Availability
*It uses SYNC redo transport (Required)
*First Priority given availability and second priority is data protection
*If standby not available, the primary will wait and then proceed

Maximum Protection
*It uses SYNC redo transport (Required)
*Zero data loss
*If standby not available, the primary will be hangs and database will be abort
*Suggested more than one standby configured

#DataGuard #Architecture #DGtutorial

Oracle Data Guard Tutorial Full Series in Hindi

Oracle Data Guard full course series in Hindi.

Hello Friends, in this series we are going to cover full data Guard tutorial

in the first part, we cover the following topics.





Our Topics

1. Introduction to Oracle Data Guard

2. How to configure oracle data guard from scratches.

3. How to configure the DG Broker.

4. How to manage Physical and Logical standby.

5. How to switchover the role.

6. How to convert the physical standby database into Active standby

7. How to convert the physical standby database into snapshot standby



Please write your views in the comment box.



Click here for my website

How to create Database in RPM base Installation Oracle 19c - Full Guide

In this video, we are going to demonstrate to you how to create a database in RPM-based installation database 19c, Full guide on the Production environment.



For more detail please visit on my website Click Here