本实验,通过调整Data Guard数据保护模式从maximize performance“最高性能”到maximize availability“最高可用性”,展示一下调整Data Guard数据保护模式的步骤。
最高可用性和最大保护都要求standby数据库配置standby redo logs
有关standby redo logs的添加方法请看这里《【实验】【DG】配置Standby Redo Log》
http://space.itpub.net/519536/viewspace-580366
OK,话不多说,开工……
1.查看主库当前数据保护模式 (主库ora10g操作)
sys@ora10g> select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
2.主库修改初始化参数 (主库ora10g操作)
sys@ora10g> alter system set log_archive_dest_2='SERVICE=ora10gdg OPTIONAL LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora10gdg';
System altered.
3.主库通过命令行修改数据保护模式,重启主数据库 (主库ora10g操作)
sys@ora10g> alter database set standby database to maximize availability;
Database altered.
附:下面列出不同数据保护模式的修改方法
SQL > alter database set standby database to maximize protection; --最大保护
SQL > alter database set standby database to maximize availability; --最高可用性
SQL > alter database set standby database to maximize performance; --最高性能
4.重启主库 (主库ora10g操作)
sys@ora10g> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@ora10g> startup;
ORACLE instance started.
Total System Global Area 104857600 bytes
Fixed Size 1266056 bytes
Variable Size 79695480 bytes
Database Buffers 20971520 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
5.查看主库保护模式是否变更成功 (主库ora10g操作)
sys@ora10g> select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
6.修改备库的log_archive_dest_2初始化参数方便数据库角色切换 (备库ora10gdg操作)
NotConnected@> alter system set log_archive_dest_2='SERVICE=ora10g OPTIONAL LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora10g';
System altered.
7.查看备库数据保护模式 (备库ora10gdg操作)
NotConnected@> select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
8.验证一下“最高可用性”切换成果
1).备库关闭前主库的状态:
sys@ora10g> select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
2).备库关闭后主库的状态(注意这里的变化,主库的PROTECTION_LEVEL标示为RESYNCHRONIZATION状态):
sys@ora10g> select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY RESYNCHRONIZATION
3).备库恢复数据恢复后,主库的状态:
sys@ora10g> select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
OK!成功,收工。
9.关于在不同数据保护模式下主库LOG_ARCHIVE_DEST_n配置要求 参阅Oracle官方文档:http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/log_transport.htm#g1282139
Good luck.
secooler
09.03.31
-- The End --
最高可用性和最大保护都要求standby数据库配置standby redo logs
有关standby redo logs的添加方法请看这里《【实验】【DG】配置Standby Redo Log》
http://space.itpub.net/519536/viewspace-580366
OK,话不多说,开工……
1.查看主库当前数据保护模式 (主库ora10g操作)
sys@ora10g> select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE
2.主库修改初始化参数 (主库ora10g操作)
sys@ora10g> alter system set log_archive_dest_2='SERVICE=ora10gdg OPTIONAL LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora10gdg';
System altered.
3.主库通过命令行修改数据保护模式,重启主数据库 (主库ora10g操作)
sys@ora10g> alter database set standby database to maximize availability;
Database altered.
附:下面列出不同数据保护模式的修改方法
SQL > alter database set standby database to maximize protection; --最大保护
SQL > alter database set standby database to maximize availability; --最高可用性
SQL > alter database set standby database to maximize performance; --最高性能
4.重启主库 (主库ora10g操作)
sys@ora10g> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
sys@ora10g> startup;
ORACLE instance started.
Total System Global Area 104857600 bytes
Fixed Size 1266056 bytes
Variable Size 79695480 bytes
Database Buffers 20971520 bytes
Redo Buffers 2924544 bytes
Database mounted.
Database opened.
5.查看主库保护模式是否变更成功 (主库ora10g操作)
sys@ora10g> select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
6.修改备库的log_archive_dest_2初始化参数方便数据库角色切换 (备库ora10gdg操作)
NotConnected@> alter system set log_archive_dest_2='SERVICE=ora10g OPTIONAL LGWR SYNC AFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=ora10g';
System altered.
7.查看备库数据保护模式 (备库ora10gdg操作)
NotConnected@> select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
8.验证一下“最高可用性”切换成果
1).备库关闭前主库的状态:
sys@ora10g> select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
2).备库关闭后主库的状态(注意这里的变化,主库的PROTECTION_LEVEL标示为RESYNCHRONIZATION状态):
sys@ora10g> select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY RESYNCHRONIZATION
3).备库恢复数据恢复后,主库的状态:
sys@ora10g> select protection_mode,protection_level from v$database;
PROTECTION_MODE PROTECTION_LEVEL
-------------------- --------------------
MAXIMUM AVAILABILITY MAXIMUM AVAILABILITY
OK!成功,收工。
9.关于在不同数据保护模式下主库LOG_ARCHIVE_DEST_n配置要求 参阅Oracle官方文档:http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/log_transport.htm#g1282139
Table 5-2 Minimum Requirements for Data Protection Modes
最大保护 | 最高可能用 | 最高性能 | |
Redo Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE归档进程 | LGWR | LGWR | LGWR或ARCH |
网络传输模式 | SYNC | SYNC | LGWR进程时SYNC或ASYNC,ARCH进程时SYNC |
磁盘写操作 | AFFIRM | AFFIRM | AFFIRM或NOAFFIRM |
是否需要standby redologs | YES | YES | 可没有但推荐有 |
Good luck.
secooler
09.03.31
-- The End --
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/519536/viewspace-582306/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/519536/viewspace-582306/