Thanks for the question, Daniel.
Asked: March 23, 2017 - 6:41 pm UTC
Last updated: March 24, 2017 - 3:16 am UTC
Version: 11
Viewed 1000+ times
You Asked
Hello,
More than a question is a curiosity, if there is a dataguard enviroment physical - standby is it needed that both databases servers have the same size of their temporary tablespace? I know temporary tablespace is just for sort and joining operations and as standby is mounted and not even read only is allowed do we still need the same size of temp tablespace?
I believe it will be needed in case of catastrophic failure to work as normal when opened
thank you and best regards,
Daniel
and Connor said...
"It depends"
If you intend to failover to that node, and run full size production, then it would make sense to have the temporary tablespace the same size as production so that the failover is as seamless as possible.
But if the data base is there for (say) smaller scale operations, eg, just to make sure redo logs are working as expected, or occasional read only access etc...then a smaller tablespace would be fine.
Conversely, if it was Active Data Guard and you were running lots of reports against the node, then you might have a *bigger* temporary tablespace.
Is this answer out of date? If it is, please let us know via a Comment