This content has been marked as final. Show 4 replies
Absolutely, yet there are some things DG broker does upon switch over. Was wondering if somehow standby would be "updated" upon switcher...
But then again, it's SGA as a hole may be smaller to begin with...
Were you to tell if the following is true or false:
"After activation standby database may have a SGA configuration different than that of primary"
what would you say?
Hole intention here is to determine whether after a switch over it's possible to start getting ORA-04031 on account of dynamic pools being different
and oracle struggling to re-size them...
Suppose we have a 6Gb SGA... primary has been working full steam for say 2 months and dynamic pools are set by oracle in the following way:
Now if standby has not acknowledged those dynamic changes, it may be using values of it's own... maybe a larger cache... say
Now we switch-over and if sga settings are not "synced", then new primary will have 2Gb less of shared pool...
Application kicks in, shared pool runs low... Oracle will have to move 1 or 2Gbs from cache to shared pool, this will cause serious latching and most likely ORA-04031
so is that likely to happen?