The mode parameter of the disk unmirror command changes the status column in sysdevices to indicate that mirroring has been disabled.
See System Administration Guide: Volume 1 > Initializing Database Devices and Reference Manual: Commands.
Its effects on the phyname and mirrorname columns in sysdevices depend on the side argument also:
side |
|||
primary |
secondary |
||
mode |
remove |
Name in mirrorname moved to phyname and mirrorname set to null; status changed |
Name in mirrorname removed; status changed |
retain |
Names unchanged; status changed to indicate which device is being deactivated |
disk unmirror name = "tranlog", side = "primary"