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 <joan.hsieh_at_tufts.edu> 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" <Greg.Loughmiller_at_cingular.com> 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: treegarden_at_yahoo.com
> >
> > 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: 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.net
> --
> Author: Joan Hsieh
> INET: joan.hsieh_at_tufts.edu
>
> 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: 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! 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: treegarden_at_yahoo.com
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: 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 Aug 04 2003 - 18:24:23 CDT
