Encountered an Error ORA-16698 while configuring oracle data guard broker ,when adding the physical standby database on windows environment.
DGMGRL> create configuration ‘BROKER_Config’ as primary database is ‘primary’ connect identifier is to_primary;
Configuration “BROKER_Config” created with primary database “primary”
DGMGRL> Add database ‘standby’ as connect identifier is to_standby maintained as physical;
Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set
Failed.
DGMGRL> exit
I think the solution for this problem is to remove the data guard configuration and do the configuration again.
Here below is the steps to solve the error encountered while doing your configuration:
- Remove the Data guard Broker Configuration
DGMGRL> connect sys/orcl@to_primary Connected to "primary" Connected as SYSDG DGMGRL> remove configuration; Removed configuration
- Disable log_archive_dest_2 parameter file on both primary and standby database
SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='' scope=both; System altered.
- Disable Data guard Broker on both primary and standby database.
SQL> alter system set dg_broker_start=false scope=both; System altered.
- And again Enable Data guard Broker on both primary and standby database.
SQL> alter system set dg_broker_start=true scope=both; System altered.
- Configure Data guard Broker on primary database.
DGMGRL> create configuration 'BROKER_Config' as primary database is 'primary' connect identifier is to_primary; Configuration "BROKER_Config" created with primary database "primary" DGMGRL> Add database 'standby' as connect identifier is to_standby maintained as physical; Database "standby" added DGMGRL> show configuration Configuration - BROKER_Config Protection Mode: MaxPerformance Members: primary - Primary database standby - Physical standby database Fast-Start Failover: DISABLED Configuration Status: DISABLED
- Enable LOG_ARCHIVE_DEST_2 parameter file on both primary and physical standby database.
----On Primary SQL> ALTER SYSTEM SET Log_archive_dest_2='Service=to_standby lgwr sync VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=standby' scope=both; System altered. ---- On Standby SQL > ALTER SYSTEM SET Log_archive_dest_2='Service=to_primary lgwr sync VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=primary' scope=both; System altered.
- Enable LOG_ARCHIVE_CONFIG on both primary and standby database.
SQL> ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(primary,standby)' scope=both; System altered.
- Then enable data guard broker configuration.
DGMGRL> enable configuration; Enabled. DGMGRL> GMGRL> show configuration Configuration - BROKER_Config Protection Mode: MaxPerformance Members: primary - Primary database standby - Physical standby database Fast-Start Failover: DISABLED Configuration Status: SUCCESS (status updated 42 seconds ago)
You can also refer the Data guard configuration that I have implemented on my machine on windows environment.