调整Data Guard保护模式

1.查看主库当前保护模式

SQL>selectprotection_mode,protection_level from v$database;

PROTECTION_MODE                   PROTECTION_LEVEL

------------------------------                    -------------------------------

MAXIMUMPERFORMANCE          MAXIMUM PERFORMANCE

2.修改主库dest参数

SQL>alter system set log_archive_dest_2='SERVICE=standby OPTIONAL LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)  DB_UNIQUE_NAME=orcl2';

System altered.

3.修改主库保护模式

SQL>alter database set standby database to max