Replication accross a WAN

Hi

Could anyone point me towards resources detailing standard Oracle techniques for replicating accross a low(ish) bandwidth wide area network. We want to keep two databases in synch. Synchronous replication is not critical, but replication must be bi-directional (i.e. inserts on db1 replicated to db2 and inserts on db2 replicated to db1 simultaneously). Are there robust, cost effective commercial packages available? Is it more effective to write your own scheme based on expert knowledge of the schema and applications?

Currently the proposal is to write our own. One things that's bugging me is that the data in each database is meant to be identical, including fields that are modified by triggers, (setting last modified field to sysdate, primary key to a sequence numver etc.). But how do you keep the sequences in step? If sequence is initially in step and a different record is inserted at each site, the different records will end up with the same sequence number?

Any comments will be appreciated

Dave Waterworth

Power Systems Consultants New Zealand Ltd Received on Thu Oct 21 1999 - 07:54:54 CDT