Re: Question on Oracle 11G RAC

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Tue, 9 Nov 2010 07:28:23 -0600
Message-ID: <AANLkTika0PA1-9B4_aYsOTA1GsyN_SS8za2jtoNo_PgO_at_mail.gmail.com>

That approach would work, but in 11GR2 you can active dataguard with real time apply, which allows you to have the standby open in read only while the logs are being applied. That seems to be what you really want.

On Tue, Nov 9, 2010 at 2:24 AM, Sreejith S Nair < Sreejith.Sreekantan_at_ibsplc.com> wrote:

> Hi friends,
>
> I have got this question from customer regarding Oracle 11G R2 RAC.
>
> The customer have stated a preference for configuring the Oracle RAC nodes
> so that, in a two node system, the first node bears all the update load,
> whereas the second RAC node would have connections that are read-only. The
> two nodes would still operate as failovers for one another. The reason for
> this , they stated was to reduce network traffic between the nodes to
> coordinate transactions and locking. They have asked for this configuration
> as 'one update node and one read-only node' / a primary update node and a
> secondary read-only node .
>
> We have thought about implementing this configuration for our two
> applications as follows
>
> Application features
>
> Application 1 - which performs regular updates,heavy transactions,long
> running reports et - schema 1
> Application 2 - performs smalled updates and small reads. - schema 2
>
> Application 1 can point to node 1 of this RAC and application 2 to node 2 (
> using node affinity ).When any of the node fails , the client connections
> will fail over to surviving node.
>
> I would like to get some recommendations on this approach from experts.
>
> 1) Do you think the above approach using node affinity is a good approach ,
> ie pinning one schema in one node with one database for a two instance(node)
> RAC ?
> 2) Any documents / reference to configure this approach in RAC ?
> 3) Is there any other way to achieve the requirement put by the customer ?
> 4) If the above said nodes are in two data centres, Will it be a
> recommended approach ? I think these two nodes should be in same data
> centre.
> 5) If we configure Load balancing ( in normal RAC or in the setup mentioned
> above) then that would take considerable network b/w ?
>
> OS is RHEL 5.4 on 64 bit.
>
> Please share your view on this.
>
> Thanks ,
> SSN
>
>
>
>
>
>
>
> DISCLAIMER:
>
> "The information in this e-mail and any attachment is intended only for the
> person to whom it is addressed and may contain confidential and/or
> privileged material. If you have received this e-mail in error, kindly
> contact the sender and destroy all copies of the original communication. IBS
> makes no warranty, express or implied, nor guarantees the accuracy, adequacy
> or completeness of the information contained in this email or any attachment
> and is not liable for any errors, defects, omissions, viruses or for
> resultant loss or damage, if any, direct or indirect."
>
>
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 09 2010 - 07:28:23 CST