Standby Database Troubleshooting Sync Issues

• ORA-16047: DGID mismatch between destination setting and target database
• ORA-19502: write error on file "", block number (block size=)

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

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

The error shows a miss-match of DG_CONFIG parameter. Check the below parameters on both Primary and Standby databases.

On Primary:

SQL> show parameter log_archive_config

NAME                                 TYPE        VALUE

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

log_archive_config                   string      DG_CONFIG=(RUDBA,RUDBA_STANDBY)

SQL> show parameter fal

SQL> show parameter fal

NAME                                 TYPE        VALUE

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

fal_client                           string      RUDBA

fal_server                           string      RUDBA_STANDBY

SQL> show parameter log_archive_dest_2                  

log_archive_dest_2                   string      SERVICE=RUDBA_STANDBY LGWR ASYNC=20480

                                                 DB_UNIQUE_NAME=RUDBA_STANDBY OPTIONAL REOPEN=15  

                                                 MAX_FAILURE=10 NET_TIMEOUT=30

             

SQL> show parameter log_archive_dest_state_2            

log_archive_dest_state_2             string      ENABLE

On Standby:

SQL> show parameter log_archive_config

NAME                                 TYPE        VALUE

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

log_archive_config                   string      DG_CONFIG=(RUDBA,RUDBA_STANDBY)

SQL> show parameter fal

SQL> show parameter fal

NAME                                 TYPE        VALUE

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

fal_client                           string      RUDBA_STANDBY

fal_server                           string      RUDBA

SQL> show parameter log_archive_dest_2

                 

log_archive_dest_2                   string      SERVICE=RUDBA LGWR ASYNC=20480 DB_UNIQUE_NAME=RUDBA

                                                 OPTIONAL REOPEN=15 MAX_FAILURE=10 NET_TIMEOUT=30

SQL> show parameter log_archive_dest_state_2

           

log_archive_dest_state_2             string      DEFER

If any of the above parameters are not set correctly the below error will appear.

set line 200

col DEST_NAME for a50

col BINDING for a10

select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE'

/

DEST_ID DEST_NAME          STATUS    BINDING    ERROR

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

      1 LOG_ARCHIVE_DEST_1 VALID     OPTIONAL

      2 LOG_ARCHIVE_DEST_2 DISABLED  OPTIONAL   ORA-16047: DGID mismatch between destination setting and tar database

If the parameters are set correct.

set line 200

col DEST_NAME for a50

col BINDING for a10

select DEST_ID,DEST_NAME,STATUS,BINDING,ERROR from v$ARCHIVE_DEST where status<>'INACTIVE'

/

DEST_ID DEST_NAME          STATUS    BINDING    ERROR

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

      1 LOG_ARCHIVE_DEST_1 VALID     OPTIONAL

      2 LOG_ARCHIVE_DEST_2 VALID     OPTIONAL