Friday, December 28, 2012

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

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.

 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





No comments:

Post a Comment