Just to add that we don’t enable BCT on standby to avoid any licensing issue
for active data guard. This is only enabled to keep incremental backup faster
with reduced in size as well as less io.
Thanks
Thanks
Rafiq
On Nov 1, 2017, at 12:48 PM, Seth Miller
<sethmiller.sm@xxxxxxxxx<mailto:sethmiller.sm@xxxxxxxxx>> wrote:
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@xxxxxxxxx<mailto:jolliffe@xxxxxxxxx>> 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@xxxxxxxxx<mailto:niall.litchfield@xxxxxxxxx>> 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@xxxxxxxxx<mailto:jolliffe@xxxxxxxxx>> 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@xxxxxxxxxxx<mailto:rafiq9857@xxxxxxxxxxx>> 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@xxxxxxxxx<mailto:knecht.stefan@xxxxxxxxx>> 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@xxxxxxxxx<mailto:nassyambasha@xxxxxxxxx>> 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@xxxxxxxxxxxxxxx<mailto:oracle@xxxxxxxxxxxxxxx>> 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> | @zztat_oracle
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
