Hello!
The comments on this profile are unclaimed and thus are unverified.
Do they belong to you? Claim these comments.
Charles Schultz
Is this you? Claim Profile »
3 months ago
in Start Database Services automatically after instance startup on DanNorris.com
Thanks, I appreciate that. So this really begs the question; "why do they recommend against having CRS put the standby in standby mode?" I am asking from the angle that I have more to learn, and I would like to understand the ramifications of this action.
The DG Broker is another beast. I have heard so many good things about it that I am recommending to our group that we start adopting it. We tried it out in 9i and were burned badly (too complicated, too esoteric, not very friendly).
PS - In light of this post, I am passing out Jeremy's whitepaper like candy to the SunGard crowd, because currently they do not support Services which makes my job as a DBA a little more difficult than it needs to be. Funny how the support staff I am talking has no clue what Oracle Services even are. =) Ah well....
The DG Broker is another beast. I have heard so many good things about it that I am recommending to our group that we start adopting it. We tried it out in 9i and were burned badly (too complicated, too esoteric, not very friendly).
PS - In light of this post, I am passing out Jeremy's whitepaper like candy to the SunGard crowd, because currently they do not support Services which makes my job as a DBA a little more difficult than it needs to be. Funny how the support staff I am talking has no clue what Oracle Services even are. =) Ah well....
1 reply
3 months ago
in Start Database Services automatically after instance startup on DanNorris.com
This got me to thinking. The MAA guide does not specify any mount options when adding a standby using srvctl:
http://www.oracle.com/technology/deploy/availab...
I am thinking that there is a way to have CRS put the standby in managed recovery mode, but not finding it easy to find in the documentation. Why is it not made more clear, more obvious? Especially if Oracle is touting this thing called "Best Practices" for "Maximum Availability"? =)
http://www.oracle.com/technology/deploy/availab...
I am thinking that there is a way to have CRS put the standby in managed recovery mode, but not finding it easy to find in the documentation. Why is it not made more clear, more obvious? Especially if Oracle is touting this thing called "Best Practices" for "Maximum Availability"? =)
2 replies
Dan Norris
I got some feedback from one of my contacts (suffice it to say this is authoritative information). Basically, they said that they don't recommend using CRS to put the DB in standby mode. There is a "-r physical_standby" mode that was created, but not used, so avoid it. Instead, DG Broker is the recommended way to manage RAC standbys and it is documented too: http://download.oracle.com/docs/cd/B19306_01/se...
Hope that helps.
Hope that helps.
Dan Norris
Hi Charles,
I haven't seen anything like that in the docs either. I don't think there's any way for CRS to handle it as the "agent" for RAC instances isn't extensible as far as I know. So, to offer this functionality, Clusterware development would have to get involved to support it (at least that's how I see it--not knowing how things are organized internally there).
Your question is a good one and I pinged a few friends that might have some more thoughts. If they don't post them here (assuming I get responses at all), I'll summarize and post results.
I haven't seen anything like that in the docs either. I don't think there's any way for CRS to handle it as the "agent" for RAC instances isn't extensible as far as I know. So, to offer this functionality, Clusterware development would have to get involved to support it (at least that's how I see it--not knowing how things are organized internally there).
Your question is a good one and I pinged a few friends that might have some more thoughts. If they don't post them here (assuming I get responses at all), I'll summarize and post results.
In 10g R2, I had good experiences with DG Broker--not sure about versions before then, but I can guess it may not have been so good back in V1 or V2 (DG was introduced in 9i, so that's basically V1 in my eyes).