Schema not appearing on Mirror

Hi, I updated the schema on our live node, but the change did not occur on the mirror server. Is there some setting that I need to enable? Everything else seems to be updating but the schema has not

Can you advice on what I could be missing or is this something that is known?

Regards,

Eric

  • 0
  • 0
  • 38
  • 0
  • 1

Answers

Check if your schema is really homed in the DB that is mirrored.
If it is mapped from a different DB / Namespace the mirror setting of the home DB applies.

Also check mapping settings for both sides.
Mapping is stored in namespace"%SYS" which typically not participates any mirror.
[ just had a similar experience a few weeks ago ]