Re: data guard + failover question

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.

Other related posts: