Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Resurrecting a failed node (Oracle MM replication)
Consider a scenario where there are replicated Oracle databases at 3
network nodes, say san francisco, new york and london, operating as
peers in a Multi-Master replication environment. Say timestamp based
conflict resolution is used for essentially all conflicts.
Now say there is a disaster at San Francisco (you know those 'quakes), and a redo log recovery is required, which brings the SF database back to 1 hour prior to the point of the failure. That is, the last hour's worth of updates aplied to the SF node database are lost.
My question is how can/does the SF node database get back in sync with the database at the other two nodes?
Thanks,
![]() |
![]() |