如何修改datguard protection mode

10.2.0.5 on windows 2008 64 bit

总是在primary database上修改protection mode。

一、升级protection mode

如果不是升级至maximize protection mode，都可以在线升级。

 alter database set standby database to maximize {AVAILABILITY | PERFORMANCE | PROTECTION}; 

如果是要升级至maximize protection mode ，需要关闭primary database，再mount起来。

如果不关闭升级至protection mode会出现以下错误

SQL> alter database set standby database to maximize protection;
alter database set standby database to maximize protection
*
ERROR at line 1:
ORA-01126: database must be mounted in this instance and not open in any
instance

二、降级protection mode

降级是不需要关闭primary database。

无论是降级还是升级，每次在主库修改了protection mode ，都会发生一次日志切换，这样无论是standby 运行何种模式下，都可以马上更新到

SQL> select sequence# from v$log where status='CURRENT';


 SEQUENCE#
----------
       632


SQL> alter database set standby database to maximize performance;


Database altered.

SQL> select sequence# from v$log where status='CURRENT';


 SEQUENCE#
----------
       633

参考文档：How to upgrade the protection mode in Data Guard environment (文档 ID 800212.1)

TRANSPORT: Data Guard Protection Modes (文档 ID 239100.1)