oracle DGMGRL ORA-16603报错的解决方法(DG Broker)

当执行添加物理备库动作时出现如下报错
DGMGRL> add database 'orclstd' as connect identifier is 'orclstd' maintained as  physical;

Error: ORA-16603: member is part of another Data Guard broker configuration

以下是OERR给出的解决办法
[oracle@adg ~]$ oerr ORA 16603
16603, 00000, "member is part of another Data Guard broker configuration"
// *Cause:  The member was part of another Data Guard broker configuration.
//          This could occur if the original configuration was re-created
//          while this member was disconnected from the network or the
//          same member was added to two different Data Guard broker
//          configurations.
// *Action: Ensure that the member belongs to only one broker configuration.
//          Shut down the broker by setting the DG_BROKER_START initialization
//          parameter to 'false'. Then, remove the Oracle Data Guard broker
//          configuration files. Finally, restart the broker by setting the
//          DG_BROKER_START initialization parameter to 'true'.


要注意这个解决动作是要在备库上执行的 不要搞错

以下是解决流程
[oracle@adg ~]$ cd $ORACLE_HOME/dbs
[oracle@adg /u01/app/oracle/product/19c/dbhome_1/dbs]$ ls
afiedt.buf                arch2_163_1066257379.dbf  lkORCLSTD
arch1_180_1066257379.dbf  c-1594038115-20210324-00  orapworclstd
arch1_181_1066257379.dbf  dr1orclstd.dat            pfile.ora
arch1_182_1066257379.dbf  dr2orclstd.dat            snapcf_orclstd.f
arch2_161_1066257379.dbf  hc_orclstd.dat            spfileorclstd.ora
arch2_162_1066257379.dbf  init.ora
将dr开头的两个文件删掉
[oracle@adg /u01/app/oracle/product/19c/dbhome_1/dbs]$ rm dr*
[oracle@adg /u01/app/oracle/product/19c/dbhome_1/dbs]$ ls
afiedt.buf                arch2_162_1066257379.dbf  lkORCLSTD
arch1_180_1066257379.dbf  arch2_163_1066257379.dbf  orapworclstd
arch1_181_1066257379.dbf  c-1594038115-20210324-00  pfile.ora
arch1_182_1066257379.dbf  hc_orclstd.dat            snapcf_orclstd.f
arch2_161_1066257379.dbf  init.ora                  spfileorclstd.ora

[oracle@adg /u01/app/oracle/product/19c/dbhome_1/dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Apr 3 18:55:19 2021
Version 19.10.0.0.0

Copyright (c) 1982, 2020, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.10.0.0.0

SYS@orclstd>show parameter dg_broker

NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
dg_broker_config_file1               string
/u01/app/oracle/product/19c/db
home_1/dbs/dr1orclstd.dat
dg_broker_config_file2               string
/u01/app/oracle/product/19c/db
home_1/dbs/dr2orclstd.dat
dg_broker_start                      boolean
TRUE
SYS@orclstd>alter system set dg_broker_start=false;

System altered.

SYS@orclstd>show parameter dg_broker

NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
dg_broker_config_file1               string
/u01/app/oracle/product/19c/db
home_1/dbs/dr1orclstd.dat
dg_broker_config_file2               string
/u01/app/oracle/product/19c/db
home_1/dbs/dr2orclstd.dat
dg_broker_start                      boolean
FALSE

SYS@orclstd>alter system set dg_broker_start=true;

System altered.

SYS@orclstd>show parameter dg_broker

NAME                                 TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
dg_broker_config_file1               string
/u01/app/oracle/product/19c/db
home_1/dbs/dr1orclstd.dat
dg_broker_config_file2               string
/u01/app/oracle/product/19c/db
home_1/dbs/dr2orclstd.dat
dg_broker_start                      boolean
TRUE
SYS@orclstd>