Re: DataGuard Broker opinions please.

I've never seen this issue and the only reference I can find is bug 18967645 which was fixed over a year ago.

On Wed, Nov 1, 2017 at 1:47 AM, Patrick Jolliffe <jolliffe_at_gmail.com> wrote:

> Fair point, there are quite a few bugs.
> I guess the point I was trying to make is that there is a danger that it
> becomes widely accepted "urban legend" that BCT and DG do not play well
> together.
> Likely that may have been the case in older versions, but generally Oracle
> corporation do get round to fixing these bugs eventually.
> We've switched over with BCT and DG on both 11.2 and 12.1 may times
> without problems (touch wood!)
> P
>
> On 1 November 2017 at 14:20, Niall Litchfield <niall.litchfield_at_gmail.com>
> wrote:
>
>> This behaviour is highly version dependent. In 11.2 (esp < 11.2.0.4 )
>> there are a number of quite serious bugs that can result in either hangs or
>> crashes when BCT is enabled at the standby including during switchover.
>> Search MOS bug database for "BCT standby" to see a few. You are correct
>> that BCT, and therefore fast incremental backups at the standby site are a
>> part of Active DataGuard (even if the standby isn't open). If you have the
>> pleasure of being audited and have switched over from one site to another
>> and back again, it's quite likely that the standby database (and therefore
>> the primary) will show up as being liable for an ADG license since the use
>> of BCT when the standby wasn't a standby will be recorded. It's worth
>> having records of your switchover operations to hand to talk this one
>> through with LMS.
>>
>> 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-l