Re: DataGuard Broker opinions please.
Date: Wed, 1 Nov 2017 22:46:31 +0000
Message-ID: <CY1PR01MB167356550AEBE2FD4B9834A0A15F0_at_CY1PR01MB1673.prod.exchangelabs.com>
On Tue, Oct 31, 2017 at 12:49 AM, Nassyam Basha <nassyambasha_at_gmail.com<mailto:nassyambasha_at_gmail.com>> wrote: Forget the customer systems, even in my test machines, i manage only with Broker. Even I suggest using Data Guard broker to all the customer whomever I work.
DG Broker considered as a lousy product but in fact, it is a very beautiful utility and simple to manage. Even the troubleshooting is also simplified with broker.
The main challenge is when managing with Broker then we should not use SQL*Plus to manage Data Guard. for example, we have to change the parameter standby_file_management from AUTO to MANUAL, then being lazy DBA the command issued from SQL*Plus. Then it creates inconsistency and also we can see the warnings in the broker configuration.
I hardly remember the commands, again we have the beautiful "help" like for other utilities GDSCTL, srvctl etc and everytime I use the syntax by help only. if we manage broker smoothly then it is definitely your best mate. :)
DGMGRL> help edit database
Edits a configuration, database, or instance
Syntax:
EDIT CONFIGURATION SET PROTECTION MODE AS
{MaxProtection|MaxAvailability|MaxPerformance};
--
Nassyam Basha
Senior Principal Consultant - Data Intensity<http://www.dataintensity.com/>
Mobile: +91 895 1010 800
[https://docs.google.com/uc?export=download&id=0B0fzmyj3MN1bUmpaRzZNcXJpUVU&revid=0B0fzmyj3MN1bOWJMZVlNRlZXNUlwSnFvbGdBNHpQZk52T3RzPQ]<https://apex.oracle.com/pls/apex/f?p=19297:4:::NO:4:P4_ID:13140>
Oracle 11g Certified Master<http://education.oracle.com/education/otn/NassyamBasha.htm>
Certified ITIL Foundation 2011 &
ITSM Foundation ISO/IEC 20000
Co-Author: Oracle Data Guard 11gR2<http://www.amazon.in/Oracle-Guard-11gR2-Administration-Beginners/dp/1849687900>
Co-Author: Database Upgrade & Migration Methods<https://www.amazon.com/Oracle-Database-Upgrade-Migration-Methods/dp/1484223276/ref=sr_1_1?ie=UTF8&qid=1488562247&sr=8-1&keywords=database+upgrade+and+migration+methods>
Toad World Community Expert<https://www.toadworld.com/members/nassyambasha>
Co-founder of Oraworld-team<http://www.oraworld-team.com> & IDGOUG<http://www.idgoug.org>
[Facebook]<https://www.facebook.com/nassyambasha> [Twitter] <https://twitter.com/oracle_ckpt> [LinkedIn] <https://in.linkedin.com/in/nassyambasha> [Google +] <https://plus.google.com/+NassyamBasha> [CKPT Blog] <http://www.oracle-ckpt.com/>
On Mon, Oct 30, 2017 at 10:45 PM, Norman Dunbar <oracle_at_dunbar-it.co.uk<mailto:oracle_at_dunbar-it.co.uk>> wrote: Hi Howard,
I've used DG Broker on 11g for my last two contracts with no problems at all. We had the setup as one primary and one standby in a remote location for all production databases in one contract, and for my last we had the primary in Dublin with a Dublin based standby plus a separate DR standby in Amsterdam.
Linux and Windows, DG works well.
Cheers,
Norm.
--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
--
//
zztat - The Next-Gen Oracle Performance Monitoring and Reaction Framework!
Visit us at zztat.net<http://zztat.net> | Support our Indiegogo campaign at igg.me/at/zztat<http://igg.me/at/zztat> | _at_zztat_oracle
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 01 2017 - 23:46:31 CET