hi,
want to Change my dr to max availability mode.
1 primary with 2 dr databases.(12.2 on linux)
Bounce primary to mount phase and change the value:
ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE AVAILABILITY;
Below are the database parameters.
Just wanted to validate with experts
Primary
Alter system set log_archive_dest_1='LOCATION=+ARC VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRDPPRIMARY' scope=both sid='*';
Alter system set log_archive_dest_2='SERVICE=PRD_DR2 AFFIRM SYNC NET_TIMEOUT=20 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRDPDR2' scope=both sid='*';
Alter system set log_archive_dest_3='SERVICE=PRD_DR3 AFFIRM SYNC NET_TIMEOUT=20 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRDPDR3' scope=both sid='*';
1st dataguard db
Alter system set log_archive_dest_1='LOCATION=+ARC VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRDPDR2' scope=both sid='*';
Alter system set log_archive_dest_2='SERVICE=PRD_PRI AFFIRM SYNC NET_TIMEOUT=20 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRDPPRIMARY' scope=both sid='*';
Alter system set log_archive_dest_3='SERVICE=PRD_DR3 AFFIRM SYNC NET_TIMEOUT=20 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRDPDR3' scope=both sid='*';
2nd dataguard db
Alter system set log_archive_dest_1='LOCATION=+ARC VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PRDPDR3' scope=both sid='*';
Alter system set log_archive_dest_2='SERVICE=PRD_DR2 AFFIRM SYNC NET_TIMEOUT=20 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRDPDR2' scope=both sid='*';
Alter system set log_archive_dest_3='SERVICE=PRD_PRI AFFIRM SYNC NET_TIMEOUT=20 VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRDPPRIMARY' scope=both sid='*';