12c DG Broker Configuration – Error ORA-16698
Issue
[oracle@rac1 ~]$ dgmgrl DGMGRL for Linux: Release 12.2.0.1.0 - Production on Thu May 16 18:03:42 2019 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. DGMGRL> connect / Connected to "DELL" Connected as SYSDG. DGMGRL> DGMGRL> create configuration 'DELL' as primary database is 'DELL' connect identifier is DELL; Configuration "DELL" created with primary database "DELL" DGMGRL> DGMGRL> add database 'DELL_DG' as connect identifier is DELL_DG maintained as physical; Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set Failed. DGMGRL> DGMGRL> exit
Solution
1. Remove the DG Broker configuration
DGMGRL> remove configuration;
Removed configuration
DGMGRL>
2. Disable log_archive_dest_2
On Primary
SQL> show parameter log_archive_dest_2 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_2 string SERVICE=DELL_DG LGWR ASYNC VAL ID_FOR=(ONLINE_LOGFILES,PRIMAR Y_ROLE) DB_UNIQUE_NAME=DELL_DG SQL> SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='' scope=both; System altered. SQL> show parameter log_archive_dest_2 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_2 string SQL>
On Standby
SQL> show parameter log_archive_dest_2 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_2 string SERVICE=DELL LGWR ASYNC VALID_ FOR=(ONLINE_LOGFILES,PRIMARY_R OLE) DB_UNIQUE_NAME=DELL SQL> SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='' scope=both; System altered. SQL> show parameter log_archive_dest_2 NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_2 string SQL>
3. Disable / Enable DG Broker
On Primary
SQL> show parameter dg_broker_start NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_start boolean TRUE SQL> SQL> alter system set dg_broker_start=false scope=both; System altered. SQL> alter system set dg_broker_start=true scope=both; System altered. SQL> show parameter dg_broker_start NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_start boolean TRUE SQL>
On Standby
SQL> show parameter dg_broker_start NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_start boolean TRUE SQL> SQL> alter system set dg_broker_start=false scope=both; System altered. SQL> alter system set dg_broker_start=true scope=both; System altered. SQL> show parameter dg_broker_start NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ dg_broker_start boolean TRUE SQL>
4. Configure DG Broker
On Primary
[oracle@rac1 ~]$ dgmgrl DGMGRL for Linux: Release 12.2.0.1.0 - Production on Thu May 16 18:25:13 2019 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. Welcome to DGMGRL, type "help" for information. DGMGRL> connect / Connected to "DELL" Connected as SYSDG. DGMGRL> create configuration 'DELL' as primary database is 'DELL' connect identifier is DELL; Configuration "DELL" created with primary database "DELL" DGMGRL> DGMGRL> add database 'DELL_DG' as connect identifier is DELL_DG maintained as physical; Database "DELL_DG" added DGMGRL> DGMGRL> show configuration; Configuration - DELL Protection Mode: MaxPerformance Members: DELL - Primary database DELL_DG - Physical standby database Fast-Start Failover: DISABLED Configuration Status: DISABLED DGMGRL>
5. Enbale LOG_ARCHIVE_DEST_2
On Primary
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(DELL,DELL_DG)' scope=both; System altered. SQL> SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=DELL_DG LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DELL_DG' scope=both; System altered. SQL>
On Standby
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(DELL,DELL_DG)' scope=both; System altered. SQL> SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=DELL LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DELL' scope=both; System altered. SQL>
6. Enable DG Broker Configuration
DGMGRL> enable configuration; Enabled. DGMGRL> DGMGRL> show configuration; Configuration - DELL Protection Mode: MaxPerformance Members: DELL - Primary database DELL_DG - Physical standby database (disabled) Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 11 seconds ago) <---- DGMGRL> Useful commands: DGMGRL> show database "DELL" InconsistentProperties INCONSISTENT PROPERTIES INSTANCE_NAME PROPERTY_NAME MEMORY_VALUE SPFILE_VALUE BROKER_VALUE DGMGRL> show database "DELL_DG" statusreport STATUS REPORT INSTANCE_NAME SEVERITY ERROR_TEXT DGMGRL>
Recommendation:
Please DON’T create password file on standby. Please copy from 12c primary to 12c standby server.
Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.
Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
WhatsApp : +
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/