Changing protection modes using DGMGRL

How do we change the protection mode, my current protection mode is maximum performance, lets try changing this to max protection and max availability.

To get this started, we need to change the database property 'LogXptMode'  of the standby and also the primary so that its taken care during a  transition.

DGMGRL> EDIT DATABASE 'mobpro_collab1' SET PROPERTY 'LogXptMode'='SYNC';

Property "LogXptMode" updated
DGMGRL> EDIT DATABASE 'mobpro_collab2' SET PROPERTY 'LogXptMode'='SYNC';
Property "LogXptMode" updated
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
Succeeded.

DGMGRL> show configuration

Configuration - mobpro
Protection Mode: MaxAvailability
Databases:
mobpro_collab1 - Primary database
mobpro_collab2 - Physical standby database

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION;

Succeeded.

DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXPERFORMANCE;

Succeeded.

As you see, changing the protection mode is made veyr simple using dgmgrl, however a point to note that when you upgrade from max performace to max protection, make sure it is first changed to max availability and then to max protecion.

The reason is, primary will be taken down if there is a direct change from performance to protection. As you see from my below example, I had the configuration at Max Performance and then changed it to Max Protection.


DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXPROTECTION;

Operation requires shutdown of instance "mobpro" on database "mobpro_collab1"
Shutting down instance "mobpro"...
Database closed.
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "mobpro" on database "mobpro_collab1"
Starting instance "mobpro"...
ORACLE instance started.
Database mounted.
Database opened.



Can also check for the alert log on the primary to see a series of commands it has executed.


Regards

Asad