Difference between Max Protection, Max Performance and Max Availability

Updated May 18, 2018

Max Protection vs. Max Performance vs. Max Availability

Hello Experts,

I have some query that I want to clear here so please help me out if anyone of you is familiar with the following queries:

1) Whats difference between max protection, max performance, max availability. Which one should be used for production and dev environment in Dg?

2) Should SCN be same between primary and standby?

Thanks in Advance!

Comments

07 Apr 2016 10:16 am Guest Helpful Answer

As per my knowledge, it solely depends on your environment or client.. if your env. needs data to be available all the time..you can go for max. performance. you can configure your near DR and far DR. So that in case of any production outage you can switch/failover to your standby. Cause if you configure as max. protection it will shutdown your production database if standby is not in sync, which is not acceptable for some clients.
and if you cinfigure as max. availability, your production get hanged if the archive is not written to standby.
So, if your customer is from BFS domain, go for max. performance. :)

19 Aug 2015 5:26 pm Sushma

Max performance=asynchronous, max protection = synchronous,
max avaiablility=log switched to all standby nodes.

19 Aug 2015 5:27 pm Rohit Mahajan

Thanks Sushma - Do you know whats risk in using max protection. 2) In order to verify any lag, should SCN be same between primary and standby.

19 Aug 2015 5:27 pm Sushma

Risks involve in everything,
2) Yes and I would also check the log gap.

19 Aug 2015 5:28 pm Rohit Mahajan

Can you brief how do you say risk is in all modes.2) I have been using max performance which is default mode. archive gap gives 0 rows but scn number is never same between primary nodes and dataguard.

19 Aug 2015 5:28 pm Sugandh

Yes,SCN numbers should be same to the primary and standby.

19 Aug 2015 5:29 pm Rohit Mahajan

Scn number is never same for me with max performance between primary and dg but logs getting applied are same. Can't see any issue where I can point sync is not there.

19 Aug 2015 5:29 pm Sushma

Thats why I said "I would also check the log gap", so no issues.

19 Aug 2015 5:30 pm Sugandh

Maximum performance is the default mode but you can use the maximum protection. Your data is more protected to any failover so we can use the maximum protection mode.

19 Aug 2015 5:30 pm Rohit Mahajan

Can primary hangs in maximum protection. How sync happens in primary and dg?

19 Aug 2015 5:30 pm Nitesh Singh

Mostly use max performance in all environment and it's default mode.