RE: Re: Logical StandBy question

Juan,  

I am using Physical Standby Database for Disaster Recovery situation and also for REPORTS. I apply logs everyday in the morning and bring it up in READ ONLY mode. Developers can SELECT latest data from STANDBY database. I have created a DATABASE LINK for STANDBY database from X database. Now you can create REPORTS in X database by SELECTING data from STANDBY database. Less maintenance, reliable and good performance.  

The only disadvantage is STANDBY database is one day behind.  

Muqthar Ahmed
DBA  -----Original Message-----
Sent: Thursday, November 13, 2003 3:34 AM To: Multiple recipients of list ORACLE-L  

I am just planning a LOGICAL data guard installation in an important client. They need it for reporting and backup (primary is 24x7x365 and we have hot backup.)  

I didnīt kwon that LSB are so bad.  

So do you think It is so bad that you donīt put it into production ???  

Do you try 9.2.0.4 ??    

I need to take a decision....  

I thank your previous answers.
(I read doc, of course, but It is not explicity say that)

-----Mensaje original-----
De: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]En nombre de Carel-Jan Engel Enviado el: miércoles, 12 de noviembre de 2003 19:59 Para: Multiple recipients of list ORACLE-L Asunto: RE: Re: Logical StandBy question

Walt, drop me your email-address, and I send you the handouts of a special I presented about DG for Oracle University in Stockholm.

I'm going out now for a few hours (it's 19.30 over here), but I'll respond later this evening.

regards, Carel-Jan
At 09:19 12-11-03 -0800, you 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 <http://www.orafaq.net/>
> >> > --
> >> > Author: Juan Miranda
> >> > INET: j.miranda_at_sermatica.es
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net/>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net/> 
-- 
Author: Walt Weaver
  INET: wweaver_at_rightnow.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com <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).

DBA!ert, Independent Oracle Consultancy 
Kastanjelaan 61C
2743 BX  Waddinxveen
The Netherlands
tel.    +31 (0) 182 640 428
fax     +31 (0) 182 640 429
mobile  +31 (0) 653 911 950
e-mail info.dbalert_at_xs4all.nl






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Muqthar Ahmed
  INET: Muqthar.Ahmed_at_decoratetoday.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).