(from the mouth of a replication non-quru)
I think you answered your own question. If no network and they want to be
up, then synchronous replication is not an option. You're only option is
asynchronous replication.
One answer that I'm sure EMC would luv to sell you is networked raw disks
in conjunction with Oracle Parallel Server (OPS/RAC). If cost is not a
problem, then EMC has the solution. It's not their company slogan/mission
statement, but it should be. In this scenario you may lose a node but you
can trade the problems of asynchronous replication conflict detection and
resolution (and maintaining multiple databases), for the OPS locks and
false ping problems. If given a choice, I'd take the OPS problems.
Brian P. MacLean
Oracle DBA, OCP8i
"Freeman,
Robert " To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
<Robert_Freema cc:
[EMAIL PROTECTED]> Subject: RE: Stand-by (Oracle9i Data
Guard) vs. Replication
Sent by:
[EMAIL PROTECTED]
om
03/25/02 10:48
AM
Please respond
to ORACLE-L
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
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-----Original Message-----
Sent: Monday, March 25, 2002 11:48 AM
To: Multiple recipients of list ORACLE-L
What type of requirement or SLA do you have in regards to keeping the
instances in sync?
-Joe
--- "Freeman, Robert " <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Freeman, Robert
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
