RE: HA Architecture Plus + Reporting Purposes
- From: "Steve Kirby" <kirby@xxxxxxxxxxxxxxxxxxx>
- To: <ora-apps-dba@xxxxxxxxxxxxx>
- Date: Fri, 30 Dec 2011 14:25:02 -0800
If your system is buried under Discoverer reports I would take a look at
tuning the Discoverer reports, running them after hours or getting better
hardware.
I would only consider going to RAC if you truly had maxed some heavy
hardware (i.e. 2TB+ RAM. 8+ CPU/32 core, etc.). The complexity is a real
pain and the licensing fees are really high.
There *is* a benefit to isolating a Server so that the load does not bled
into production, but, at least with most of my clients, the Discoverer
reports are as important as the OLTP aspects.
And you hit the nail on the head for DataGuard - read only. Some reporting
could be done on that server, but probably a lot less than you think.
Lastly - While not all data types are cloned by Streams or GoldenGate for
discoverer reporting I think it would work. Not many LOB or CLOBS in the
data my clients used.
See:
http://blogs.oracle.com/stevenChan/entry/using_oracle_goldengate_with_oracle
Note: While I have experience with EBS and RAC/data guard I have not
implemented Streams or GoldenGate (I did do shareplex many moons ago
(shudder)). Someone else with RealWorldT experience with those products may
be able to step in.
Steve
From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of
EKhramtsova@xxxxxxxxxxxxx
Sent: Friday, December 30, 2011 1:58 PM
To: ora-apps-dba@xxxxxxxxxxxxx
Cc: oaugnetdba-on@xxxxxxxx; ora-apps-dba; ora-apps-dba-bounce@xxxxxxxxxxxxx;
oracle-l
Subject: Re: HA Architecture Plus + Reporting Purposes
Some comments:
1) Discoverer connection is read/write, so you will not be able to run
Discoverer off active standby.
2) Golden Gate is not certified to replicate EBS database as a whole. It
cannot work with some datatypes used in EBS
3) RAC with dedicated node for reports will work, but how well it will
depend on what an application is doing
4) See #2
Elena Khramtsova
Technical Lead, Production DBA
Ritchie Bros. Auctioneers
Ph: 778-331-5347
Cell: 604-616-0068
email: ekhramtsova@xxxxxxxxxxxxx
From:
Avadhani mys <avadhanimys@xxxxxxxxx>
To:
ora-apps-dba <ora-apps-dba@xxxxxxxxxxxxx>, oracle-l
<oracle-l@xxxxxxxxxxxxx>, oaugnetdba-on@xxxxxxxx
Date:
12/07/2011 12:38 PM
Subject:
HA Architecture Plus + Reporting Purposes
Sent by:
ora-apps-dba-bounce@xxxxxxxxxxxxx
_____
Hi Gurus,
We are planning to propose a solution to avoid bottleneck on
performance from reporting[Discoverer Reports] job runs on a database.
As we are aware that with any High Availability Architecture, there
will be single point of DB connection for any reporting job runs. We
are thinking about 3 strategies to propose listed below. Can you
please shed light on Advantages/Disadvantages of each approach based
on your experience or any approach which can solve/address High
Availability and Performance.
1) Data Guard - Pure Disaster Recovery Solution. Leverage Active
Standby for Reporting purposes (Partial only for 100% read only
reports)
2) Golden Gate Replication Technology to replicate Data Secondary
site and using Secondary site for reporting purposes.
3) RAC - High Availability Solution with additional node to be used
for Reporting purposes.
4) RAC - High Availability Solution with Golden Gate Replication
Technology to replicate Data Secondary site real time for reporting
purposes. Any HA/DR gains from this point?
Your help will be really helpful in determining the best feasible approach.
Thanks in Advance.
Regards,
Avadhani
Other related posts:
