Data Guard Protection Modes

Oracle Data Guard Protection Modes

Description: 
       In this blog, we are going to see oracle data guard protection modes and how to change one mode to another mode.

What is protection mode:
       Production mode is based on the RTO(recovery time objective) and RPO(recovery point objective values and to select the most appropriate model for their data guard configuration.
       The primary database always syncs with the standby database, the primary database is not active for the end-users for some natural disasters, hardware errors occur the standby can be changed as primary.

Why it is Required:
       In that situation some of the applications required maximum database performance at all times, so we can configure the standby database with appropriate protection mode. 

Types of protection modes:

MAXIMUM PERFORMANCE
MAXIMUM PROTECTION
MAXIMUM AVAILABILITY

MAXIMUM AVAILABILITY:
       Maximum availability protection mode provides the highest level of protection, which is possible without compromising the availability of the primary database.
       Whatever changes happen in the primary database it can be reflected in the standby database, the standby database sends acknowledgment then it will send again the logs, otherwise, it ignores the availability mode move on to the maximum performance mode.
       This mode ensures ZERO data loss in the case of certain double faults.

MAXIMUM PERFORMANCE:
       Maximum performance is a default protection mode.
       It is a high-level protection mode without affecting the primary database.
       The primary database sends logs to the standby database it’s not waiting for an acknowledgment it will perform asynchronous behavior. 
       Less amount of data loss happens in maximum performance mode.

MAXIMUM PROTECTION:
       Maximum protection mode ensures that no data loss occurs if the primary database fails.
       The primary database sends logs to standby the RFS acknowledges to LNS at least one redo log can be transferred or it will shut down the primary database.

SUMMARY OF PROTECTION MODES:

How to view and change protection mode:
View protection mode:
SQL> select protection_mode from v$database;
Data sync and async configuration:
SQL> ALTER SYSTEM SET log_archive_dest_2=’service=data sync valid_for=(online_logfiles,primary_role) db_unique_name=stand’ SCOPE=both;
System altered.

How to change protection mode:

SQL> alter database set standby database to maximize PERFORMANCE;
SQL> alter database set standby database to maximize PROTECTION;
SQL> alter database set standby database to maximize AVAILABILITY;
SQL> select name,protection_mode from v$database;

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter: https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8