ORA-16047: DGID mismatch between destination setting and standby
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