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:
========= 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
========= 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.
I would disable the configuration, remove the configuration, delete the dg_broker_config files at both sites, and stop the dg_broker processes at both sites. Then start the dg_broker again, and re-create the configuration. No down time, and it takes only a few minutes.
Edited by: JohnWatson on Feb 13, 2013 9:52 AM
Edited by: JohnWatson on Feb 13, 2013 9:54 AM
Be sure to PRESERVE DESTINATIONS when removing the config.
Looks like problem with the configuration. Check below document on how to reconfigure a dataguard broker configuration.
Step By Step How to Recreate Dataguard Broker Configuration [ID 808783.1]
Mark your Post as Answered or Helpful if Your question is answered.
Thanks & Regards,
Email : email@example.com
there isn't any ora error, the complete line is the following : Standby database ID mismatch [0x2b7ec0ba:0x2aad4634] (729727162:715998772) SQL> select switchover_status from v$database; SWITCHOVER_STATUS -------------------- NOT ALLOWED
I can see this in other trace files (STB_rfs_28936.trc ) >> krso_proc_add: Detected dead process 28836; subsuming V$MANAGED_STANDBY slot
**** 2013-02-13 13:58:05.279 4320 krsh.c* Standby database ID mismatch [0x2b7ec0ba:0x2aad4634] (729727162:715998772)
Thanks for your attention...