Re: Replicating E-Business Suite for Reporting

I think you meant #2 rather than #3 and me rather than John. Availability: In the case where a node fails, the other nodes can still run. In the case of some patches, individual nodes can be patched one by one without bringing the RAC as a whole down.

Thanks,
Allan

On 8/7/07, Michael W. Fontana <m.fontana_at_ntta.com> wrote:
>
> John
>
> On item #3 below:
>
> Please explain how using RAC will give you increased availability. RAC is
> a scalability solution; it adds little in terms of availability, your
> dataguard solution is probably covering that.
>
>
> Michael Fontana
> Sr. Database Administrator
> NTT America
> P:214.853.7405
> M:214.912.3705
>
>
> ------------------------------
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *On Behalf Of *John Kanagaraj
> *Sent:* Sunday, August 05, 2007 12:13 AM
> *To:* anelson77388_at_gmail.com
> *Cc:* oracle-l
> *Subject:* Re: Replicating E-Business Suite for Reporting
>
> Allan,
>
> EBS has thousands of tables that are potentially updated frequently (and
> which ones are and which ones aren't is not that well documented). In this
> scenario, an LSB/Streams scenario may be difficult to implement given the
> number of objects. I would recommend a PSB where you switch between
> reporting and log application.
>
> John
>
> On 8/3/07, Allan Nelson <anelson77388_at_gmail.com> wrote:
> >
> > Hello All,
> >
> > I am working on a project to create a reporting environment from an
> > Oracle E-Business suite database that will be at 10.1.0.5 by the time
> > the reporting project takes off. The source database is on HP-UX 11.11and is about 750GB in size. In the generic sense of requirements this is
> > what I would like to do:
> >
> >
> > 1. The target will be a copy of the source without applying data
> > warehouse techniques. I will be able to add a few indexes or views.
> > 2. I would like to use RAC on Redhat Linux as the target platform
> > both for availability reasons and lease termination reasons .
> > 3. If at all possible I would like to use 10gR2 for the target
> > database
> > 4. I cannot upgrade the source to 10gR2.
> >
> > I was thinking about using a logical standby and still am, but I would
> > have to do that all on HP. According to the DataGuard docs the platforms
> > have to be the same with regard to OS flavor but not with respect to
> > hardware.
> >
> > I'm not adverse to Streams or a third party solution and I would like
> > some pointers on where to start researching. I'm reading up on Streams now.
> >
> > I know this is vague but it is what I have at present.
> >
> > Thanks in Advance
> > Allan Nelson
> >
>
>
>
> --
> John Kanagaraj <><
> DB Soft Inc
> http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!)
> ** The opinions and facts contained in this message are entirely mine and
> do not reflect those of my employer or customers **
>

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