Change the standby protection mode

Change the protection mode from maximum performance to maximum availability

SQL> show parameter log_archive_dest_3

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_3                   string      SERVICE=ol6rac2  db_unique_nam
                                                 e=ol6rac2 sync lgwr compressio
                                                 n=enable max_failure=4 reopen=
                                                 8
log_archive_dest_30                  string
log_archive_dest_31                  string
SQL> show parameter log_archive_config

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_config                   string      DG_CONFIG=(ol6rac1,ol6rac2)
SQL> select name,open_mode,protection_Mode,database_role from v$database;

NAME      OPEN_MODE            PROTECTION_MODE      DATABASE_ROLE
--------- -------------------- -------------------- ----------------
NEW12CDB  READ WRITE           MAXIMUM PERFORMANCE  PRIMARY

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2296576 bytes
Variable Size             671089920 bytes
Database Buffers          390070272 bytes
Redo Buffers                5480448 bytes
Database mounted.
SQL> alter database set standby database to maximize availability;

Database altered.

SQL> alter database open;

Database altered.

SQL> select name, open_mode,protection_mode,database_role from v$database;

NAME      OPEN_MODE            PROTECTION_MODE      DATABASE_ROLE
--------- -------------------- -------------------- ----------------
NEW12CDB  READ WRITE           MAXIMUM AVAILABILITY PRIMARY