[重慶思莊每日技術分享]-ORA-16525 dg broker不可用

資料庫：Oracle 11.2.0.4

系統：CentOS 7.9

問題描述：dgmgrl執行show configuration命令，出現以下ora-16525異常，如下所示：

DGMGRL> show configuration;

Error:

ORA-16525: the Data Guard broker is notyet available

Configuration details cannot be determinedby DGMGRL

檢視告警日誌：

[oracle@oel trace]$ catdrcorcl150.log  (drcorcl150.log 在$ORACLE_BASE/rdbms/orcl150/orcl150/trace目錄下)

....

05/27/2022 17:40:54

Data Guard Broker shutting down

RSM0 successfully terminated

05/27/2022 17:40:57

>> Data Guard Broker Has Been ShutDown <<

Fore Deregistering service ORCL150_DGBwith listener(s)

此處主備庫的dg_broker_start均為false

SQL> show parameter dg_broker

NAME                                 TYPE        VALUE

----------------------------------------------- ------------------------------

dg_broker_config_file1               string          /u01/app/oracle/product/11.2.0

                                                                       /db_1/dbs/dr1ORCL150.dat

dg_broker_config_file2               string          /u01/app/oracle/product/11.2.0

                                                                        /db_1/dbs/dr2ORCL150.dat

dg_broker_start                      boolean         FALSE

嘗試將dg_broker_start設定為"true".

SQL> alter system setdg_broker_start=true;

System altered.

DGMGRL> show configuration;

Configuration - dg_conf

Protection Mode: MaxPerformance

Databases:

   orcl150 - Primary database

   orcl151 - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

SUCCESS

結論：將主備庫dg_broker_start修改為true，showconfiguration正常顯示.

以下為日誌資訊：

[oracle@oel trace]$ cat drcorcl150.log

......

05/27/2022 17:40:54

Data Guard Broker shutting down

RSM0 successfully terminated

05/27/2022 17:40:57

>> Data Guard Broker Has Been ShutDown <<

Fore Deregistering service ORCL150_DGBwith listener(s)

05/28/2022 13:29:47

Creating Data Guard Broker Monitor Process(DMON)

05/28/2022 13:29:50

>> Starting Data Guard Brokerbootstrap <<

Broker Configuration File Locations:

     dg_broker_config_file1 ="/u01/app/oracle/product/11.2.0/db_1/dbs/dr1ORCL150.dat"

     dg_broker_config_file2 = "/u01/app/oracle/product/11.2.0/db_1/dbs/dr2ORCL150.dat"

05/28/2022 13:29:54

DMON Registering service ORCL150_DGB withlistener(s)

Broker Configuration:       "dg_conf"

     Protection Mode:           Maximum Performance

     Fast-Start Failover (FSFO): Disabled, flags=0x0, version=0

     Primary Database:          orcl150 (0x01010000)

     Standby Database:          orcl151, Enabled Physical Standby (0x02010000)

05/28/2022 13:29:58

Site orcl151 returned ORA-16525.

Version Check Results:

     Database orcl151 returned ORA-16525

Creating process RSM0