Sir, I was always confused an mix-up with Primary DB & standby data guard after seeing your video an explanation using Green & Blue method, very easy to understand your logic. absolutely your are Great. Thank you very much, an Appreciate
Prasad sir, you explanation is superb... Looking for more videos from you. All my doubts till the date regarding data guard get cleared after watching your videos. Really hatsup...
Respectfully....Great presentation.... I never ever seen like this presentation of data guard... I was very confused about protection mode and availability mode but after seeing this video i am totally cleared.
Awesome presentation. I am pretty new to Data Guard and was asked by management to more about it for recovery options. This presentation helped me a lot. Thank you sir.
Really amazing explanation no doubt in that. This clear the basic concepts of oracle data guard as well and beautifully explained the switching of protection modes with examples.
Hi Pushpa Prakash, Check are the archivelogs are copied from source to standby location properly as a step 1. If not check the netservices (tns and listener are configured properly). Once you start seeing archivelogs copy is going good then rest of it is on standby to apply the same to standby server. For troubleshooting issues please check archivelog which explains the problem that it is going through. Hope this helps.
Hi Prasad,I would like to thank you for such a great and fantastic demo and also looking forword for next/latest tutorial.Thanks once again Regards Vimlendu Kumar
I really impressed the way of your presenting with live demo... I clarified all my doubts with your explanation.. Great Thanks , BTW I have a small query on this ... In database backup let us simpana backup can we schedules the simpana backups for for both primary and standby at a time ? if not why ? Thanks & Regards, Siva, Singapore
Hi Prasad Sir, excellent presentation...In very easy way you could convey the concepts..Thanks a lot...As i didnt see the GG course in your online website Please let me know if you have GG presentation OR are you offering GG online training...
Hello Pradasd, thanks for this demo, its really very helpful. i have one question , if i have to suggest some one to implement the active datagaurd, then which protection mode will be better as if no data loss required.
+Sibsankar Mitra Active data guard and protection mode is two different things, would work independently. In other words can be in any mode for active dataguard. If you are looking at no data loss one should go with Max Protection.
Simple and very Neat explanation. Thank you, sir. I need to know how to configure Physical standby database. Do you have demo video session for this.. It would be very helpful.
It was wonderful presentation. May be I missed it. In case of Max Performance Mode if Standby Database goes down. What happens to production in Primary Database. Does it stop working or it continues to work?
Good question sohail. In case of Max Performance production will continue to function while standby is experiencing trouble. This is because Max Performance only works based on archive logs. Only in case of Max protection only production will effect in case any trouble reaching standby. Hope this helps in clearing your question.
Hi pradsd not getting your video on ASM part 2 in youtube currently i am working in oracle window envirnonment. can i use windows command in oracle installed in linux
It was a nice explanation...it is very very easy to understand.. who are getting confuse in data guard concept they will easily get clarified after seeing this video....If you don't mind i have small doubt..when switching from one protection mode to another protection we need to change log_archive_dest_2 parameter values.. i hope..but i didn't find in it.. can you please clarify it why it was not happens ?..whenever i change protection mode one to another they are not giving any exception as like in this video. if you don't mind can you please clarify also on this ?....i hope i will get positive response. Thanks in advance....
Thanks for your comments. Parameter file will have appropriate parameters to handle the switch. One thing before switch to Max protection just put it in Max Availability then protection.
Prasad, suppose if we create DG1 and DG2 per your comment in this article, is it possible to have DG1 in max availability and DG2 as max protection mode? seems impossible since in primary database we decide the protection mode but I would like to get your expert opinion. thanks for such an informative article on youtube. -Nikhil
Hi Prasad Mynumpati / DBA Technologies:- -->First i would like to thank you for sharing such a fantastic demo. -->Secondly i have a very small question that why did you create 2 redo logfile groups 10 and 11 in the standby site during the max availability demo? Do we always need to create like 2 additional groups when we need to change protection mode from max performance to max availability, or what was the reason? -->Thirdly, i would like to know that as you made the standby ready for switching from max performance to max availability , and just before you entered the command "alter database set standby database to maximize availability;" , you did a shutdown of the standby database in the green window, may you want to explain me once, as to why it was shutdown before and if it wasn't shutdown before , then what could have happened? Kindly advice?
Manish Aggarwal I am glad that you liked it. Stand by redo is required form Max Availability and Max Performance. Two redo log groups are minimum (Basic Architecture of DB). It is not additional. We have three types of log files. 1. Online Redo 2. Offline Redo (Arch) 3. Standby Redo. Since we have configured Standby and we wanted to change default protection mode we have make Standby Redo ready for standby database. The reason I shutdown the standby before I can change the protection mode on production is because the way standby is going to recover different from Max performance(uses Arch) to Max Availability (uses standby redo). What is new in Max Availability, the recovery from standby redo, that is why you are able to see the changes that happened on production showed up on standby with out log switch. Hopes this helps !!!! Prasad Mynumpati.
Prasad Mynumpati / DBA Technologies , Hi, I really liked your videos. I would like to know do you also undertake training for data guard and golden gate? where can i email you, or contact you? I am also interested to make a setup at my personal laptop through VM machines , so may be you can help me and quote me the price/fee plz.
Manish Aggarwal I am glad that you liked it. Yes we need to have standby redo log files for Max Protection and Max Availability protection modes as redo content must be available on standby redolog files. Third one we would be discussing in detail during the session.
Manish Aggarwal GoldenGate is not started yet, it would be soon. Yes you can setup VM on your machine that we can help you with. you can reach us training@dbatechnologies.net or you can call us on 9849998237.
Dear You are best one in 11g data guard but video presentation is not according to audience understanding every time confuse to identified primary and physical , but starting presentation well organized thanks
Between Max. performance mode & Max. availability , if you had to choose which one would you choose assuming you have to configure only 1 standby database ?
HI PRASAD JI, I HAVE CONFIGURED DATAGUARD WITH SAME SYSTEM ,ITS WORK FINE, WHEN I CONNECT WITH DIFFERENT SYSTEM IN SAME NETWORK (for eg: two system's in same network) THEN DATAGUARD NOT CONFIGURED PROPERLY , PLEASE HELP ME TO GET OUT OF IT ...! THANKS IN ADVANCE.
Can you please explain what is the diff between below 1) Alter database recover managed standby database disconnect Vs Alter database recover managed standby database disconnect using current logfile? 2) on standby database when opening database in mount stage Alter database mount standby Vs Alter database mount?
1) Alter database recover managed standby database disconnect Vs Alter database recover managed standby database disconnect using current logfile? A. First option: is for Max Performance as only archive log files are involved and disconnect is the new feature to implement active dataguard. Second one is required to implement max protection and to see the changes on standby with out log switch of prod. 2) on standby database when opening database in mount stage Alter database mount standby Vs Alter database mount? Alter database mount standby - To mount database as standby db Alter database mount? - For current control file databases
![BLACK BAG - Official Trailer [HD] - Only in Theaters March 14](http://i.ytimg.com/vi/Du0Xp8WX_7I/mqdefault.jpg)
Sir,
I was always confused an mix-up with Primary DB & standby data guard after seeing your video an explanation using Green & Blue method, very easy to understand your logic.
absolutely your are Great.
Thank you very much, an Appreciate
Prasad sir, you explanation is superb... Looking for more videos from you. All my doubts till the date regarding data guard get cleared after watching your videos. Really hatsup...
Outstanding and very easy to understand the concept with your fantastic examples.... You are Mr. perfect Sir...
Respectfully....Great presentation.... I never ever seen like this presentation of data guard... I was very confused about protection mode and availability mode but after seeing this video i am totally cleared.
Thanks a lot for explaining about the dataguard with live demo.
This has helped me a lot to understand the features of it.
Well explained. Helped to understand the D G Concepts. Thanks Prasad M :-)
Awesome presentation. I am pretty new to Data Guard and was asked by management to more about it for recovery options. This presentation helped me a lot. Thank you sir.
+Rajkumar V
Thanks for your comment and I am glad that it helped you.
so clearly explained step by step.Best video on dataguard.
Very neat and clear explanation. Thanks
Fantastic Demo sir ,Thank you so much for uploading,it greatly helps to understand more about the dataguard
So great presentation, as newer, I think it's easy to understand the concept with your fantastic examples. thanks a lot!
Really amazing explanation no doubt in that.
This clear the basic concepts of oracle data guard as well and beautifully explained the switching of protection modes with examples.
Really liked your Video, very well explained. Thanks Prasad.
Sir, Its very good presentation. You are genius . Thank you for sharing.
Thanxx Prasad Sir your presentation and explanation of Datagurad is very awesome,very much clear about dataguard now.
I am glad to hear.
very good video. i am very clear now on the different modes. pls keep posted with similar videos in future. thanks a lot.
Sure, Thanks for your comments.
what an explanation ....................................... really superb.
Wonderful explanation Prasad garu. Thank you! Helped a lot.
Your presentations are succinct and very easy to understand. Thank you.
Excellent demonstration - thank you!
Excellent explanation and very well presented with examples Sir.
Its commendable,very well explained all the scenarios.
Hi Pushpa Prakash, Check are the archivelogs are copied from source to standby location properly as a step 1. If not check the netservices (tns and listener are configured properly). Once you start seeing archivelogs copy is going good then rest of it is on standby to apply the same to standby server. For troubleshooting issues please check archivelog which explains the problem that it is going through. Hope this helps.
Hi Prasad,I would like to thank you for such a great and fantastic demo and also looking forword for next/latest tutorial.Thanks once again Regards Vimlendu Kumar
Wonderful .. I became your fan Prasad . Thanks a lot for this amazing session.
Glad to hear that you liked it. Thank You Arindam Chakraborty.
Super explanation for Protection Modes. Thanks for this explanation
Sir, this video is best video for DataGuard, please share more videos about DataGuard
I really impressed the way of your presenting with live demo... I clarified all my doubts with your explanation.. Great Thanks , BTW I have a small query on this ... In database backup let us simpana backup can we schedules the simpana backups for for both primary and standby at a time ? if not why ?
Thanks & Regards,
Siva,
Singapore
Before putting the database into max protection or availablity is it necessary to change the parameter from sync and affirm
Great work sir.... Appreciated your mode of explanation
Awesome Demo. Thank you very much Prasad.
Very informative.. Much appreciated.
Hi Prasad,
Very good lecture on Dataguard.. thanks
Very nice explanation although i am new comer thanks for knowledge sharing
great demo on standby DB & Protection mode with no confusion.. :)
sir, Thanks you so much you session helped be a lot and cleared by doubts. thank you again...
Good job ...... done.....
Hi Prasad, it was a great video and very good explanation!!!
Hai Munesh, Thanks for your comments.
Hi Prasad Sir, excellent presentation...In very easy way you could convey the concepts..Thanks a lot...As i didnt see the GG course in your online website Please let me know if you have GG presentation OR are you offering GG online training...
it was a really nice demo and explanation ...
Hello Pradasd,
thanks for this demo, its really very helpful. i have one question , if i have to suggest some one to implement the active datagaurd, then which protection mode will be better as if no data loss required.
+Sibsankar Mitra
Active data guard and protection mode is two different things, would work independently. In other words can be in any mode for active dataguard. If you are looking at no data loss one should go with Max Protection.
Very well explained, thank you!
Hello sir your video on dataguard is really awesome, sir can you provide a video on configuring dataguard.
This is a great video! Thanks for sharing
Thanks Prasad for this Video !
Pretty informative. I m new to data guard. Thanks.
Hi Prasad,
do you provide lab work and online lab to practice the concepts learned in the session?
Very good explanation.thanks
Thanks so much, sir for the easily understood tutorial.
Simple and very Neat explanation. Thank you, sir. I need to know how to configure Physical standby database. Do you have demo video session for this.. It would be very helpful.
Sir,
thank you ,very good video for dataguard
rajendra
It was wonderful presentation. May be I missed it. In case of Max Performance Mode if Standby Database goes down. What happens to production in Primary Database. Does it stop working or it continues to work?
Good question sohail. In case of Max Performance production will continue to function while standby is experiencing trouble. This is because Max Performance only works based on archive logs. Only in case of Max protection only production will effect in case any trouble reaching standby. Hope this helps in clearing your question.
salute sir...nice explaination
Good demo...done...
Hi pradsd
not getting your video on ASM part 2 in youtube
currently i am working in oracle window envirnonment.
can i use windows command in oracle installed in linux
It was a nice explanation...it is very very easy to understand.. who are getting confuse in data guard concept they will easily get clarified after seeing this video....If you don't mind i have small doubt..when switching from one protection mode to another protection we need to change log_archive_dest_2 parameter values.. i hope..but i didn't find in it.. can you please clarify it why it was not happens ?..whenever i change protection mode one to another they are not giving any exception as like in this video. if you don't mind can you please clarify also on this ?....i hope i will get positive response. Thanks in advance....
Thanks for your comments. Parameter file will have appropriate parameters to handle the switch. One thing before switch to Max protection just put it in Max Availability then protection.
very nice seminar with Demo.
Prasad,
suppose if we create DG1 and DG2 per your comment in this article, is it possible to have DG1 in max availability and DG2 as max protection mode? seems impossible since in primary database we decide the protection mode but I would like to get your expert opinion. thanks for such an informative article on youtube.
-Nikhil
nice video, cleared all doubt.
Really glad to hear that .....
its really helpful thanks alot...
awesome. Great demo!
Very good explanation of Data Guard
Hi Prasad Mynumpati / DBA Technologies:-
-->First i would like to thank you for sharing such a fantastic demo.
-->Secondly i have a very small question that why did you create 2 redo logfile groups 10 and 11 in the standby site during the max availability demo?
Do we always need to create like 2 additional groups when we need to change protection mode from max performance to max availability, or what was the reason?
-->Thirdly, i would like to know that as you made the standby ready for switching from max performance to max availability , and just before you entered the command "alter database set standby database to maximize availability;" , you did a shutdown of the standby database in the green window, may you want to explain me once, as to why it was shutdown before and if it wasn't shutdown before , then what could have happened?
Kindly advice?
Manish Aggarwal
I am glad that you liked it.
Stand by redo is required form Max Availability and Max Performance.
Two redo log groups are minimum (Basic Architecture of DB). It is not additional. We have three types of log files. 1. Online Redo 2. Offline Redo (Arch) 3. Standby Redo. Since we have configured Standby and we wanted to change default protection mode we have make Standby Redo ready for standby database.
The reason I shutdown the standby before I can change the protection mode on production is because the way standby is going to recover different from Max performance(uses Arch) to Max Availability (uses standby redo). What is new in Max Availability, the recovery from standby redo, that is why you are able to see the changes that happened on production showed up on standby with out log switch.
Hopes this helps !!!!
Prasad Mynumpati.
Prasad Mynumpati / DBA Technologies ,
Hi,
I really liked your videos.
I would like to know do you also undertake training for data guard and golden gate? where can i email you, or contact you? I am also interested to make a setup at my personal laptop through VM machines , so may be you can help me and quote me the price/fee plz.
Manish Aggarwal
I am glad that you liked it. Yes we need to have standby redo log files for Max Protection and Max Availability protection modes as redo content must be available on standby redolog files. Third one we would be discussing in detail during the session.
Manish Aggarwal
GoldenGate is not started yet, it would be soon. Yes you can setup VM on your machine that we can help you with. you can reach us training@dbatechnologies.net or you can call us on 9849998237.
nice and useful stuff.............
Dear You are best one in 11g data guard but video presentation is not according to audience understanding every time confuse to identified primary and physical , but starting presentation well organized thanks
joni jaf
Green one is standby and blue one is primary for your understanding.
Dear Thank for prompt reply i will repeat , your video is informative
Thanks and will wait your more videos
Best...really helpful...
Between Max. performance mode & Max. availability , if you had to choose which one would you choose assuming you have to configure only 1 standby database ?
Max availability.
nice explanation! thanks a lot
if u tell something about sunc/affirm and sync/no affirm concept,it wil better.
really helpful thanks...
awesome explanation sir
Thank You Dinesh.
HI PRASAD JI, I HAVE CONFIGURED DATAGUARD WITH SAME SYSTEM ,ITS WORK FINE, WHEN I CONNECT WITH DIFFERENT SYSTEM IN SAME NETWORK (for eg: two system's in same network) THEN DATAGUARD NOT CONFIGURED PROPERLY , PLEASE HELP ME TO GET OUT OF IT ...!
THANKS IN ADVANCE.
Nice explanation
Super demo
very nice
Kindly share the steps of configuring DG in 11gr2 in PDF please.
Thanks a lot...
Can you please explain what is the diff between below
1) Alter database recover managed standby database disconnect Vs Alter database recover managed standby database disconnect using current logfile?
2) on standby database when opening database in mount stage
Alter database mount standby Vs Alter database mount?
1) Alter database recover managed standby database disconnect Vs Alter database recover managed standby database disconnect using current logfile?
A. First option: is for Max Performance as only archive log files are involved and disconnect is the new feature to implement active dataguard. Second one is required to implement max protection and to see the changes on standby with out log switch of prod.
2) on standby database when opening database in mount stage
Alter database mount standby Vs Alter database mount?
Alter database mount standby - To mount database as standby db
Alter database mount? - For current control file databases
Awesome sir
You rock
nice session....
Thank u...
really good lecture
Thanks Sriram Prasad. I am glad that you liked it.
Hai dba24, you can contact on 91+9441172718 for training details.
Prasad Garu
Do u provide online training
prabhakar kantamaneni
Yes we do. For more details you can visit us on www.dbatechnologies.net or you can reach us on the number mentioned.
Very good demo. Thanks and Appreciate your clear explanation,
Excellent demonstration - thank you!
Nice explanation