Skip to content

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

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: