What type of requirement or SLA do you have in regards to keeping the
instances in sync?
-Joe
- "Freeman, Robert " <Robert_Freeman_at_csx.com> wrote:
> 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:
>
> 1. Network Critical data (must be available for entire network)
> 2. Regional Critical data (only used for a given region. site =
> region).
> 3. 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?
>
> RF
>
>
> 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).
Do You Yahoo!?
Yahoo! Movies - coverage of the 74th Academy Awards®
http://movies.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe Raube
INET: jraube_at_yahoo.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 - 10:48:23 CST
