一:最大性能转最大可用(默认DG是最大性能模式)
1.确认主备数据库模式
1)主库:
SYS@ORA11GR2>select protection_mode,protection_level from v$database;
PROTECTION_MODEPROTECTION_LEVEL
--------------------
--------------------
MAXIMUM PERFORMANCEMAXIMUM PERFORMANCE
SYS@ORA11GR2>
SYS@ORA11GR2>selectname,protection_mode,database_role,switchover_status
fromv$database;
NAMEPROTECTION_MODEDATABASE_ROLESWITCHOVER_STATUS
--------- --------------------
---------------- --------------------
ORA11GR2MAXIMUM PERFORMANCEPRIMARYSESSIONS ACTIVE
SYS@ORA11GR2>
2)备库:
SQL> selectname,protection_mode,database_role,switchover_status
fromv$database;
NAMEPROTECTION_MODEDATABASE_ROLESWITCHOVER_STATUS
--------- --------------------
---------------- --------------------