查看当前的保护模式:
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