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

DGMGRL> add far_sync 'ftesta' as connect identifier is ftesta;
Error: ORA-16603: member is part of another Data Guard broker configuration
Failed.
DGMGRL> 
DGMGRL> remove far_sync 'ftesta'
Object "ftesta" was not found
DGMGRL>

Bug 25063971 Data Guard Broker externaldestination Should Mupport Multiple Primary Configuration
The fix for 25063971 is first included in
18.1.0
12.2.0.1.171121 (Nov 2017) Database Release Update (DB RU)
12.2.0.1.DBJAN2018RUR:180417(Apr 2018) Database Release Update Revision(DB RUR)
12.2.0.1.171130 (Nov 2017) Bundle Patch for Windows Platforms
–ORA-16642 修改名称不可取

DGMGRL> add far_sync 'fftestag' as connect identifier is fftestag;
Error: ORA-16642: DB_UNIQUE_NAME mismatch
Failed.
DGMGRL>

重新配置重新初始化FAR_SYNC的broker配置文件:

SQL> alter system set dg_broker_config_file1='/u01/app/oracle/product/12.2.0/db_1/dbs/dr1ftestag3.dat.1';
System altered.
SQL> alter system set dg_broker_config_file2='/u01/app/oracle/product/12.2.0/db_1/dbs/dr1ftestag3.dat.2';
System altered.
SQL> alter system set dg_broker_start=true;
System altered.
SQL>
This entry was posted in oracle 12c. Bookmark the permalink.