4 Replies Latest reply: Dec 8, 2008 11:55 AM by 674499 RSS

    ORA-16047: DGID mismatch between destination setting and standby

    user537673
      My logs are not being transferred to the newly created DG standby DB.
      I am getting the following error in my alert* log.

      ORA-16047: DGID mismatch between destination setting and standby
      LGWR: Error 16047 creating archivelog file '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=
      (PROTOCOL=tcp)(HOST=dbbgdr)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=MENTDB02_XPT
      )(INSTANCE_NAME=MENTDB01)(SERVER=dedicated)))'

      I have checked the db_unique_name and this appears to be ok,
      e.g.

      On the STANDBY
      --------------

      SQL> show parameter db_unique_name;

      NAME TYPE VALUE
      ------------------------------------ ----------- -----------
      db_unique_name string MENTDB02
      SQL>

      SQL> show parameter log_archive_dest_2

      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      log_archive_dest_2 string service="(DESCRIPTION=(ADDRESS
      _LIST=(ADDRESS=(PROTOCOL=tcp)(
      HOST=dbbgdr)(PORT=1521)))(CONN
      ECT_DATA=(SERVICE_NAME=MENTDB0
      2_XPT)(INSTANCE_NAME=MENTDB01)
      (SERVER=dedicated)))", LGWR
      ASYNC NOAFFIRM delay=480 OPTI
      ONAL max_failure=0 max_connect
      ions=1 reopen=300 db_unique_
      name="MENTDB02" register net_t
      imeout=180 valid_for=(online_

      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      logfile,primary_role)
      SQL>

      on the PRIMARY
      -----------------------

      SQL> show parameter log_archive_dest_2

      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      log_archive_dest_2 string service="(DESCRIPTION=(ADDRESS
      _LIST=(ADDRESS=(PROTOCOL=tcp)(
      HOST=dbbgdr)(PORT=1521)))(CONN
      ECT_DATA=(SERVICE_NAME=MENTDB0
      2_XPT)(INSTANCE_NAME=MENTDB01)
      (SERVER=dedicated)))", LGWR
      ASYNC NOAFFIRM delay=480 OPTI
      ONAL max_failure=0 max_connect
      ions=1 reopen=300 db_unique_
      name="MENTDB02" register net_t
      imeout=180 valid_for=(online_

      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      logfile,primary_role)
      SQL>


      SQL> show parameter db_unique_name;

      NAME TYPE VALUE
      ------------------------------------ ----------- ----------------
      db_unique_name string MENTDB01