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 > ><[EMAIL PROTECTED]> > >To: Multiple recipients of list ORACLE-L > ><[EMAIL PROTECTED]> > >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 <[EMAIL PROTECTED]> > >wrote: > >> yes. Well documented in the manuals > >> > >> > >> --- Juan Miranda <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > -- > 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: [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).