Switching between the three protection modes of Dta Guard

Shulou Source: shulou.com Published: 2022-06-01 18:36:49 10月30日 Update

-- check the protection mode before and after the switch each time the switch command is executed

Select database_role,protection_mode,protection_level from v$database

-- modify archiving parameters

-- upgrade maximum performance mode

Alter system set log_archive_dest_2='SERVICE=sty lgwr SYNC affirm VALID_FOR= (ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=sty' scope=both

-- downgrade to maximum performance mode

Alter system set log_archive_dest_2='SERVICE=sty lgwr ASYNC noaffirm VALID_FOR= (ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=sty' scope=both

1) switch maximum performance to maximum availability

Alter database set standby database to maximize availability

2) switch from maximum available to maximum protection

Alter database set standby database to maximize protection

3) maximum protection is downgraded to maximum available

Alter database set standby database to maximize availability

4) maximum available transfer maximum performance

Alter database set standby database to maximize performance

5) switch maximum performance to maximum protection

In the mount state

Alter database set standby database to maximize protection

Alter database open

6) maximum protection to maximum performance

Alter database set standby database to maximize performance