Oracle-L: Stand-by (Oracle9i Data Guard) vs. Replication

From: Freeman, Robert <Robert_Freeman_at_csx.com>
Date: Mon, 25 Mar 2002 07:33:24 -0800
Message-ID: <F001.00431FA6.20020325073324@fatcity.com>

Stand-by (Oracle9i Data Guard) vs. Replication

Folks,

I have a mission critical system we are architectonic right now. There is some argument of the merits of replication vs. using Standby database going on.

Current we have 4 sites that we will be replicating data back and forth between. There are 3 kinds of data:

Network Critical data (must be available for entire network)
Regional Critical data (only used for a given region. site = region).
Regional non-critical data (this is data that is easily recovered from other operational data stores).

I can load you up with details, but for now this is the general requirement. We want a given site to be able to work independently of the other sites in the event of network failure (WAN).

What I'm looking for is your experience with using replication for HA solutions vs. stand-by databases. I've also considered using standby databases as a possible solution to this problem, along with using transportable tablespaces to re-sync the databases once everything comes up. I'm concerned with replication in that there is allot to break, and I'm concerned about synchronization issues in general with either solution.

Thoughts?

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

The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Freeman, Robert
INET: Robert_Freeman_at_csx.com

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). Received on Mon Mar 25 2002 - 09:33:24 CST