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: data guard + failover question

Re: data guard + failover question

From: Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl>
Date: Tue, 21 Jun 2005 11:36:16 +0200
Message-Id: <1119346575.1496.24.camel@dbalert199.dbalert.nl>


Hi Jaffar,

I'm not sure about Logical, but you're talking about Physical Standby. In that case statistics will be replicated. The standby database is a physical copy of your primary. Where are your statistics stored? In the dictionary tables, and they are part of the database. So, statistics will arrive in your standby automagically. What makes you think statistics are excluded from replication? Standby databases are just a sophisticated way of continuous recovery after a restore (the instantiation of the standby). If statistics were excluded from this, statistics would be stale after a normal restore/recovery operation as well.

Best regards,

Carel-Jan Engel

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

On Tue, 2005-06-21 at 08:32, The Human Fly wrote:

> Hello list,
>
> First of all, its not a production issue, but, this question would be
> quite helpful.
>
> We have a DRC (data guard) for one of our business critical database.
> My question is, when the failover occurs, physical standby becomes
> primary, my question is, in this situation, do we need to collect
> statistics for this or not? I dont think that statistics are
> replicated as data use to replicate between primary and secondary.
>
> Appreciate your valuable suggestions or views.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jun 21 2005 - 05:41:28 CDT

Original text of this message

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