A note from Data Guard Broker

A note from Data Guard Broker recently used A Broker to configure and manage Data Guard (Oracle version: 10.2.0.1.0). Earlier databases basically did not set db_domain. When database link is used, global_names = true is enabled, and db_domain is also set. Therefore, the Broker can be successfully used to configure and manage Data Guard settings. Now, no, I cannot, when switchover is used as a broker, the instances of the master and slave databases are not automatically started and need to be started manually. When I use show configuration, the broker also prompts successs, as shown below: DGMGRL> show configuration; Configuration Name: dgmgrl_1 Enabled: YES Protection Mode: MaxPerformance Fast-Start Failover: DISABLED Databases: prod-Physical standby database sbdb-Primary databaseCurrent status for "dgmgrl_1; ming switchover NOW, please wait... operation requires shutdown of instance "SBDB" on database "sbdb" Shutting down instance "SBDB "... ORA-01109: database not openDatabase dismounted. ORACLE instance shut down. operation requires shutdown of instance "PROD" on database "prod" Shutting down instance "PROD "... ORA-01109: database not openDatabase dismounted. ORACLE instance shut down. operation requires startup of instance "SBDB" on database "sbdb" Starting instance "SBDB "... ORACLE instance started. database mounted. operation requires startup of instance "PROD" on database "prod" Starting instance "PROD "... unable to connect to databaseORA-12514: TNS: listener does not currently know of service requested in connect descriptorFailed. you are no longer connected to ORACLEPlease connect again. unable to start instance "PROD" You must start instance "PROD" manuallySwitchover succeeded, new primary is "prod" as shown in the error message above, it must be a problem with the Listener Configuration, the following figure shows the previously configured listener. oralistener. oraLISTENER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp) (HOST = vmoel5u4.oracle.com) (PORT = 1521 )))) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = PROD_DGMGRL) (ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1) (SID_NAME = PROD )) (SID_DESC = (GLOBAL_DBNAME = PROD) (ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1) (SID_NAME = PROD), the following db_domain of the database is queried: SQL> show parameter db_domain; NAME TYPE VALUE ---------------------------------------------------------------- ---------------------------- db_domain string ORACLE. COM finds that db_domain refers to the listener. You can change it to the following format. oraLISTENER = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp) (HOST = vmoel5u4.oracle.com) (PORT = 1521 )))) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = PROD_DGMGRL.ORACLE.COM) (ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1) (SID_NAME = PROD )) (SID_DESC = (GLOBAL_DBNAME = PROD) (ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1) (SID_NAME = PROD) perform switchover again, instances is automatically started this time: DGMGRL> switchover to PROD; Ming switchover NOW, please wait... operation requires shutdown of instance "SBDB" on database "sbdb" Shutting down instance "SBDB "... ORA-01109: database not openDatabase dismounted. ORACLE instance shut down. operation requires shutdown of instance "PROD" on database "prod" Shutting down instance "PROD "... ORA-01109: database not openDatabase dismounted. ORACLE instance shut down. operation requires startup of instance "SBDB" on database "sbdb" Starting instance "SBDB "... ORACLE instance started. database mounted. operation requires startup of instance "PROD" on database "prod" Starting instance "PROD "... ORACLE instance started. database mounted. switchover succeeded, new primary is "prod" DGMGRL> show configuration; Configuration Name: dgmgrl_1 Enabled: YES Protection Mode: MaxPerformance Fast-Start Failover: DISABLED Databases: prod-Primary database sbdb-Physical standby databaseCurrent status for "dgmgrl_1": SUCCESS Oralce: to enable the Data Guard broker CLI to restart instances during the course of broker operations, a service with a specific name must be statically registered with the local listener of each instance. the value of the GLOBAL_DBNAME attribute must be set to a concatenation of db_unique_name_DGMGRL.db_domain.