更改dataguard的保护模式

查看当前的保护模式：

SQL>  select protection_mode from v$database;



PROTECTION_MODE

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

MAXIMUM AVAILABILITY



准备将保护模式改成最大性能模式：



在主库上：

SQL>shutdown immediate;

Databaseclosed.

Databasedismounted.

ORACLE instanceshut down.

SQL> startupmouont;

SP2-0714:invalid combination of STARTUP options

SQL> startupmount

ORACLE instancestarted.



Total SystemGlobal Area  281018368 bytes

Fixed Size                  1218944 bytes

VariableSize             104859264 bytes

DatabaseBuffers          167772160 bytes

RedoBuffers                7168000 bytes

Databasemounted.



SQL> alterdatabase set standby database to maximize performance;



Databasealtered.



SQL> alterdatabase open;



Databasealtered.



SQL> selectprotection_mode from v$database;



PROTECTION_MODE

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

MAXIMUM PERFORMANCE



由于是安全模式降级，所以非常简单，standby库都不用重启。



现将安全等级改成最大保护模式：



在standby库查看是否有standby logfile,如没有的话需要建立。

SQL> select* from v$logfile;



GROUP#STATUS     TYPE     MEMBER                                   IS_

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

     3            ONLINE   /u01/app/oracle/oradata/orcl/redo03.log  NO

     2            ONLINE   /u01/app/oracle/oradata/orcl/redo02.log  NO

     1            ONLINE   /u01/app/oracle/oradata/orcl/redo01.log  NO

     4            STANDBY  /u01/app/oracle/oradata/orcl/redo04.log  NO

     5            STANDBY  /u01/app/oracle/oradata/orcl/redo05.log  NO

     6            STANDBY  /u01/app/oracle/oradata/orcl/redo06.log  NO

     7            STANDBY  /u01/app/oracle/oradata/orcl/redo07.log  NO



7 rowsselected.



将主机和备机都关掉。



SQL>shutdown immediate;



修改主机的参数文件：

*.log_archive_dest_2='SERVICE=10gstandbyLGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)DB_UNIQUE_NAME=10gstandby'



SQL> startupmount

ORACLE instancestarted.



Total SystemGlobal Area  281018368 bytes

Fixed Size                  1218944 bytes

VariableSize             104859264 bytes

DatabaseBuffers          167772160 bytes

RedoBuffers                7168000 bytes

Databasemounted.

SQL> alterdatabase set standby database to maximize protection;



Databasealtered.



这时要先打开standby库，如果先打开主库的话会启动失败.



先打库standby库：

SQL> startupmount;

ORACLE instancestarted.



Total SystemGlobal Area  281018368 bytes

Fixed Size                  1218944 bytes

VariableSize              96470656 bytes

DatabaseBuffers          176160768 bytes

RedoBuffers                7168000 bytes

Databasemounted.



SQL> recovermanaged standby database disconnect from session;

Mediarecovery complete.



最后打开主库验证一下：

SQL> alterdatabase open;



Databasealtered.



SQL>  select protection_mode from v$database;



PROTECTION_MODE

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

MAXIMUMPROTECTION