Home » Server Options » Data Guard » Logs are not transmitting and ORA-16047 error (DGID mismatch error)
Logs are not transmitting and ORA-16047 error [message #273973] Fri, 12 October 2007 08:11 Go to next message
aidi-h
Messages: 44
Registered: November 2005
Member
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
  • Attachment: DG trace.txt
    (Size: 3.12KB, Downloaded 504 times)
Re: Logs are not transmitting and ORA-16047 error [message #273996 is a reply to message #273973] Fri, 12 October 2007 11:03 Go to previous messageGo to next message
Michel Cadot
Messages: 59747
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-16047: DGID mismatch between destination setting and standby
 *Cause:  The DB_UNIQUE_NAME specified for the destination does not match
          the DB_UNIQUE_NAME at the destination.
 *Action: Make sure the DB_UNIQUE_NAME specified in the LOG_ARCHIVE_DEST_n
          parameter defined for the destination matches the DB_UNIQUE_NAME
          parameter defined at the destination.

Regards
Michel
Re: Logs are not transmitting and ORA-16047 error [message #321910 is a reply to message #273973] Wed, 21 May 2008 15:56 Go to previous messageGo to next message
anjugandhi
Messages: 2
Registered: November 2007
Junior Member
were you able to resolve this? I'm getting the same error .
Re: Logs are not transmitting and ORA-16047 error [message #321914 is a reply to message #273973] Wed, 21 May 2008 16:06 Go to previous message
BlackSwan
Messages: 23026
Registered: January 2009
Senior Member
As a matter of fact, I got this EXACT error when practicing setting up Data Guard.
The error message clearly indicates what is wrong, but only YOU knows which value is correct & which is incorrect.
Previous Topic: how to apply redo log in standby database
Next Topic: data guard with oracle apps
Goto Forum:
  


Current Time: Sat Nov 22 08:26:47 CST 2014

Total time taken to generate the page: 0.08553 seconds