更改dataguard的保护模式
更改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