Thanks! John P Weatherman Database Administrator Replacements Ltd.
-----Original Message----- Sent: Friday, June 14, 2002 4:10 PM To: Multiple recipients of list ORACLE-L Cross-platform is the whole reason for logical standby -- it's SQL statements that get applied to the secondary database --- John Weatherman <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 06/14/2002 09:50 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > 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: [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). > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: John Weatherman > > 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! - 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: [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 > === 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: [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: John Weatherman 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).