Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Design/Recovery Questions on Two-Phase Commit (2PC) Protocol
Thanks for your replies. I'm see the following on the Oracle
replication FAQ:
Basic replication is implemented using standard CREATE SNAPSHOT or CREATE MATERIALIZED VIEW statements. It can only replicate data (not procedures, indexes, etc), replication is always one-way, and snapshot copies are read only.
Advanced replication supports various configurations of
updateble-snapshot, multi-master and update anywhere replication. It is
more difficult to configure but allows data and other database objects
like indexes and procedures to be replicated.
--- END ---
BASIC replication is apparently "always one-way", where as ADVANCED
replication supports "update anywhere replication". In my previous
example, with 3 databases, would advanced replication mean that changes
to any database would be applied to the remaining two? Here's a crude
ASCII drawing, that really is pretty useless, but is included as I
spent 5 minutes on it...
[DB1] update triggers DB2 & DB3 update / \ / \ / \ / \ / \ / \
![]() |
![]() |