Data Guard Physical Standby and Logical Standby Database Architecture in Hindi
ฝัง
- เผยแพร่เมื่อ 11 ก.ย. 2024
- 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 Interview application play.google.co....
My Facebook page / ocptechnology
My Second Channel / 4usupport
My Instagram / ocptechnology
My Website ocptechnology.com/
My twitter / ocptechnology
Very informative straight to the point that's why I always prefer to watch your videos
Thank you dear
I was very confuse last 5 days but today by watching this vdo I totally understand dr architecture thx bro
Thanks bro
Very informative
Explained in short and simple way.
Thanks you
Nice sir waiting for another videos in hindi
Thanks bro
waiting for another video on datagaurd
Nice video
Thank you dear
best video of all the tmme enable ads as many as psbl love t . waiting for another videw.
Part 3 and others regarding dataguard
Best video on datagaurd
Thanks for watching
Your videos are really helpful....🤟
Thank you
Thanks Sir.
Extremely good video. Please physical standby creation and its administration ka videos jaldi upload kar dejiyega ,mera interview hai.
Ok brother
Or part upload karo please
Hi shripal bro
please make part 3 for dataguard
It is an awesome explaination between logical n physical standby
Can u please make video for
hw to change the protection modes for dataguard.
Yes I'll bro, please subscribe my channel
Please in English also?
Nice sir please also share RAC related interview questions & answers
As soon as possible brother
Nice sir for sharing the knowledge
Thank you bro
In max performance mode if standby is not available then what happens?
Sir just 1 request aapke vedio understanding hote hai but àap bohot fast baat karte hoo toh use hum thik se gras nahi pate.hope u understand
Thank you for your lovely comment, I'll try little slowly
@@ocptechnology thanks 🙏 sir
Sir when you going to upload the next video's... waiting