原主库添加至dg broker配置文件
[oracle@cube ~]$ dgmgrl
DGMGRL for Linux: Version 11.2.0.4.0 - 64bit Production
Copyright (c) 2000, 2009, Oracle. All rights reserved.
Welcome to DGMGRL, type "help" for information.
DGMGRL> connect sys/windows@jakki
Connected.
DGMGRL> show configuration;
Configuration - DRSolution
Protection Mode: MaxAvailability
Databases:
JAKKI - Primary database
Warning: ORA-16817: unsynchronized fast-start failover configuration
CUBE - (*) Physical standby database (disabled)
ORA-16661: the standby database needs to be reinstated
Fast-Start Failover: ENABLED
Configuration Status:
WARNING
DGMGRL> reinstate database 'CUBE';
Reinstating database "CUBE", please wait...
Reinstatement of database "CUBE" succeeded
DGMGRL> show configuration;
Configuration - DRSolution
Protection Mode: MaxAvailability
Databases:
JAKKI - Primary database
CUBE - (*) Physical standby database
Fast-Start Failover: ENABLED
Configuration Status:
SUCCESS
DGMGRL> show database 'JAKKI';
Database - JAKKI
Role: PRIMARY
Intended State: TRANSPORT-ON
Instance(s):
JAKKI
Database Status:
SUCCESS
DGMGRL> show database 'CUBE';
Database - CUBE
Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Apply Rate: 0 Byte/s
Real Time Query: ON
Instance(s):
CUBE
Database Status:
SUCCESS
至此使用dg broker 管理dataguard配置,测试switchover 和failover 都已经完成;使用dg broker管理dataguard使得更加的方便;