Re: Replication

Aric Rosenbaum wrote:
>
> We are currently planning an Oracle installation and are thinking about
> using replication. We have six offices around the world connected via
> X.25 (now) and Frame Relay (future).
>
> I have been warned off of replication due to the communications
> overhead. One integrator told me I would multiply my comm. costs by
> 10x. Also, comm. in some of our locations is less than reliable. Heck,
> its a feat if we get electricity for a whole day.
>
> Does anyone have some insight? Does Oracle replication require a
> full-time connection?
>
> Workarounds?
>
> Thanks in advance.
>
> -- Aric

Oracle's Symmetric Replication provides a number of options, including updateable snapshots, row-level replication, multi-masters, etc., via either synchronous (2PC) or asynchronous propagation. For your particular need, I would recommend async propagation as that provides a fault resilent store and forward approach protected by 2PC whereby any remote outage would merely be saved by the propagating site until the remote site becomes available.

I always love the comments by third party so-called experts that make outlandish claims of, in this case, a 10x increase in network bandwidth required to support replication without having to provide one shread of supporting documentation.

-- 
Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA
The above statements and opinions are my own and do not
necessarily represent those of Oracle Corporation.