|
-
Your primary database will shutdown if you setup Maximum Protection Mode and the system is not able to write ReDo to at least one remote location; it shouldn't hang, it should shutdown.
It has to shut down becasue of Maximum Protection Mode means ReDo has to be written to both local and remote sites at commit time. Maximum Availability Mode is like Maximum Protection Mode without this extra protection feature.
If you find the same ReDo issue -inability to write to at least one remote site- and your setup is for Maximum Availability Mode database would automatically switch to Maximum Performance Mode until the issue gets solved then it will resume on Maximum Availability Mode.
In none of these scenarios database should hang.
Last edited by PAVB; 05-20-2008 at 07:01 AM.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote