Oracle Physical Standby Modes :

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

prmdbary Database: prmdb
Standby Database: stldb


Note: the below Commands Should Apply on prmdbary 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,prmdbary_role) db_unique_name=stdby';
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,prmdbARY_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,prmdbary_role) db_unique_name=stdby';
System altered.

shutdown immediate ;
Startup mount ;
Alter database set standby database to maximize Protection ;
Alter database open ;