ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set
Problem:
-bash-4.2$ dgmgrl sys@primary
DGMGRL for Release 12.2.0.1.0 – Production on Mon May 13 14:29:27 2019
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Welcome to DGMGRL, type “help” for information.
Connected to “primary”
Connected as SYSDBA.
DGMGRL> CREATE CONFIGURATION dg_primary_config AS PRIMARY DATABASE IS primary CONNECT IDENTIFIER IS primary;
Configuration “dg_primary_config” created with primary database “primary”
DGMGRL> ADD DATABASE standby AS CONNECT IDENTIFIER IS standby MAINTAINED AS PHYSICAL;
Error: ORA-16698: member has a LOG_ARCHIVE_DEST_n parameter with SERVICE attribute set
Failed.
Discovery:
both primary and standby have
SQL> show parameter LOG_ARCHIVE_DEST_2;
NAME TYPE VALUE
———————————— ———– ——————————
log_archive_dest_2 string SERVICE=standby LGWR ASYNC VA
LID_FOR=(ONLINE_LOGFILES,PRIMA
RY_ROLE) DB_UNIQUE_NAME=standby REOPEN=60
Solution:
Reset parameter to null on both PRIMARY and STANDBY and then try
SQL> alter system set LOG_ARCHIVE_DEST_2=” scope=both sid=’*’;
System altered.
DGMGRL> ADD DATABASE standby AS CONNECT IDENTIFIER IS standby MAINTAINED AS PHYSICAL;
Database “standby” added
WikiDBA 