Re: Replication question
- From: kathryn axelrod <kat.axe@xxxxxxxxx>
- To: saad4u@xxxxxxxxx
- Date: Wed, 5 May 2010 09:07:30 -0700
Do you plan on having your reporting db as read-only?
If so, I'd suggest looking into a logical Data Guard standby. Configuration
and maintenance would be much easier than setting up Streams. However, if
you need a r/w db, you will likely need to go the route of Streams.
DG and Streams are both included in the EE license, but you have to
individually license each db server involved in the configuration. So in
your case, with a prod db and a mirror db, you would have to purchase two EE
licenses.
As for Active DG - 1. it costs extra (surprise!) and 2. it's not available
on 10g.
---
PS - while I was typing this, William posted a reply that makes a good point
- do you need real time data?
On Wed, May 5, 2010 at 8:44 AM, Saad Khan <saad4u@xxxxxxxxx> wrote:
> We have a request from the business to create a reporting database from
> production which is 10.2.0.4 on AIX 5.3. The reporting DB should be a
> mirrored copy of production, in other words the prod should be live
> replicated to this new reporting DB.
>
> I've some questions as I'm not aware of replication tools available for
> oracle:
>
> 1) What is the best tool availabe for the replication in oracle? Please
> remember we have to replicate entire database which is around 1T, not just
> few tables.
> 2) I read something about Oracle streaming or down stream option, but I
> dont see it in the oracle licenses price list. Do we have to get a separate
> license for that or is it a part of Enterprise edition? How much would it
> cost?
> 3) If we install this streaming option, do we have to install its agent on
> both source as well as target DBs? I assume it means getting two licenses.
> This can be a costly option if its for both.
> 4) As per my knowledge, Active data guard also has this option of
> replication. Again, do we have to install its agent both at source as well
> as target?
>
> Appreciate your responses.
>
> Thanks,
>
> Saad
>
Other related posts:
