数据库: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
|