there was a thread -- Paul Baumgartel started it looking for
information on logical standby.
IIRC, he found that there were a few "gotchas" -- check the fatcity
archives.
I do know that since it's based on Logminer technology, it has the same
limitations that Logminer does
- Walt Weaver <wweaver_at_rightnow.com> wrote:
> Stephane,
>
> What sort of problems can one expect from logical standby?
>
> I'm toying with the idea of using it as a replication database -- no
> additional schema objects will be created, but users will have
> read-only
> access to it. It's one of the options I'm looking at.
>
> Seems to me like there was a thread on this a few months ago, but I'm
> not sure...
>
> --Walt
>
> On Wed, 2003-11-12 at 09:49, Stephane Faroult wrote:
> > Jose Luis,
> >
> > What you say refers to the physical standby database (which works
> well),
> > not to the logical standby database (which on the paper looks
> great, allows you to open the database, create additional
> tablespaces, create additional indexes on replicated objects etc) but
> which in practice still has a lot of teething troubles. Wouldn't use
> it in production on Oracle 9.2.
> >
> > HTH,
> >
> > SF
> >
> > >----- ------- Original Message ------- -----
> > >From: Jose Luis Delgado
> > ><joseluis_delgado_at_yahoo.com>
> > >To: Multiple recipients of list ORACLE-L
> > ><ORACLE-L_at_fatcity.com>
> > >Sent: Wed, 12 Nov 2003 08:09:27
> > >
> > >Hmmmmmm...
> > >
> > >I'd like to know where in the manuals... :-)
> > >
> > >I do not think so since the standby database stay
> > >in
> > >permanent recovery mode.
> > >
> > >JL
> > >
> > >--- Rachel Carmichael <wisernet100_at_yahoo.com>
> > >wrote:
> > >> yes. Well documented in the manuals
> > >>
> > >>
> > >> --- Juan Miranda <j.miranda_at_sermatica.es> wrote:
> > >> >
> > >> >
> > >> > Hi
> > >> >
> > >> > It is posible to create other schemas on a
> > >logical
> > >> stand by database
> > >> > ?
> > >> >
> > >> > I mean, schemas that don?t exist in the primary
> > >
> > >> database.
> > >> > --
> > >> > Please see the official ORACLE-L FAQ:
> > >> http://www.orafaq.net
> > >> > --
> > >> > Author: Juan Miranda
> > >> > INET: j.miranda_at_sermatica.es
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Walt Weaver
> INET: wweaver_at_rightnow.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).
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_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 Wed Nov 12 2003 - 11:44:24 CST