Re: DataGuard Broker opinions please.
Date: Wed, 1 Nov 2017 06:20:01 +0000
Message-ID: <CABe10sawt9d=X9YLBhwLxubs2VgeAshWQ3V39LEq2H7e2kRD3Q_at_mail.gmail.com>
On Wed, Nov 1, 2017 at 4:35 AM, Patrick Jolliffe <jolliffe_at_gmail.com> wrote:
> I haven't seen that before. Any bug number or is it documented anywhere?
> What I have seen is that when role switches from primary to standby, BCT
> is automatically disabled by DG (for license compliance - BCT on standby is
> part of active dataguard if I recall correctly).
> When role switches back, it does not get automatically re-enabled - we
> handle this via a database trigger
> Patrick
>
> On 1 November 2017 at 09:21, Mohammad Rafiq <rafiq9857_at_hotmail.com> wrote:
>
>> If any one is using change block tracking ON, Must disable on prod
>> database before switch over. Otherwise it will keep hanging.
>>
>>
>> Thanks
>> Rafiq
>>
>> On Oct 31, 2017, at 12:48 AM, Stefan Knecht <knecht.stefan_at_gmail.com>
>> wrote:
>>
>> Couldn't agree more with the general consensus of the replies so far.
>> Whenever I encounter a standby database environment that doesn't have the
>> broker setup, first thing I question is why they're not using it.
>>
>> I'm usually not a fan of one-command-do-it-all-automatic type of things,
>> but in the broker's case it's somewhat different since it's highly
>> transparent. I always do a switchover / failover like this:
>>
>> - Connect to the primary server and run a tail -f on the alert log
>> - Connect to the standby server and run a tail -f on the alert log
>> - Fire up the broker, run a couple show database verbose, etc and then
>> run the switchover.
>>
>> You can neatly follow the progress and see everything it's doing. If
>> anything goes wrong, you'll see exactly why and what fails. On top of that,
>> the DRC logs are also highly detailed.
>>
>> All in all, it's a great tool and should be part of every standby
>> environment.
>>
>> Stefan
>>
>>
>>
>> On Tue, Oct 31, 2017 at 12:49 AM, Nassyam Basha <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://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>
>>>
>>> [image: Facebook] <https://www.facebook.com/nassyambasha> [image:
>>> Twitter] <https://twitter.com/oracle_ckpt> [image: LinkedIn]
>>> <https://in.linkedin.com/in/nassyambasha> [image: Google +]
>>> <https://plus.google.com/+NassyamBasha> [image: CKPT Blog]
>>> <http://www.oracle-ckpt.com/>
>>>
>>>
>>> On Mon, Oct 30, 2017 at 10:45 PM, Norman Dunbar <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 | Support our Indiegogo campaign at igg.me/at/zztat
>> | _at_zztat_oracle
>>
>>
>
-- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-lReceived on Wed Nov 01 2017 - 07:20:01 CET