Schema not appearing on Mirror

Question

Question

ED Coder · Dec 5, 2018

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

Discussion (2)0

Log in or sign up to continue

ED Coder · Dec 11, 2018

Hi Robert,

Thank you for responding to my question.

Looks like the default schema is in the ENSLIB namespace which does not get mirrored. I will need to create a new custom schema and make changes there which will then get backed up.

Regards,

Eric

0 0

score 1 · Answer 1 · 2018-12-05T06:19:46-05:00

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 ]