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