0
0
0
---
在Dataguard Broker上配置fast_start failover
jametong 发表于 2010年03月16日 00:06 | Hits: 3265
在Dataguard Broker上配置fast_start failover
前一篇文章中已经介绍过dataguard broker的基本配置, 在本文中,我将尝试给出在dataguard broker里部署fast_start failover, 具体的测试过程将在后续文章中给出.
要配置成功fast_start failover 需要满足以下5项条件.
- 1. dataguard 的配置要么是maxAvailability模式要么是maxPerformance模式.
- 2. 当dataguard的配置为maxAvailability模式时,fast-start failover的目标standby数据库的log传送模式必须设置为Sync.
- 3. 当dataguard的配置为maxPerformance模式时,fast-start failover的目标standby数据库的log传送模式必须设置为Async.
- 4. 主库与fast-start failover的目标standby数据库都必须激活flashback 功能.
- 5. 当配置了多个standby数据库时,没有在主库的配置属性FastStartFailoverTarget指定目标standby 数据库.
下面将分别配置这几项.
1. 设置standby database的dataguard模式为maxAvailablity.
在配置好dataguard broker以后, 可以在主库的sqlplus 界面修改此配置,也可以直接在dataguard manager(dgmgrl)里面修改此值.
--在dgmgrl中修改此配置. DGMGRL> edit configuration set protection mode as maxAvailability; Succeeded. DGMGRL> --在sqlplus中修改此配置. SQL> alter database set standby database to maximize availability; Database altered.
2. 通过dgmgrl 分别修改主库与standby数据库的log file传送模式.
DGMGRL> show database verbose dbmain 'LogXptMode' LogXptMode = 'SYNC' DGMGRL> edit database dbstby set property LogXptMode = 'SYNC'; Property "logxptmode" updated DGMGRL> show database verbose dbstby 'LogXptMode' LogXptMode = 'SYNC' DGMGRL>
3. 在数据库上配置flashback功能.
--主库配置语句 mkdir -p /data/oradata/flasharea/ ----两个参数的设置顺序不能颠倒,否则会报错. alter system set db_recovery_file_dest_size = 1024m scope=both; alter system set db_recovery_file_dest = '/data/oradata/flasharea/' scope=both; alter database flashback on; SQL> show parameter recover NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /data/oradata/flasharea/ db_recovery_file_dest_size big integer 1G recovery_parallelism integer 0 SQL> select flashback_on,force_logging,database_role,db_unique_name from v$database; FLASHBACK_ON FOR DATABASE_ROLE DB_UNIQUE_NAME ------------------ --- ---------------- ------------------------------ YES YES PRIMARY dbmain --standby库配置语句. mkdir -p /data/oradata/flasharea/ alter system set db_recovery_file_dest_size = 1024m scope=both; alter system set db_recovery_file_dest = '/data/oradata/flasharea/' scope=both; recover managed standby database cancel; alter database flashback on; recover managed standby database disconnect from session using current logfile; SQL> show parameter recover NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ db_recovery_file_dest string /data/oradata/flasharea/ db_recovery_file_dest_size big integer 1G recovery_parallelism integer 0 SQL> select flashback_on,force_logging,database_role,db_unique_name from v$database; FLASHBACK_ON FOR DATABASE_ROLE DB_UNIQUE_NAME ------------------ --- ---------------- ------------------------------ YES YES PHYSICAL STANDBY DBSTBY
4. 在dgmgrl 中配置主库与standby数据库的FastStartFailoverTarget属性.
DGMGRL> show database verbose dbmain 'FastStartFailoverTarget'; FastStartFailoverTarget = '' DGMGRL> edit database dbmain set property FastStartFailoverTarget='dbstby'; Property "faststartfailovertarget" updated DGMGRL> show database verbose dbmain 'FastStartFailoverTarget'; FastStartFailoverTarget = 'dbstby' DGMGRL> DGMGRL> rem set property for dbstby DGMGRL> show database verbose dbstby 'FastStartFailoverTarget'; FastStartFailoverTarget = '' DGMGRL> edit database dbstby set property FastStartFailoverTarget='dbmain'; Property "faststartfailovertarget" updated DGMGRL> show database verbose dbstby 'FastStartFailoverTarget'; FastStartFailoverTarget = 'dbmain' DGMGRL>
5. 在一个dgmgrl命令中启动observer.
--在一个终端的命令中启动observer命令. DGMGRL> DGMGRL> start observer Observer started --在另外一个终端的dgmgrl命令中查看fast_start failover的状态. DGMGRL> show fast_start failover Fast-Start Failover: DISABLED Threshold: 30 seconds Target: (none) Observer: dbmain --显示observer 已经启动. Lag Limit: 30 seconds Shutdown Primary: TRUE Auto-reinstate: TRUE Configurable Failover Conditions Health Conditions: Corrupted Controlfile YES Corrupted Dictionary YES Inaccessible Logfile NO Stuck Archiver NO Datafile Offline YES Oracle Error Conditions: (none)
6. 在dgmgrl中激活fast_start failover 功能.
DGMGRL> enable fast_start failover; Enabled. DGMGRL> show fast_start failover Fast-Start Failover: ENABLED Threshold: 30 seconds Target: dbstby Observer: dbmain Lag Limit: 30 seconds (not in use) Shutdown Primary: TRUE Auto-reinstate: TRUE Configurable Failover Conditions Health Conditions: Corrupted Controlfile YES Corrupted Dictionary YES Inaccessible Logfile NO Stuck Archiver NO Datafile Offline YES Oracle Error Conditions: (none)
No related posts.

原文链接: http://item.feedsky.com/~feedsky/dbthink/~8068730/346502955/6175071/1/item.html
我要给这篇文章打分:
可以不填写评论, 而只是打分. 如果发表评论, 你可以给的分值是-5到+5, 否则, 你只能评-1, +1两种分数. 你的评论可能需要审核.