Re: Oracle Replication (Multi master or Snapshot)

Michael Kelly wrote:

> We are looking at setting up Oracle replication to replicate our
> financial system database to another server (connected via switched
> 100 MB ethernet) at the same location so that we can perform ad-hoc
> reporting against the replicated database and not affect performance
> of the OLTP financial system.
>
> We have a requirement that the data be replicated near real time.
> Because the replicated database will only be used for reporting then
> it only need to be read-only.
>
> My question is, based on the requirement of near real time replicated
> data and the read only use of the replicated database, should we go
> with the multi-master setup (for near real time data replication) or
> with the read-only snapshot? My preference is to go with a read-only
> snapshot but not sure if that setup will support near real time
> replication. What is a reasonable short timeframe for snapshot
> refresh (every 5 minutes, 10 minutes, 15 minutes, etc)?
>
> Thanks in advance for your comments/suggestions.

Have your managment define "real-time".

And how much data, how many transactions, per minute.

Don't forget that you can make any database read-only by only letting users access through a read-only login.

GRANT CREATE SESSION TO ...
GRANT SELECT ON ... TO ... and nothing else.

Daniel Morgan Received on Fri Jan 17 2003 - 10:55:53 CST