Fix DGMGRL Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added

_____________________________________________________________________________________________________________________

Error Description

Dgmgrl Create configuration command failed with following error

DGMGRL> CREATE CONFIGURATION 'DG_Conf' AS PRIMARY DATABASE IS 'CMLPROD' CONNECT IDENTIFIER IS 'CMLPROD';

Error: ORA-16698: LOG_ARCHIVE_DEST_n parameter set for object to be added

Failed.

Solution Description

You have to reset the log_archive_dest_2 parameter which is applicable to your standby database to blank before you create the configuration through dgmgrl interface. In this example I have configured the LOG_ARCHIVE_DEST_2 for the first standby database.

SQL> show parameter LOG_ARCHIVE_DEST_2

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

log_archive_dest_2                   string      SERVICE=CMLPROD SYNC NOAFF

                                                 IRM VALID_FOR=(ONLINE_LOGFILES

                                                 ,PRIMARY_ROLE) DB_UNIQUE_NAME=

                                                 CMLPROD

SQL> alter system set LOG_ARCHIVE_DEST_2='' scope=both;

System altered.

DGMGRL> connect sys

Password:

Connected as SYSDG.

DGMGRL> CREATE CONFIGURATION 'DG_Conf' AS PRIMARY DATABASE IS 'CMLPROD' CONNECT IDENTIFIER IS 'CMLPROD';

Configuration "DG_Conf" created with primary database "CMLPROD"

The above create command internally will set the value for the log_archive_dest_2

SQL> show parameter LOG_ARCHIVE_DEST_2

log_archive_dest_2                   string      SERVICE=CMLPROD SYNC NOAFFIRM

                                                 VALID_FOR=(ONLINE_LOGFILES,PRI

                                                 MARY_ROLE) DB_UNIQUE_NAME=ONLP

                                                 ROD

You have to make the changes to Standby side also to make the proper working of data guard broker.

SQL> alter system set LOG_ARCHIVE_DEST_2='' scope=both;

System altered.

DGMGRL> ADD DATABASE 'CMLPRODSTBY' AS CONNECT IDENTIFIER IS CMLPRODSTBY;

Database "CMLPRODSTBY" added

DGMGRL> show configuration;

Configuration - DG_Conf

  Protection Mode: MaxAvailability

  Members:

  CMLPROD     - Primary database

    CMLPRODSTBY - Physical standby database

Fast-Start Failover: DISABLED

Configuration Status:

DISABLED

DGMGRL> enable configuration;

Enabled.

_____________________________________________________________________________________________________________________