Re: rac vs dataguard
From: Kumar Madduri <ksmadduri_at_gmail.com>
Date: Thu, 16 Jul 2009 09:17:31 -0700
Message-ID: <a2b1e7610907160917u2e5ab2e7t40d2c43f732fc1a9_at_mail.gmail.com>
Even if you add a 3rd node, it would be accessing the same database and if the reporting user requirements are quite opposite to that of online users, there would probably be performance issues. But the otehr side, is you can probably change the init.ora parameters for third instance to match the reporting user requireents. But not sure how much this would help actually in terms of sql tuning. Like Nial pointed it depends on schema design and usage
Date: Thu, 16 Jul 2009 09:17:31 -0700
Message-ID: <a2b1e7610907160917u2e5ab2e7t40d2c43f732fc1a9_at_mail.gmail.com>
Even if you add a 3rd node, it would be accessing the same database and if the reporting user requirements are quite opposite to that of online users, there would probably be performance issues. But the otehr side, is you can probably change the init.ora parameters for third instance to match the reporting user requireents. But not sure how much this would help actually in terms of sql tuning. Like Nial pointed it depends on schema design and usage
- kumar
On Thu, Jul 16, 2009 at 4:44 AM, ed lewis <eglewis71_at_gmail.com> wrote:
> Hello,
> We are planning to implement a 2 - node rac cluster, EE 10.2.0.4,
> solaris 10,
> using ASM.
> The plan is to also use dataguard to create a logical standby db for
> reporting.
>
> I was considering the idea of creating a 3rd member of the rac cluster,
> and
> dedicate it to reporting, instead of using dataguard. There would be the
> additional
> cost for rac, but the adminstration may be simpler.
>
> Has anyone done this ? What are the pros and cons ?
>
> Thanks for your feedback.
>
> ed lewis
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 16 2009 - 11:17:31 CDT