Regarding to Oracle Documents That Describe Standby Modes, There’s Are Three Types you can follow the documentation.
Check Standby Modes :
SQL> select PROTECTION_MODE from v$database ;
PROTECTION_MODE
——————–
MAXIMUM PERFORMANCE
Primary Database: prim
Standby Database: stdby
Note: the below Commands Should Apply on Primary Database on Mount Mode Then Open database.
Convert Between Modes (Switch Modes)
MAXIMIZE AVAILABILITY
SQL> alter system set log_archive_dest_2=’SERVICE=stdby AFFIRM SYNC VALID_FOR=(online_logfiles,primary_role) db_unique_name=stdby’;
System altered.
System altered.
SQL> alter database set standby Database to MAXIMIZE AVAILABILITY ;
Database altered.
MAXIMIZE PERFORMANCE
SQL>ALTER SYSTEM SET LOG_ARCHIVE_DEST_2=’SERVICE=stby NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=stdby’;
System Altered
SQL>ALTER DATABASE SET STANDBY DATABASE TO MAXIMIZE PERFORMANCE;
Database Altered
MAXIMIZE Proctection
SQL> alter system set log_archive_dest_2=’SERVICE=stdby AFFIRM SYNC VALID_FOR=(online_logfiles,primary_role) db_unique_name=stdby’;
System altered.
shutdown immediate ;
Startup mount ;
Alter database set standby database to maximize Protection ;
Alter database open ;
Some Useful Sites:
1-Convert Modes Using dgmgrl
Thank you
Osama Mustafa
Technology Geek 