Thanks Paul, Paul Baumgartel wrote: > > My mistake, it's the doc set that came with 9.2.0.2.0: > > download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ls.htm#1073769 > > --- Joan Hsieh <[EMAIL PROTECTED]> wrote: > > Hi Paul, > > > > Do you have url handy on the subject how to setup the logical standby > > database? I had trouble to find the 9.2.3 doc. I really appreciate > > for > > your help. > > > > Joan > > > > Paul Baumgartel wrote: > > > > > > We were going to use logical standby but quickly abandoned the idea > > > after testing. > > > > > > 1. The APPLY process on the standby crashed regularly (every 10 > > > minutes or so). Oracle claimed it was a fixed bug, but there was > > no > > > port to Windows, so we'd have had either to wait for the next RDBMS > > > release or request a patch...with implementation a month or so > > away, we > > > didn't want to take the chance. > > > 2. DDL in the apply stream is problematic, also causing apply > > slave > > > crashes. > > > 3. Performance of the apply slave is horrendous. Since Logical > > > Standby uses LogMiner to construct SQL statements from redo > > > information, and since redo information consists of block change > > > vectors, a 10,000-row delete in the redo becomes...10,000 DELETE > > > statements in the apply process. I found that the time for > > application > > > of changes on the standby was about an order of magnitude greater > > than > > > the time taken for the original changes on the master; and this was > > > after applying a few (but not all) of Oracle's standby tuning > > > suggestions. > > > > > > Also, we are planning to use Oracle Label Security, but it is not > > > compatible with Logical Standby. > > > > > > There are a number of Documentation bugs (including bugs in Notes > > > posted on MetaLink that are supposed to correct earlier Doco bugs!) > > in > > > the sections regarding how to set up a logical standby; be sure you > > > follow the 9.2.0.3.0 docs' instructions for that. Don't use the > > notes > > > on MetaLink! > > > > > > Now, for the good stuff. > > > > > > Well, it worked sometimes.... > > > > > > Really, it's a brand-new feature, and performs as brand-new Oracle > > > features typically do--it's buggy and it's slow. > > > > > > Well, > > > > > > --- "Loughmiller, Greg" <[EMAIL PROTECTED]> wrote: > > > > folks - > > > > listening to a preso from a vendor where they will use logical > > > > standby to > > > > accomplish some of the 99.999999999999999 availability > > > > requirements... so > > > > I'm wondering, does anyone have some extensive experience with > > the > > > > logical > > > > standby to share? the good stuff, the bad stuff, pitfalls, > > gotcha's, > > > > and > > > > general things to run away from.. Then on the other hand-what > > things > > > > should > > > > someone try to leverage? > > > > > > > > thanks in advance! > > > > > > > > > > > > Greg Loughmiller > > > > > > > > > > > > > > > > > > ===== > > > Paul Baumgartel > > > Transcentive, Inc. > > > www.transcentive.com > > > > > > __________________________________ > > > Do you Yahoo!? > > > Yahoo! SiteBuilder - Free, easy-to-use web site design software > > > http://sitebuilder.yahoo.com > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Paul Baumgartel > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > > San Diego, California -- Mailing list and web hosting > > services > > > > > --------------------------------------------------------------------- > > > 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.net > > -- > > Author: Joan Hsieh > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > 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! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Paul Baumgartel > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > 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.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
