Re:RE: Stand-by (Oracle9i Data Guard) vs. Replication

Robert,
 I think it is possible to use "RAC" where the corporate data is located on a SAN accessible to all and each region has their own storage that they have "RAC'd" with the rest of the organization. If one region dies each region continues to function. If the corporate office dies each region continues to function. It sounds complicated and requires fast inter-connectivity between each region and the SAN. Sound reasonable?
ROR mª¿ªm

>>> dgoulet_at_vicr.com 03/25/02 02:38PM >>>
Robert,

    Given what you've said it would appear that your only choice is going to be
symetric/advanced replication, multi-master. The conflict resolution rules may
be a bear to set up with 5 sites though. Using a standby db would not be very
effective since data updates are dependent on the archive log switch points and
that does not address the different sites if your reason for failure is a
network related one. Snapshots won't work either since they are read only.

Dick Goulet

____________________Reply Separator____________________
Author: "Freeman; Robert " <Robert_Freeman_at_csx.com>
Date:       3/25/2002 9:48 AM

Pretty stringent. They want as little latency as possible. Changes at a master should be available to all sites ASAP. Now, they could all go to one central site, and thats ok as long as our networking is healthy,
but if it goes down, there is a requirement that they be able to work independently (there are 4-5 sites) and then all changes need to be synchronized. Data loss is secondary to availability however.

These requirements smack of trouble to me.

Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).