Re: Oracle Streams

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Fri, 3 Feb 2012 13:37:36 -0300
Message-ID: <CAJ2dSGQgr4mP7vr_iRCVPUjUwv7gwdVZWN4+WFpuYw_E6xXeiQ_at_mail.gmail.com>

You can try GoldenGate (though I've had some problems with it) or look into Active DataGuard (which is a pretty expensive option) There's also the posibility of using MViews on a DB Link if you have a stable and private link between the two sites... I have seen this working several years ago, on 9i databases. I think they called it advanced replication or something like that. It's a lot of work to set up, but once it's there it's pretty easy to maintain. And the 10g scheduler is far better than the dbms_jobs that 9i had for scheduling the refresh operations.

hth
Cheers
Alan.-

On Fri, Feb 3, 2012 at 12:48 PM, Peter Barnett <regdba_at_yahoo.com> wrote:

> We are looking at keeping a remote database at a vendor site updated.
> Timing is not terribly critical since one of the options is running a
> batch ETL job on a daily basis.
>
> Another option is to use Oracle Streams. Our previous experience with
> this product has not been very positive but that has been several years
> ago. It was high maintenance for the DBA and we had a problem on the
> target server maintaining RI without disabling a lot of triggers.
>
> Given the choices, has Streams improved enough to reconsider it?
>
> Pete Barnett
> Database Technologies Lead
> Cambia Health Solutions
> peter.barnett_at_cambiahealth.com
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Fri Feb 03 2012 - 10:37:36 CST