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
12345
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
12
SQL>
ALTER
SYSTEM
SET
LOG_ARCHIVE_DEST_2=
''
scope=both;
System altered.
- Disable Data guard Broker on both primary and standby database.
12
SQL>
alter
system
set
dg_broker_start=
false
scope=both;
System altered.
- And again Enable Data guard Broker on both primary and standby database.
12
SQL>
alter
system
set
dg_broker_start=
true
scope=both;
System altered.
- Configure Data guard Broker on primary database.
12345678910111213
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.
123456
----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.
12
SQL>
ALTER
SYSTEM
SET
LOG_ARCHIVE_CONFIG=
'DG_CONFIG=(primary,standby)'
scope=both;
System altered.
- Then enable data guard broker configuration.
123456789101112
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.