Oracle Dataguard (DG) with Role of Standby Redo Logs (SRL) in Data Guard

[@baskarbabu4015]

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.

[@VladVonGrigorian]

Thank you for the excellent walk trough

[@jitendraverma3783]

Awesome explanation Cleared my lots of doubts Thankyou so much 🙏

[@luckyally123]

Great knowledge and indepth understanding

[@kikivalathati]

Excellent presentation. kudos for all your efforts on making this.

[@nandipatinagabrahmachari6812]

Comprehensive and very informative

[@Tekdba]

Thanks a lot for the comment Naga..

[@jitendraverma3783]

The best thing about this video - It is to the point 👍👍

[@blackmuscletamil5361]

Very useful vedios sir thank you

[@thirumurugan5959]

Super vedios. Congrats 👏

[@vindhyajangam9822]

To the point. Thank you.

[@Tekdba]

Thanks Vindhya.

[@prathapreddy9618]

superb 👌 it greatly helps me thanks a lot...

[@Tekdba]

Glad to hear that

[@bharathkumargoli1099]

Nice explanation sir

[@Tekdba]

Thanks for liking Bharath. Keep supporting.

[@loveall4969]

Thanks

[@lanciachen1]

4:57 Maximum Availability has SYNC+AFFIRM or SYNC+NOAFFIRM(12c new feature: Fast Sync)

[@Tekdba]

Thanks Lancia for your Comment. I will make a note for my upcoming videos

[@nagaonnet]

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

[@Tekdba]

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.

[@tayyabaabro5345]

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

[@nrsaini29791]

Awesome

[@15mukku]

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

[@Tekdba]

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...

[@15mukku]

Tekdba thanks for your update! Does this mean even we have enterprise edition license if we use adg we need to have separate license

[@Tekdba]

@@15mukku Yes. Because mostly we use ADG for Reporting query offloading (or) Backups.

[@dontauro8801]

Its very informative, however, the pace has to slowdown Sir.