Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Reasons for not considering Logical Standby Databases for Reporting purposes

RE: Reasons for not considering Logical Standby Databases for Reporting purposes

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Sat, 04 Nov 2006 00:20:34 +0100
Message-Id: <1162596034.8610.62.camel@dbalert199.dbalert.nl>


Don't forget to test whether the extra amount of redo (and accompanying overhead) because of supplemental logging is something the primary database can deal with.

What is the reason to have a reporting database? If your primary can't handle the load of you reports, you better be sure your standby server is at least as big as your primary. I agree with Ric that Logical is not the best choice for DR. If you need DR consider Physical seriously, eventually as a second standby.

After installing 30-40ish DG systems at numerous sites, I've run into a Logical Standby install just one. And they traded this in for Physical Standby after a couple of months.

If you want a nightmare of various log destinations, depending on the roles primarys and standbys can play in your system, you should definitely take cascaded log destinations into account. This is a rather quick way to make your system complex to a level of unmanageability!

Best regards,

Carel-Jan Engel

===
If you think education is expensive, try ignorance. (Derek Bok) ===

On Fri, 2006-11-03 at 16:46 -0600, Ric Van Dyke wrote:
> Of primary concern is the datatype support. Logical standby doesnĘt
> support all datatypes so that should certainly be high on the list of
> things to check. For a reporting database a logical is likely to be a
> good idea, but to have it as your standby (that is as a disaster
> recovery site) itĘs likely to not be the best choice, a physical is
> the best for that.
>
>
>
>
> Ric Van Dyke
>
> Hotsos Enterprises
>
> -----------------------
>
> Hotsos Symposium March 4-8, 2007. Be there.
>
>
>
> ______________________________________________________________________
>
> From:oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Anurag Verma
> Sent: Friday, November 03, 2006 11:02 AM
> To: oracle-l_at_freelists.org
> Subject: Reasons for not considering Logical Standby Databases for
> Reporting purposes
>
>
>
>
>
> Hello friends,
>
> We are thinking of setting up a Standby database for reporting
> purposes
> during the business hours and after that apply the pending logs.
>
> We are considering various options of multiple physical standby
> databases, cascaded
> redo log destinations and logical standby databases.
>
> Today, I was reading the Logical standby databases and their
> advantages.
>
> Have any of you guys thought about Logical standby databases
> while designing a standby database where it can be used for reporting
> purposes.
>
>
> I want to know what are the reasons or disadvantages of Logical
> standby databases
> that prompted you for NOT TAKING Logical standby databases for such a
> design.
>
>
> If you can give me some inputs, it would be really great...
>
> Thanks in advance,
>
> Anurag
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 03 2006 - 17:20:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US