Cross-platform is the whole reason for logical standby -- it's SQL
statements that get applied to the secondary database
- John Weatherman <john.weatherman_at_replacements.com> wrote:
> All very true. Of course the doc in question was written for 8i, so
> that
> explains some of it. :) Question: Does logical standby in 9.2 work
> across
> platforms? Haven't had too much time to look at new 9.2 features I'm
> afraid.
>
> John P Weatherman
> Database Administrator
> Replacements Ltd.
>
>
>
> -----Original Message-----
> Sent: Friday, June 14, 2002 2:57 PM
> To: Multiple recipients of list ORACLE-L
>
>
> or you can use the logical standby feature of 9.2 and then have both
> databases open.
>
> Replication bothers me when I start to think about synchronous vs
> asynchronous. Async doesn't "hold up" the primary site from
> continuing
> on, but the databases are not true copies of one another. Sync are
> true
> copies but you can hold up the commit waiting for a return from the
> remote site.
>
> And if it fails, it's messy to clean up
>
>
> --- John Weatherman <john.weatherman_at_replacements.com> wrote:
> > Jarad,
> >
> > A standby is simpler, however it has limited use for offloading
> some
> > system load (opening for read access suspends roll forward, so the
> > data is somewhat stale). By using Master-Master synchronous
> > replication
> > with good deadlock handlers, you can use BOTH instances so you get
> > the
> > benefit of not having an unused instance lying around (damagement
> > hates
> > that), but still have fail over available. Since you can have
> > different
> > users/locations attach to different instances, you also get some
> > scalability advantages.
> >
> > In general, I agree a standby is MUCH simpler.
> >
> > John P Weatherman
> > Database Administrator
> > Replacements Ltd.
> >
> >
> >
> > -----Original Message-----
> > Sent: Friday, June 14, 2002 1:41 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Curious, that note suggests Advanced Replication as a failover
> > methodology.
> >
> > Seems that a standby database would be _much_ simpler.
> >
> > Any thoughts ( from anyone ) on why one would use AR for failover,
> > rather
> > than using a standby database?
> >
> > Jared
> >
> >
> >
> >
> >
> > John Weatherman <john.weatherman_at_replacements.com>
> > Sent by: root_at_fatcity.com
> > 06/14/2002 09:50 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > cc:
> > Subject: RE: Replication question
> >
> >
> > Mitchell,
> >
> > There are a LOT of good papers in Metalink. I've been getting my
> own
> > education over the last few months. Replication is a really great
> > swiss
> > army knife though, you need to do a little looking for what you
> > specifically
> > need to do, then test, test, test. Oh, and did I mention test? :)
> I
> >
> > found
> > Note: 138181.1 particularly helpful. Oh, and plan on some TARs. I
> > have
> > found Support very helpful/informative in this area.
> >
> > Good Luck,
> >
> > John P Weatherman
> > Database Administrator
> > Replacements Ltd.
> >
> > -----Original Message-----
> > Sent: Friday, June 14, 2002 12:05 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi all
> >
> > I will work on replication soon. any advice for reference I can
> get.
> >
> > Thanks in advance.
> >
> > Mitchell
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: John Weatherman
> > INET: john.weatherman_at_replacements.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:
> > INET: Jared.Still_at_radisys.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: John Weatherman
> > INET: john.weatherman_at_replacements.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! - Official partner of 2002 FIFA World Cup
> http://fifaworldcup.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_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
>
=== message truncated ===
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_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 Fri Jun 14 2002 - 15:09:30 CDT
