Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 11g RAC along with Oracle Data Guard

SOLVED
Go to solution
Shivkumar
Super Advisor

Oracle 11g RAC along with Oracle Data Guard

Hi,

Has anyone implemented Oracle 11g RAC along with Oracle Data Guard on Service Guard Cluster ?

Appreciate if someone can post documentation related to this.

Thanks,
Shiv
3 REPLIES
Steven E. Protter
Exalted Contributor

Re: Oracle 11g RAC along with Oracle Data Guard

Shalom,

One of the customers at my previous job did exactly this. Active-Passive RAC cluster with 9g and then 10g RAC.

Service Guard was not really required after the move to 10g RAC, but the kept using it to manage an NFS share for log writing.

With regards to documentation, get the RAC docs from http://technet.oracle.com

http://docs.hp.com/en/ha.html

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Duncan Edmonstone
Honored Contributor
Solution

Re: Oracle 11g RAC along with Oracle Data Guard

Shiv,

There's nothing special about using Dataguard in a serviceguard for RAC configuration when comnpared to a clusterware RAC database. See the section in the Dataguard manual that covers Dataguard with RAC:

http://download.oracle.com/docs/cd/B28359_01/server.111/b28294/rac_support.htm#i641721

If at all possible, once Dataguard is setup, I'd also configure it to use the Dataguard broker, for which there is a seperate manual here:

http://download.oracle.com/docs/cd/B28359_01/server.111/b28295/toc.htm

The broker makes managing Dataguard much much easier...

Be aware that althought Dataguard Broker works with Serviceguard Extension for RAC, it *does not* work with a cold-failover database configured in a Serviceguard cluster.

Other important points to consider with RAC databases in a Dataguard configuration:

i) Be aware t6hat only one node on the standby database is doing log apply, so if you are using RAC for performance, ypu might find that the Dataguard database can't keep up, as it is trying to apply logs for more than one instance at the source...

ii) Try not to use any Dataguard mode which uses synchronous log shipping. (I think this is the maximum availability and maximum protection modes). In synchronous mode, if one of your source RAC nodes is down, then all nodes will stop sending data to the standby (as in synchronous mode the logs have to be applied in order and acknowledged) - i.e. if you lose local HA, you also use remote DR.

HTH

Duncan

HTH

Duncan
Duncan Edmonstone
Honored Contributor

Re: Oracle 11g RAC along with Oracle Data Guard

ach... too early for me. I meant to say:

if you lose local HA, you also lose remote DR

HTH

Duncan

HTH

Duncan