Hi all ;
This is a test scenario. Just tried to change protection mode (it was good and also worked fine)
PRIMARY_DB_UNIQUE_NAME : CRMS
STANDBY_DB_UNIQUE_NAME : STBYCRMS
Initially we configured physical standby as 'MAX PERFORMANCE'
I changed protection mode from max performance to Max availability.
DGMGRL> EDIT DATABASE 'stbycrms' SET PROPERTY 'LOGXPTMODE'='SYNC';
...
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
...
DGMGRL> show configuration;
Configuration - dgcrms
Protection Mode: MaxAvailability
Databases:
crms - Primary database
stbycrms - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
>> On primary database
SYS>show parameter log_archive_dest_2;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_2 string service="stby_crmsdb", LGWR SYNC AFFIRM delay=0 optional compression=disable max_failure=0 max_connections=1 reopen=300
db_unique_name="stbycrms" net_timeout=30, valid_for=(all_logfiles,primary_role)
My question is , suppose i do switchover ,
Do we need execute commands for primary database also ?
DGMGRL> EDIT DATABASE 'crms' SET PROPERTY 'LOGXPTMODE'='SYNC';
DGMGRL> EDIT CONFIGURATION SET PROTECTION MODE AS MAXAVAILABILITY;
...
DB version : 11.2.0.1