Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Replication between servers that are intermittantly connected

Replication between servers that are intermittantly connected

From: Dougie McGibbon <DMcGibbon_at_tollnz.co.nz>
Date: Fri, 3 Jun 2005 11:19:33 +1200
Message-ID: <102F3E6C89C4A04BBFFB37EE614BBFC908AD19@kinglet.trl>


I have an interesting scenario I'm working on and I'd like some feedback if anyone's ever had to cope with something similar. Three oracle servers replicating data to a master fourth system, with a subset of the master data being replicated back. The servers are not always connected to the network. The network connection comes and goes in a semi random manner, although once the connection has been up for more than around 20 minutes, it's likely to stay up for two or three hours before going down again.

My original thoughts were to ship data back and forwards using IBM's Message Queue (which we already use throughout the company) and write a load/merge process to load the data - but after reading up a bit about Oracle Streams, I'm starting to think that I might be able to do it all within an Oracle environment. Does anyone have experience using streams in an unstable environment like this ?

The servers themselves and the DBs on them stay up all the time - it's the actual network link I'll loose.

Dougie McGibbon

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 02 2005 - 19:24:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US