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.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google