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@xxxxxxxx> 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@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *John Kanagaraj
> *Sent:* Sunday, August 05, 2007 12:13 AM
> *To:* anelson77388@xxxxxxxxx
> *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@xxxxxxxxx> 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 **
>

Other related posts: