原文地址：http://blog.csdn.net/wll_1017/article/details/9794203
一、修改dg_broker 为true
SQL> show parameter dg_broker_start
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_start boolean FALSE SQL> alter system set dg_broker_start=true;
System altered.
SQL> show parameter dg_broker_start
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_start boolean TRUE
主库：
SQL> show parameter dg
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_config_file1 string /u01/app/Oracle/product/11.2.0 /dbhome_1/dbs/dr1rac.dat dg_broker_config_file2 string /u01/app/oracle/product/11.2.0 /dbhome_1/dbs/dr2rac.dat dg_broker_start boolean TRUE
并且使用spfile起库
在主库创建连接到主库： DGMGRL> connect Username: sys Password: Connected.
创建配置： DGMGRL> create configuration 'dg_rac' as primary database is 'rac' connect identifier is 'rac'; Configuration "dg_rac" created with primary database "rac"
create configuration '随意起名' as primary database is 'db_unique_name' connect identifier is 'tnsname.ora里连接主库';
查看配置信息： DGMGRL> show configuration Configuration - dg_rac Protection Mode: MaxPerformance Databases: rac - Primary database Fast-Start Failover: DISABLED Configuration Status: DISABLED
添加备库到配置信息： DGMGRL> add database 'orcl' as connect identifier is 'orcl' maintained as physical; Database "orcl" added
add database 'db_unique_name' as connect identifier is 'tnsname.ora连接备库' maintained as physical;
查看配置信息： DGMGRL> show configuration Configuration - dg_rac Protection Mode: MaxPerformance Databases: rac - Primary database orcl - Physical standby database Fast-Start Failover: DISABLED Configuration Status: DISABLED
开启配置信息： DGMGRL> enable configuration; Enabled.
DGMGRL> show configuration Configuration - dg_rac Protection Mode: MaxPerformance Databases: rac - Primary database orcl - Physical standby database (disabled) ---有点问题 Fast-Start Failover: DISABLED Configuration Status: SUCCESS
DGMGRL> remove database orcl Removed database "orcl" from the configuration
DGMGRL> show configuration Configuration - dg_rac Protection Mode: MaxPerformance Databases: rac - Primary database Fast-Start Failover: DISABLED Configuration Status: SUCCESS
DGMGRL> show configuration Configuration - rac_dg Protection Mode: MaxPerformance Databases: rac - Primary database orcl - Physical standby database Fast-Start Failover: DISABLED Configuration Status: ORA-16610: command "ENABLE DATABASE rac" in progress DGM-17017: unable to determine configuration status
DGMGRL> enable database rac;
DGMGRL> show configuration Configuration - rac_dg Protection Mode: MaxPerformance Databases: rac - Primary database Warning: ORA-16532: Data Guard broker configuration does not exist orcl - Physical standby database Fast-Start Failover: DISABLED Configuration Status: WARNING
最后找到问题的关键原因是：dg_broker_config_file1 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/dr1rac.dat 文件不共享
DGMGRL> remove configuration;
SQL> alter system set dg_broker_config_file1='+data/rac/dr1rac.dat' scope=both sid='*'; alter system set dg_broker_config_file1='+data/rac/dr1rac.dat' scope=both sid='*' * ERROR at line 1: ORA-02097: parameter cannot be modified because specified value is invalid ORA-16573: attempt to change or access configuration file for an enabled broker configuration
SQL> alter system set dg_broker_start=false scope=both sid='*';
System altered.
SQL> show parameter dg_broker_start
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_start boolean FALSE
SQL> alter system set dg_broker_config_file1='+data/rac/dr1rac.dat' sid='*';
System altered.
SQL> alter system set dg_broker_config_file2='+data/rac/dr2rac.dat' sid='*';
System altered.
SQL> alter system set dg_broker_start=true scope=both sid='*';
System altered.
SQL> show parameter dg
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_config_file1 string +data/rac/dr1rac.dat dg_broker_config_file2 string +data/rac/dr2rac.dat dg_broker_start boolean TRUE SQL>
DGMGRL> create configuration 'dg_rac' as primary database is 'rac' connect identifier is 'rac'; Configuration "dg_rac" created with primary database "rac" DGMGRL> add database 'orcl' as connect identifier is 'orcl' maintained as physical;
DGMGRL> show configuration Configuration - dg_rac Protection Mode: MaxPerformance Databases: rac - Primary database orcl - Physical standby database (disabled) Fast-Start Failover: DISABLED Configuration Status: SUCCESS
DGMGRL> enable database orcl Enabled. DGMGRL> show configuration
Configuration - dg_rac
Protection Mode: MaxPerformance Databases: rac - Primary database orcl - Physical standby database (disabled) ---出现问题的原因是 需要恢复日志一下
Fast-Start Failover: DISABLED
Configuration Status: SUCCESS
备库： SQL> recover managed standby database disconnect from session; Media recovery complete. SQL> recover managed standby database cancel; Media recovery complete.
主库：
DGMGRL> show configuration
Configuration - dg_rac
Protection Mode: MaxPerformance Databases: rac - Primary database orcl - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status: SUCCESS
DGMGRL> switchover to orcl Performing switchover NOW, please wait... New primary database "orcl" is opening... Operation requires shutdown of instance "rac2" on database "rac" Shutting down instance "rac2"... ORA-01109: database not open
Database dismounted. ORACLE instance shut down. Operation requires startup of instance "rac2" on database "rac" Starting instance "rac2"... Unable to connect to database ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Failed. Warning: You are no longer connected to ORACLE.
Please complete the following steps to finish switchover: start up and mount instance "rac2" of database "rac"
主库和备库切换后，主库自动关闭，备库变成primary，处于open状态，但是之前连接的sesion全部断开，必须重新连接。
主库和备库切换状态后，查询状态：
SQL> select database_role from v$database;
DATABASE_ROLE ---------------- PHYSICAL STANDBY
