当执行添加物理备库动作时出现如下报错
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>
oracle DGMGRL ORA-16603报错的解决方法(DG Broker)
最新推荐文章于 2021-04-10 22:36:25 发布