Max-Availability to Max-Performance, does it require the Primary to be in MOUNT state?
I'm looking to change my configuration from max-availability to max-performance to reduce commit waits. Would this require downtime to put the primary database in mount mode?
ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;
If I had to guess, it probably doesn't need to be in a mounted state, because if the standby is not available, the docs say the primary reverts to max-performance characteristics anyways.
Thanks!
-Ken
PS. This documentation is clear about going from max-performance to max-availability/protection, it's not very clear about going the other way: http://docs.oracle.com/cd/B28359_01/server.111/b28294/protection.htm
0