This content has been marked as final. Show 4 replies
If you have a RAC cluster you must, for all practical purposes, uses Data Guard Broker.
Once you use the Broker you must, for all practical purposes, ONLY use the Broker.
Starting and stopping with any other tool will put the database out of synch. with the broker files and it is painful to rectify.
So the answer to "can you?" is "yes." The answer to "should you? " is "only if you enjoy pain."
Thx very much for the response.
that is how i understood it (though didn't articulate as well as i could have). the problem i have is i couldn't easily locate documentation outlining this requirement as a point of reference. we go to great lengths w/our documentation here and either i am simply not looking in the right spot or too many years as a PHB of DBAs and not a DBA myself is limiting my vision/interpretation. clearly we've missed detail on operational procedure (the dba asking the questions is in our test team) and unfortunately the guy who has been focused on this config for 9mths has had a sudden family issue - so haven't had a shadow working w/him to ensure knowledge transfer. my fault there ... :(
whatever the case, i would like to back your comments w/documentation references - if any exist! some links below simply don't expose the issues created when using the broker in a FSFO config (or even the broker itself). the 11g reference below is further confusing indicating you can shutdown the db using sqlplus or dgmgrl ... which directly contradicts this http://download.oracle.com/docs/cd/B19306_01/server.102/b14230/sofo.htm#BCGEFICG
i've been working w/oracle long enough to know documentation gaps are not uncommon so am not altogether surprised but am frustrated. w/out appropriate references we're stuck w/trial an error to nail down procedure. be that the case, no problem - just want to ensure we're not missing something.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/rac_support.htm#i641721 (Dataguard and RAC)
http://youngcow.net/doc/oracle10g/server.102/b14230/cli.htm#i1005869 (DG Broker Performing Routine Maintenance Tasks)
http://download-uk.oracle.com/docs/cd/B28359_01/server.111/b28295/deprecated_appx.htm#sthref1463 (11g doc ref footnote indicating you can shutdown w/sqlplus)
any and all further feedback much appreciated
It is Sunday evening and I am about 10 minutes from dinner with the family so I am not going to have a chance to get to those references.
What I can tell you is that my understanding and experience comes from meetings with members of Oracle's HA team, from personal experience (that equates to making mistakes), opening SRs at metalink (see "making mistakes"), and teaching Data Guard classes for several years.
To be honest with you I am not sure it is all that well documented or I suspect I'd have made far fewer mistakes over the years.
You might want to hit metalink. You might find some of my, and other's, painful mistakes to learn from. <g>
no worries at all - your responses confirm what i probably should have known!! have no issue w/making mistakes to learn and we've got the environments to do just that (the questions are coming from a e2e test env build procedure).
i did hit metalink but probably got the search string wrong.
maybe a direct question is helpful:
- you can shut down a RAC database via DGMGRL> shutdown (and likewise startup)
- but you can't do the same for an instance
- so if you're doing node maintenance, you have to shut the instance w/srvctl ... rather than DG
to be honest, i think that's about the gist of things. we've got no confusion around the broker config mgmt/properties, just this seemingly obtuse gap in the documentation.
were we in washington, you'd have my team in the course mate, no doubt. :D
thx again, if you have a sec to provide pointers, i'll chase them up.