Oracle Dataguard (DG) with Role of Standby Redo Logs (SRL) in Data Guard
Vložit
- čas přidán 23. 07. 2024
- In This Video, we are going to talk about Oracle Dataguard and the Role of Standby Redo Logs in Oracle Dataguard.
Below are the questions this Video Answers...
What is the Role of Standby Redo Logs in Oracle Dataguard?
Various Modes of DG and Which Modes Require Standby Redo Log Files?
What is Sync and Async Replication in Oracle Dataguard?
We knew about LGWR, ARCn, RFS and MRP. How about NSAn, NSSn, LNSn?
How do you create Standby Redo Logs?
Do we need Standby Redo Logs on Primary?
Role of SRL in Cascaded Standby?
Oracle Database Flashback Video: • Oracle Database Flashb...
Exclusive Exadata Talk Series:
• All About Oracle EXADA...
Willing to Learn MongoDB:
• MongoDB on Linux VM In...
Really Useful Video.. I do not remember now why we need SRL in DG but all my colleagues were telling me that SRL is required. I used to tell them that I worked on DG without SRL a decade ago but they were not believing it. This Video helped me to recollect the old concepts.
Awesome explanation
Cleared my lots of doubts
Thankyou so much 🙏
Super vedios. Congrats 👏
The best thing about this video -
It is to the point 👍👍
Excellent presentation.
kudos for all your efforts on making this.
Great knowledge and indepth understanding
Comprehensive and very informative
Thanks a lot for the comment Naga..
To the point. Thank you.
Thanks Vindhya.
Very useful vedios sir thank you
Awesome
Thanks
superb 👌 it greatly helps me
thanks a lot...
Glad to hear that
Nice explanation sir
Thanks for liking Bharath. Keep supporting.
4:57 Maximum Availability has SYNC+AFFIRM or SYNC+NOAFFIRM(12c new feature: Fast Sync)
Thanks Lancia for your Comment. I will make a note for my upcoming videos
Thanks for this video. Can you please tell me how to remove error ORA-16724: cannot resolve gap for one or more databases. what necessary steps should be followed for this. Waiting for your reply. Thanks
HI, Here i could not understand the point, how the data loss will occur. Even though the primary database got crashed, oracle has roll forward method right to apply all the committed data to data files? Thank yoou
Hi Nagaraju, Thanks for your Comment. In the traditional method, the change applied to Standby database only through Archivelogs being shipped. Consider I have standby database applied until SCN 10000. There are some transactions in Primary, which are commited and updated on Primary Datafiles (SCN 10050). The Delta of 50 transactions gets applied on standby only when the archivelog from primary gets shipped and applied. Just in case if there is a crash of primary and all files including ONline Log Files are inaccessible, then we will lose the delta transaction.
Hi, Nice video 👍 i have two queries :
1) how to avoid archive deletion from primary if not applied on standby db.
2) If we have EE license do we need to have separate license to use ADG feature?
Thanks
MS
Thanks for your questions and Comments MS.
1. You can set RMAN deletion Policy to applied on Standby. so that the archives will not get deleted until it applied on Standby. If you have enough storage, you can set your purge script to keep 1 day archives.
2. As per Oracle, If your Standby database having Real time query (or) Incremental fast backups enabled, then we need to procure ADG License.
docs.oracle.com/cd/B28359_01/license.111/b28287.pdf
Thanks and Keep Asking More...
Tekdba thanks for your update! Does this mean even we have enterprise edition license if we use adg we need to have separate license
@@15mukku Yes. Because mostly we use ADG for Reporting query offloading (or) Backups.
Its very informative, however, the pace has to slowdown Sir.