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

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