This discussion is archived
11 Replies Latest reply: Feb 13, 2013 11:32 PM by 673402 RSS

Standby database ID mismatch - Oracle Data Guard 11gR2

673402 Newbie
Currently Being Moderated
Hi guys,
for several days I've been seeing in the alert.log of my physical standby database the following trace:

Standby database ID mismatch

The redo apply is working properly, but I can't activate the Data Guard broker. My oracle parameters are the following:

PRIMARY SITE
=========
log_archive_config       DG_CONFIG=(PRIM, STB)
fal_server                   STB
log_archive_dest_2     SERVICE=STB NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=STB

STANDBY SITE
=========
log_archive_config       DG_CONFIG=(PRIM, STB)
fal_server                   PRIM
log_archive_dest_2     SERVICE=PRIM NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PRIM


When i try to activate dataguard broker configuration at primary site, i see the following:

DGMGRL> show configuration+
Configuration - Dataguard.cfg+

Protection Mode: MaxPerformance+
Databases:+
STB - Primary database+
PRIM    - Physical standby database (disabled)**+

Fast-Start Failover: DISABLED+

Configuration Status:+
SUCCESS+


But in standby site:

DGMGRL> show configuration*
ORA-16603: Data Guard broker detected a mismatch in configuration ID*

Configuration details cannot be determined by DGMGRL*


Any help would be appreciate.

Thanks in advance.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points