Re: Replicated Databases

Hi Carlos,
You actually have a couple of choices:
1) Oracle parallel server -- provides you transparent database replication. An expensive option which also requires a tightly coupled computing enivronment.

2) Distributed computing -- insert, update, delete into multiple datbases. Very clumsy in a production environment.

3) Table-based Replication -- post-trigger to send the records to a queue for the replication manager to post to the other databases. Very slow in Oracle7 (PL/SQL based); Much better in Oracle8 (C library)

4) Snapshot database updated with archivelogs. Probably you easiest solution because of the query-only environment in the snapshots. You simply and automatically apply the archivelog to the query-only databases to incrementally bring them up to the latest point-in-time when the logs are switched. The log switching can be made small or large or manually performed based on you particular OLTP environment.

--
Hope this helps
Don Received on Tue Mar 30 1999 - 08:18:47 CST