1 Reply Latest reply: Apr 17, 2012 8:25 AM by hitgon RSS

    Bulk on-demand replication

    860176
      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
          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