11 Replies Latest reply: Feb 14, 2013 1:35 AM by Step_Into_Oracle_DBA RSS

    Standby database ID mismatch - Oracle Data Guard 11gR2

    673402
      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.