ORA-16047: DGID mismatch between destination setting and target database

ORA-16047: DGID mismatch between destination setting and target database

Step-1: Error check in in v$archive_dest.

select dest_id,status,error from v$archive_dest;

DEST_ID  STATUS       ERROR

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

1       VALID

2       VALID

3       DISABLED      ORA-16047: DGID mismatch between destination setting and target database

Step-2: Check db_name, db_unique_name and log_archive_config parameter on Primary and standby database.

On PRIMARY

SQL> show parameter db_name;

NAME                                 TYPE        VALUE

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

db_name                              string      remitdb

SQL>

SQL> show parameter db_unique_name;

NAME                                 TYPE        VALUE

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

db_unique_name                       string      remitdb

SQL>

SQL> show parameter log_archive_config;

NAME                                 TYPE        VALUE

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

log_archive_config                   string      DG_CONFIG=(remitdb,remitdbstd,

                                                 remitdbdr)

SQL>

On STANDBY

SQL> show parameter db_name;

NAME                                 TYPE        VALUE

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

db_name                              string      remitdb

SQL>

SQL> show parameter db_unique_name;

NAME                                 TYPE        VALUE

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

db_unique_name                       string      remitdb

SQL>

SQL> show parameter log_archive_config;

NAME                                 TYPE        VALUE

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

log_archive_config                   string      DG_CONFIG=(remitdb,remitdbstd,

                                                 remitdbdr)

SQL>

Problem Identification and Solution: In STANDBY DATABASE db_unique_name is incorrect. In STANDBY DATABASE db_unique_name will remitdbdr instead of remitdb.