Database Administration (MOSC)

MOSC Banner

Max-Availability to Max-Performance, does it require the Primary to be in MOUNT state?

edited Mar 7, 2013 6:55PM in Database Administration (MOSC) 4 commentsAnswered
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



Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center