Mirrored databases are mounted read-only after removing the mirror

Article

Tomoko Furuzono · Aug 8 2m read

#Mirroring #Tips & Tricks #InterSystems IRIS #Caché #Ensemble #InterSystems IRIS for Health

InterSystems FAQ rubric

If you do not specify the option to remove the mirror attribute of the mirror database when deleting the mirror configuration, the database cannot be restored to a normal state and will be mounted read-only the next time it is mounted. To restore the database to a read-write state, you must remove the mirror attribute using the system routine ^MIRROR.

The procedure is as follows (execute in the %SYS namespace):

%SYS>do ^MIRROR This instance is not initialized as a mirror member 1) List mirrored databases
2) Remove one or more mirrored databases ※Select this menu
3) Create a Mirror
4) Join Mirror as Failover Member
5) Join Mirror as Async Member Option? 2　　　　　　　　　　　　　　　　　※Enter 2
There is one mirrored database on this system
Remove it? y　　　　　　　　　　　※Enter yes or y
Removing c:\intersystems\ensemble\mgr\mtest\ ...succeeded
Press to return to the main menu...

[Additional Information] When deleting the mirror configuration on each failover member, the menu shown below will be displayed, asking whether you want to delete the database mirror attributes as well.

In addition to the above, do you also want to remove mirror attribute of
mirrored databases (the databases themselves will not be deleted)? y

The default selection is <no>, so if you do not specify y or yes, the mirror attribute will not be deleted. For information on how to use ^MIRROR and how to delete the mirror configuration, please refer to the following documentation page:
Mirroring [IRIS]
Mirroring

Go to the original post written by @Tomoko Furuzono

Mirrored databases are mounted read-only after removing the mirror configuration

InterSystems FAQ rubric