• Arun Kumar

Oracle Data Guard Protection Modes

A Data Guard configuration always runs in one of three data protection modes (also called as redo transport rules):

  • Maximum Protection

  • Maximum Availability

  • Maximum Performance (default mode of operation)

dataguard-modes

  • By default, the protection mode is MAX PERFORMANCE. If you look above, MAX PERFORMANCE uses ASYNC redo transport and rest other protection modes uses SYNC protection mode.

  • Also, looking at MAX PROTECTION and MAX AVAILABILITY, we can say that the MAX PROTECTION mode is not used in real time. The main reason is if standby unavailable, primary will shut down.

  • The ultimate protection modes you must use are: MAX PERFORMANCE and MAX AVAILABILITY!


Switch from Max Performance to Max Availability


Verify the broker configuration, check if it’s enabled and make sure log apply is enabled

dgmgrl sys/oracle@proddb
show configuration 
show database proddb 
show database proddb_st 
edit database proddb_st set state=apply-on;

Change LNS mode from ASYN to SYNC

EDIT DATABASE proddb_st SET PROPERTY LogXptMode='SYNC'; 
EDIT CONFIGURATION SET PROTECTION MODE AS MaxAvailability;


Switch from Max Availability to Max Performance


Verify the broker configuration, check if it’s enabled and make sure log apply is enabled

dgmgrl sys/oracle@proddb

show configuration 
show database proddb 
show database proddb_st 
edit database proddb_st set state=apply-on;

Change LNS mode from ASYN to SYNC

EDIT DATABASE proddb_st SET PROPERTY LogXptMode='ASYNC'; 
EDIT CONFIGURATION SET PROTECTION MODE AS MaxPerformance;
812 views

Recent Posts

See All

Oracle Data Guard Physical Standby Configuration

There are various steps in which you can configure physical standby database. We need to make several changes to the primary database before we can even setup the standby database. This article applie

Client Connectivity in Data Guard Configuration

When you have a physical standby, you must make sure client connectivity is set properly so that when you perform failover or switchover, client must smoothly connect to the new primary. Create a data

Perform Manual Switchover on Physical Standby

Connect to proddb database via client: Take a new putty session and connect to proddb database via client machine. Keep querying below sqlplus sys/sys@proddb as sysdba SQL> select name, open_mode, db