We have seen Protection Modes in depth in my previous Article.

To read protection modes in data guard :

Protection modes in Oracle Dataguard

In this article, we will see changing protection modes .

First, we need to decide what protection mode we want in our environment. Which protection mode suits better.What is important for us Database Availability , Database Performance or Data protection??

After choosing what protection mode we want to use , we need to set redo transport accordingly.

Maximum Availability Maximum Performance Maximum Protection
AFFIRM NOAFFIRM AFFIRM
SYNC ASYNC SYNC
DB_UNIQUE_NAME DB_UNIQUE_NAME DB_UNIQUE_NAME

Check Protection mode :

Here database is in Maximum Performance mode and we want to change it to Maximum Availability mode.

Step 1 :

DB_UNIQUE_NAME is important parameter and need  to be set on all database participated in data guard environment.

To set db_unique_name use following command.

On Primary

On Standby

Step 2 : Check log_archive_config parameter on both side :

On Primary :

On Standby :

Step 3 : Change redo transport parameter accordingly.

NET_TIMEOUT – Specifies the time in seconds that the primary database log writer will wait for a response from the Log Network Service (LNS) before terminating the connection and marking the standby (destination) as failed. The default value is 30 seconds.

REOPEN – Specifies the time in seconds that the log writer should wait before attempting to access a previously failed standby (destination). The default is 50 seconds.

Note : Shut down the primary database and restart it in mounted mode if the protection mode is being set to Maximum Protection or being changed from Maximum Performance to Maximum Availability. If the primary database is an Oracle Real Applications Cluster, shut down all of the instances and then start and mount a single instance.

Now, shutdown database :

Startup database in mount mode.

Use the following command to change protection mode.

Now, open database.

Check Protection mode of a database.

Stay tuned for More articles on Oracle DataGuard

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:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.