RF,
Looks like you are looking for something like
quest software's shareplex. A cool tool, although, on
the expensive side. It has the ability to replicate
with least intrusion and perf impact. ( Or thats what
they say...:) )
And no....I am not working for quest software...!
Cheers,
RS
- "Freeman, Robert " <Robert_Freeman_at_csx.com> wrote:
> 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 " <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).
> --
> 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: Sakthi , Raj
INET: rajan_sakthi_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 - 13:53:36 CST
