FAQ
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@cambiahealth.com

Search Discussions

  • Guillermo Alan Bort at Feb 3, 2012 at 4:38 pm
    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 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@cambiahealth.com
    --
    http://www.freelists.org/webpage/oracle-l


    --
    http://www.freelists.org/webpage/oracle-l
  • Hameed, Amir at Feb 3, 2012 at 4:54 pm
    We are running Oracle Streams where we are streaming selective tables
    from four different Oracle ERP systems geographically located at
    different locations (US, EU). Tables are getting streamed to a central
    database. What we seen is that:
    - Streams APPLY will need to be tune to get a good performance.
    Initially we had issues with the APPLY speed but once APPLY was tuned,
    tables are staying in synch most of the time.
    - The main issue is with the long running transactions where we have
    seen that APPLY lags behind by several hours on large spilled
    transactions. According to Oracle, this is a limitation of Streams and
    the solution is to run those batch jobs directly against the APPLY
    database.

    -----Original Message-----
    From: oracle-l-bounce@freelists.org
    On Behalf Of Guillermo Alan Bort
    Sent: Friday, February 03, 2012 11:38 AM
    To: regdba@yahoo.com
    Cc: Oracle-l
    Subject: Re: Oracle Streams

    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 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@cambiahealth.com
    --
    http://www.freelists.org/webpage/oracle-l


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


    --
    http://www.freelists.org/webpage/oracle-l
  • Ujang Jaenudin at Feb 4, 2012 at 1:10 am
    Recently I run the streams for a small banking industry,
    well during transaction, sync was very stable (around 20 tps)

    during batch, apply site lag around 6 hours :(
    at the apply side, I put scheduler + procedure to fix the apply error,
    and yes there is unreasonable error during transaction
    but this scheduler can fix all the time ( it was set up 10 secs interval).

    On 2/3/12, Peter Barnett 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@cambiahealth.com
    --
    http://www.freelists.org/webpage/oracle-l


    --
    thanks and regards
    ujang jaenudin | independent consultant
    http://ora62.wordpress.com
    http://blog.dbs247.com
    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedFeb 3, '12 at 3:51p
activeFeb 4, '12 at 1:10a
posts4
users4
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase