Hi Arun, You make hard topics very easy to understand ..Thanks alot for your contribution to DBAs
@VelrajKuppusamy
3 жыл бұрын
Very simplistic explanation of Data Guard. Thank You :)
@dbagenesis
3 жыл бұрын
You are welcome!
@9890691169
4 жыл бұрын
Very well explained Arun Sir. You make DBA so simple.
@dbagenesis
4 жыл бұрын
Thanks a ton
@ashutoshverma0804
3 жыл бұрын
Short and precise! Excellent
@dbagenesis
3 жыл бұрын
Glad it was helpful!
@Husen78692
2 жыл бұрын
It's really amazingly easy to understand the concept of DG... It's a WOW explanation...
@dbagenesis
2 жыл бұрын
Glad you like it
@chaitanyalotwala8796
3 жыл бұрын
Very helpfull 👍🏻 Looking forward to see more videos like this and learn.
@dbagenesis
3 жыл бұрын
More to come!
@jagadeesh2353
3 жыл бұрын
Wonderful Explaination on failover and switchover concept
@dbagenesis
3 жыл бұрын
Glad you enjoyed it!
@zulkifal111
4 жыл бұрын
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
4 жыл бұрын
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 - support@dbagenesis.com We can always custom build courses for the topics you are looking for!
@agilad9337
3 жыл бұрын
Clear explanation, thank you !
@dbagenesis
3 жыл бұрын
You are welcome!
@ImranKhan-il5gm
Жыл бұрын
great work 👍
@dbagenesis
Жыл бұрын
Thank you! Cheers!
@guysachin1
5 жыл бұрын
Great explanation Arun, Thanks a lot!
@dbagenesis
3 жыл бұрын
Thank you!
@dafinoiu1
3 жыл бұрын
Thank you, good explanation
@dbagenesis
3 жыл бұрын
You are welcome!
@likhithaa3923
4 жыл бұрын
Very well explained
@Naveenkumar-vc1ef
2 жыл бұрын
The best!
@dbagenesis
2 жыл бұрын
Thank you!
@fancystacy
2 жыл бұрын
I like your paintings. Where do you exhibit them? I would gladly attend your art gallery. Those LNS and RFS are marvelous!
@kumarkoruturu8187
5 жыл бұрын
Super bro ....clear cut explanation......
@dbagenesis
3 жыл бұрын
Thank you!
@manzoor5554
4 жыл бұрын
Good Explanation....done...
@rohitairi4408
3 жыл бұрын
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
3 жыл бұрын
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.
@MrRodiego
2 жыл бұрын
Nice video!
@dbagenesis
2 жыл бұрын
Thank You!
@JOKER-jp1uw
2 жыл бұрын
Hi, Can we create SRL on primary after standby configuration setup ?
@asifsoft7861
4 жыл бұрын
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
4 жыл бұрын
Data is written to SRL (standby redo logs) and then read by MRP.
@tufande4410
6 ай бұрын
Can I get the 1st video related to data guard please. I'm missing some concepts it seems.
@shwatankbhasin7384
3 жыл бұрын
If SRL space gets full in standby database, then we consider switchover from standby to primary DB in the data guard environment?
@devwratkumar2808
5 жыл бұрын
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
2 жыл бұрын
you may do it with rman from standby side. RECOVER STANDBY DATABASE FROM SERVICE PRODDBSVC;
@debabratakhan8896
4 жыл бұрын
Thanks a lot sir. Could you please elaborate more about how to manually resolve gap when we don't have archive log.
@fancystacy
2 жыл бұрын
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
@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
@roshanjohn3076
4 жыл бұрын
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
4 жыл бұрын
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
4 жыл бұрын
@@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.
@saikrishnamutyala4312
3 жыл бұрын
Would you be able to explain this DG with one example as you explained oracle scan ips( airport example ) before
@zulkifal111
4 жыл бұрын
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
4 жыл бұрын
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.
@zulkifal111
4 жыл бұрын
u never answered ur question-what happens if rman deletes archivelogs required by standby db?
@dbagenesis
4 жыл бұрын
Why don't you figure out answer and reply to the comment? If you go by logics, your question has the answer!
@zulkifal111
4 жыл бұрын
@@dbagenesis yes I think I have the answers
@vinayakkharvi9778
2 жыл бұрын
@@zulkifal111 Hi Fernandez .What's the answer?
@bk5268
5 ай бұрын
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?😊
@jayashreebhat1758
3 жыл бұрын
Hi DBA Genesis , Do you have any courses for Cloud DBA - on AWS or Oracle Cloud ?
@dbagenesis
3 жыл бұрын
Not yet, but we shall have it very soon.
@mobinahmad825
3 жыл бұрын
I think Lns process read from online redolog, not from redolog buffer
@gopithota8190
2 жыл бұрын
how to create secondary database sir can u make any video for us
@supriyabk7568
4 жыл бұрын
How can we enroll for your courses? I am looking for a RAC course..
@dbagenesis
4 жыл бұрын
To enroll into RAC course: dbagenesis.com/p/oracle-rac-beginners To check all our DBA courses, go to: dbagenesis.com/courses
@himanshugarg4846
5 жыл бұрын
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
@borninfree
3 жыл бұрын
DataGuard is free or not?
@dbagenesis
3 жыл бұрын
It's free with enterprise edition. Active data guard is extra license.
@borninfree
3 жыл бұрын
@@dbagenesis Is Data Guard different from Active Data Guard?
Пікірлер: 68