This discussion is archived
1 Reply Latest reply: Apr 17, 2012 6:25 AM by hitgon RSS

Bulk on-demand replication

860176 Newbie
Currently Being Moderated
Hello,

I am responsible for a scientific visualization application at my company. The app is 2-tier with a C# fat client talking to Oracle 11g. We are getting ready to deploy the app globally and need to come up with a replication strategy as we have found that performance is unacceptable when the client and database are separated by a WAN. Currently, experimental data are loaded in batches of up to 10G using SQLLDR through the direct path. We would like to set up a staging database that would enable us to examine the data before it goes into production. When the data have been certified, we would like to transfer new records on-demand in bulk to multiple replicate databases globally over the WAN. We would like to be able to roll back or recover from data transfer errors.

I have limited experience with Oracle replication and would appreciate suggestions of products, technologies, or strategies that would meet our needs, which seem different from typical transactional replication.

Thanks!
  • 1. Re: Bulk on-demand replication
    hitgon Expert
    Currently Being Moderated
    Hi,

    There are lots of solutions available

    You can think and use the possible solutions for your scenarios.

    1.) Data Pump Network Exports/Imports
    http://www.oracle-base.com/articles/10g/oracle-data-pump-10g.php#NetworkExportsImports

    2.) Data replication using DBMS_COMPARISON

    http://nadvi.blogspot.in/2011/11/data-replication-using-dbmscomparison.html
    http://www.bash-dba.com/2012/02/data-synchronization-replication-using.html

    3.) Complete Schema Refresh using Data Pump
    http://www.in-oracle.com/Oracle-DBA/DBA-I/schema-refresh-Data-Pump.php

    4.) Oracle Golden Gate

    5.) Oracle Streaming

    Let you know if any query the same :)

    Thanks
    Hitgon

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points