ServiceGuard Oracle10g DataGuard

[Matthew Ghofrani]

We have installed DataGuard (an Oracle replication technique) for DR. We are told by our DBAs that the StandBy database does not honor the ServiceGuard's package name and they need to use the server name (and as you can see it poses a problem for me when we failover to another machine).
Questions:
1- Has anyone run into this issue before?
2- Is there a work around such as manipulating some ascii files ?
3- Is HP aware of this?

Thanks

[Duncan Edmonstone · Accepted solution]

Matthew,

Dataguard works fine with Serviceguard.

However Dataguard Broker (which makes managing Dataguard easier and I suspect is what your DBAs are referring to) doesn't currently work with Serviceguard (in fact it doesn't work with any sort of cold failover cluster on any platform including VCS, MSCS, HACMP etc.)

This is all discussed in Oracle Metalink article 413696.1

This is an Oracle problem, not a HP problem - apparently this will be fixed in the patchset that takes Oracle to 10.2.0.4 whenever that will be released (not this year as far as I know).

So you have 3 choices:

1) Wait for 10.2.0.4 to be released
2) tell your DBAs they will have to manage Dataguard using standard SQL commands rather than Dataguard Broker (i.e. set oracle parameter DG_BROKER_START to false and use SQL commands like alter database recover managed standby... etc.)
3) Switch to using Oracle RAC, which does work with Dataguard Broker (although depending on your Dataguard mode it can have other constraints)


Oh and to answer the questions:

1) Yes - I have...
2) Yes - don't use Dataguard Broker
3) Yes - but Oracle have to fix it

HTH

Duncan

[Duncan Edmonstone]

Matthew,

I should also have added that this is also apparently going to be fixed in Oracle 11g which will be available *real soon now*

HTH

Duncan

[Matthew Ghofrani]

Thank you very much Duncan.
I will relay the message to our DBA