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.

Apart from what Daniel and Michael explained, there is a penalty in replication, tho not as heavy as reporting off the same instance.
Apart from that, MM as well as MV (or snapshot) replication offer the possibility of near real-time (mind you, near!) replication.
But, as there is absolutely no reason for MM replication (the 'other' instance will not be updated by your financial application!), I would refrain from that option.

You can even build a DW, using this technique, inclusive data clean-up, enrichment, (R)OLAP, etc.

Frank Received on Fri Jan 17 2003 - 13:58:03 CST