Change the protection mode of dataguard

Change the protection mode of dataguard

View the current protection mode: SQL> select protection_mode from v $ database; PROTECTION_MODE--------------------MAXIMUM AVAILABILITY prepare to change protection mode to maximum performance mode: On the master database: SQL> shutdown immediate; Databaseclosed. databasedismounted. ORACLE instanceshut down. SQL> startupmouont; SP2-0714: invalid combination of STARTUP optionsSQL> startupmountORACLE instancestarted. total SystemGlobal Area 281018368 bytesFixed Size 1218944 bytesVariableSize 1048592 64 bytesDatabaseBuffers 167772160 bytesRedoBuffers 7168000 bytesDatabasemounted. SQL> alterdatabase set standby database to maximize performance; Databasealtered. SQL> alterdatabase open; Databasealtered. SQL> selectprotection_mode from v $ database; PROTECTION_MODE--------------------MAXIMUM PERFORMANCE is very simple because it is a security mode downgrade, standby databases do not need to be restarted. Change the security level to the maximum protection mode: Check whether the standby logfile exists in the standby database. If not, create a standby logfile. SQL> select * from v $ logfile; GROUP # status type member is _ -------------- -------- running --- 3 ONLINE/u01/app/oracle/oradata/orcl/redo03.log NO 2 ONLINE/u01/app/oracle/oradata/orcl/redo02.log NO 1 ONLINE/u01/app/oracle/oradata/orcl/redo01.log NO 4 STANDBY/u01/app/oracle/oradata/orcl/redo04.log NO 5 STANDBY/u01/app/oracle/ oradata/orcl/redo05.log NO 6 STANDBY/u 01/app/oracle/oradata/orcl/redo06.log NO 7 STANDBY/u01/app/oracle/oradata/orcl/redo07.log NO7 rowsselected. Shut down both the host and the slave. SQL> shutdown immediate; modify the host parameter file :*. log_archive_dest_2 = 'service = 10 gstandbyLGWR SYNC affrem VALID_FOR = (ONLINE_LOGFILES, PRIMARY_ROLE) DB_UNIQUE_NAME = 10gstandby 'SQL> startupmountORACLE instancestarted. total SystemGlobal Area 281018368 bytesFixed Size 1218944 bytesVariableSize 104859264 bytesDatabaseBuffers 167772160 bytesRedoBuffers 7168000 bytesDatabasemounted. SQL> alterdatabase set standby database to maximize protection; Databasealtered. in this case, you need to open the standby database first. If you open the master database first, it will fail to start. create the standby database first: SQL> startupmount; ORACLE instancestarted. total SystemGlobal Area 281018368 bytesFixed Size 1218944 bytesVariableSize 96470656 bytesDatabaseBuffers 176160768 bytesRedoBuffers 7168000 bytesDatabasemounted. SQL> recovermanaged standby database disconnect from session; Mediarecovery complete. finally, open the master database for verification: SQL> alterdatabase open; Databasealtered. SQL> select protection_mode from v $ database; PROTECTION_MODE--------------------MAXIMUMPROTECTION