OraFAQ Forum: Data Guard » Logs are not transmitting and ORA-16047 error

Home » Server Options » Data Guard » Logs are not transmitting and ORA-16047 error (DGID mismatch error)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Logs are not transmitting and ORA-16047 error [message #273973]

Fri, 12 October 2007 08:11

aidi-h
Messages: 45
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 3153 times)

Report message to a moderator

Re: Logs are not transmitting and ORA-16047 error [message #273996 is a reply to message #273973]

Fri, 12 October 2007 11:03

Michel Cadot
Messages: 68749
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Code: [Select all] [Show/ hide]

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

Report message to a moderator

Re: Logs are not transmitting and ORA-16047 error [message #321910 is a reply to message #273973]

Wed, 21 May 2008 15:56

anjugandhi
Messages: 2
Registered: November 2007

Junior Member

were you able to resolve this? I'm getting the same error .

Report message to a moderator

Re: Logs are not transmitting and ORA-16047 error [message #321914 is a reply to message #273973]

Wed, 21 May 2008 16:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Previous Topic:	how to apply redo log in standby database
Next Topic:	data guard with oracle apps

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Mar 12 03:01:36 CDT 2025