Oracle 12c Data Guard Architecture

[@rapsap1980]

Hi Arun, You make hard topics very easy to understand ..Thanks alot for your contribution to DBAs

[@9890691169]

Very well explained Arun Sir. You make DBA so simple.

[@dbagenesis]

Thanks a ton

[@Husen78692]

It's really amazingly easy to understand the concept of DG... It's a WOW explanation...

[@dbagenesis]

Glad you like it

[@VelrajKuppusamy]

Very simplistic explanation of Data Guard. Thank You :)

[@dbagenesis]

You are welcome!

[@jagadeesh2353]

Wonderful Explaination on failover and switchover concept

[@dbagenesis]

Glad you enjoyed it!

[@zulkifal111]

Your explanation is crystal clear -so awesome, it compelled me to park every aspect of my thought process-so engaging -I would just be so happy to have a quick chat with u. I was curious to know more about you and went to your site-No videos on RAC-Patching-Exadata? I'm eager to discover your videos -especially troubleshooting and optimization-Thank You Arun

[@dbagenesis]

Most welcome! Yup, most of the videos (which you are expecting) are part of our one-on-one advance training programs. You can always send a request to our team regarding the topics you want to master - [e-mail] We can always custom build courses for the topics you are looking for!

[@ashutoshverma0804]

Short and precise! Excellent

[@dbagenesis]

Glad it was helpful!

[@chaitanyalotwala8796]

Very helpfull 👍🏻 Looking forward to see more videos like this and learn.

[@dbagenesis]

More to come!

[@fancystacy]

I like your paintings. Where do you exhibit them? I would gladly attend your art gallery. Those LNS and RFS are marvelous!

[@tufande4410]

Can I get the 1st video related to data guard please. I'm missing some concepts it seems.

[@rohitairi4408]

Hi Arun, very well explained i wasn't excepting that anyone can explain that topic to easy ,you just made me to think of DBA Genesis every time i need to learn something. Also i had one doubt if you could clear that as the log shipping is going on the MRP is always waiting for the archive to apply as we see in managed_standby view as sequence#.SO as per you we go with first process (redo log buffer) then second process(redo logs) if lgrw is ahead of LNS and then with Third if there is gap but MRP is applying archives only...can you please explain this why we always see archive log(sequence#) in MRP rather than redo buffer or redo logs.

[@dbagenesis]

Coz the default configuration of standby is archive apply. You can change it to redo log apply which is also called as real-time log apply. Thats similar to SYNC configuration as compared to ASYNC configuration which uses archives.

[@JOKER-jp1uw]

Hi, Can we create SRL on primary after standby configuration setup ?

[@guysachin1]

Great explanation Arun, Thanks a lot!

[@dbagenesis]

Thank you!

[@dafinoiu1]

Thank you, good explanation

[@dbagenesis]

You are welcome!

[@ImranKhan-il5gm]

great work 👍

[@dbagenesis]

Thank you! Cheers!

[@mobinahmad825]

I think Lns process read from online redolog, not from redolog buffer

[@shwatankbhasin7384]

If SRL space gets full in standby database, then we consider switchover from standby to primary DB in the data guard environment?

[@saikrishnamutyala4312]

Would you be able to explain this DG with one example as you explained oracle scan ips( airport example ) before

[@gopithota8190]

how to create secondary database sir can u make any video for us

[@agilad9337]

Clear explanation, thank you !

[@dbagenesis]

You are welcome!

[@debabratakhan8896]

Thanks a lot sir. Could you please elaborate more about how to manually resolve gap when we don't have archive log.

[@fancystacy]

you should not delete archive unless they are applied to standby ) but still they are in your backupsets so you may restore them at any time

[@bk5268]

sir, if rfs is down and lns is down how to recover? And if mrp is not apply log in standby in standby database ? How to recover?😊

[@asifsoft7861]

As you said, when it's stand by is being used for reporting purpose or if its a active dataguard the redo logs files on standby will be used. Ok then which process will be writing logs to redo logs? Log writter process? So when data is writtten redo, will mrp read and apply from redo? By the way very beautifully explained. Loved it. thanks!

[@dbagenesis]

Data is written to SRL (standby redo logs) and then read by MRP.

[@devwratkumar2808]

Great Explanation Thanks. Could you please tell more about how to manually resolve gap when we don't have archive log ? Also how to manually force rman to take backup only the archive applied on standby ? Thanks.

[@fancystacy]

you may do it with rman from standby side. RECOVER STANDBY DATABASE FROM SERVICE PRODDBSVC;

[@zulkifal111]

u never answered ur question-what happens if rman deletes archivelogs required by standby db?

[@dbagenesis]

Why don't you figure out answer and reply to the comment? If you go by logics, your question has the answer!

[@zulkifal111]

@@dbagenesis yes I think I have the answers

[@vinayakkharvi9778]

@@zulkifal111 Hi Fernandez .What's the answer?

[@kumarkoruturu8187]

Super bro ....clear cut explanation......

[@dbagenesis]

Thank you!

[@zulkifal111]

you mentioned that standby database need not be in archive mode-however if the standby is now created as active standby database then would it be necessary to put in archive mode, though if u use it for only reporting it will not be required but pls could you throw some light

[@dbagenesis]

Archivelog mode on standby is only required when its in Logical Standby mode. Except that, you do not need to put it in. One more situation would be when you configure cascading DR.

[@jayashreebhat1758]

Hi DBA Genesis , Do you have any courses for Cloud DBA - on AWS or Oracle Cloud ?

[@dbagenesis]

Not yet, but we shall have it very soon.

[@MrRodiego]

Nice video!

[@dbagenesis]

Thank You!

[@raajkumartadimarri]

Hi Sir. Thanks for sharing the good content with us. Once we set up the data guard environment. Incase if I forget to create a Standby Redo Logs on primary database. Can i create it later.

[@dbagenesis]

Yes, you can

[@raajkumartadimarri]

@@dbagenesis Thank you sir

[@supriyabk7568]

How can we enroll for your courses? I am looking for a RAC course..

[@dbagenesis]

To enroll into RAC course: dbagenesis.com/p/oracle-rac-beginners To check all our DBA courses, go to: dbagenesis.com/courses

[@roshanjohn3076]

Very clear explanation. Keep it up :) There is a formula for calculating the number of standby redo logs (maximum # of logfile groups on the source db +1) * maximum # of threads --ASSUMPTION SOURCE IS RAC - 2 NODES TARGET IS RAC - 2 NODES Suppose on source there are 10 thread 1 redo log groups and 10 thread 2 redo log groups, this means there will be 21 thread 1 redo log groups and 21 thread 2 redo log groups on target? What if by mistake I created 10 thread 1 and 10 thread 2 redo logs? Thanks!

[@dbagenesis]

So let's drill down to basics. Redolog Thread = Redolog groups that belong to an instance In RAC, # redo log threads = # of RAC instances What you mentioned (10 threads) is not possible for a two node RAC (off course you can create as many threads as you want but you can assign only one redo log thread to one RAC instance at a time). But, yes, each RAC instance can have min 2 redo log groups or more. Each redo log group can have one or more redo log members. Example: If I assume that 2 NODE RAC will have 2 redo log threads and each thread is having 10 redolog groups with 2 redolog members, then going by below formula: SRL = (maximum number of logfiles for each thread + 1) * maximum number of threads SRLs = ((10 * 2) + 1) * 2 = (20+1)*2 = 42! Don't be surprised by the 42 number. Understand, on RAC primary you have: ORLs = (redolog group * redolog member) * log threads ORLs = (10 * 2) * 2 = (20)*2 = 40! ORL = Online Redolog Files Hope this helps !!

[@roshanjohn3076]

@@dbagenesis Thanks for clarifying on the redo thread. If by mistake I created 22 standby redo logs (each thread having 11 redo log groups), will that cause a problem? I did it on my target but hopefully replication is working fine.

[@likhithaa3923]

Very well explained

[@manzoor5554]

Good Explanation....done...

[@himanshugarg4846]

Excellent video Arun ji, Now One more que apart from this. Can You let me know how much minimum number of archives should be applied to open a database when we are performing a restoration of db on another server? It's help me alot as I have searched it on many sites but not got any solution

[@manzoor5554]

Good Explanation..done...

[@borninfree]

DataGuard is free or not?

[@dbagenesis]

It's free with enterprise edition. Active data guard is extra license.

[@borninfree]

@@dbagenesis Is Data Guard different from Active Data Guard?

[@Naveenkumar-vc1ef]

The best!

[@dbagenesis]

Thank you!