达梦数据库-Linux DM数据守护主备集群缩改为单机-记录总结1.1需求描述当前DM数据库1主1备1监视器数据守护主备集群处于正常运行状态需将数据守护主备集群改为2个数据库单机。1.2环境说明1.3原主备集群环境信息查询select * from v$version;1.4操作步骤1.4.1检查确认监视器服务并停止su - dmdbaDmMonitorServiceGRP1 stop1.4.2主备机检查确认守护服务并停止su - dmdbaDmWatcherServiceGRP1 stop1.4.3修改主库数据库运行模式和删除实时归档配置SP_SET_PARA_VALUE(1, ALTER_MODE_STATUS, 1);SP_SET_PARA_VALUE(1, ENABLE_OFFLINE_TS, 1);ALTER DATABASE MOUNT;ALTER DATABASE NORMAL;ALTER DATABASE open;或ALTER DATABASE open force;ALTER DATABASE DELETE ARCHIVELOG DEST GRP1_DW_02, TYPE REALTIME;select ARCH_TYPE,ARCH_DEST,ARCH_FILE_SIZE,ARCH_SPACE_LIMIT from v$dm_arch_ini;1.4.4修改备库数据库运行模式和删除实时归档配置SP_SET_PARA_VALUE(1, ALTER_MODE_STATUS, 1);SP_SET_PARA_VALUE(1, ENABLE_OFFLINE_TS, 1);ALTER DATABASE MOUNT;ALTER DATABASE NORMAL;ALTER DATABASE open;或ALTER DATABASE open force;ALTER DATABASE DELETE ARCHIVELOG DEST GRP1_DW_01, TYPE REALTIME;select ARCH_TYPE,ARCH_DEST,ARCH_FILE_SIZE,ARCH_SPACE_LIMIT from v$dm_arch_ini;1.4.5修改原主备库dm.ini中MAL_INI0修改dm.ini中MAL_INI 0关注是否有基于dmmal的link功能如果有则不关闭则不需要重启数据库服务DmServiceDAMENG restartSELECT PARA_NAME,PARA_VALUE FROM V$DM_INI WHERE PARA_NAME IN (MAL_INI);1.4.6修改主备机上DmServiceDAMENG中START_MODEmount改为START_MODEopen如果重启观察​​​​​​​1.4.7取消主备机上已注册的数据守护服务[root ~]# bash /opt/dmdbms/script/root/dm_service_uninstaller.sh -n DmWatcherServiceGRP1[root~]# systemctl disable DmWatcherServiceGRP1.service​​​​​​​1.4.8监视器机器取消已注册的监视器服务[root~]#bash /opt/dmdbms/script/root/dm_service_uninstaller.sh -n DmMonitorServiceGRP1[root~]# systemctl disable DmMonitorServiceGRP1.service更多达梦数据库运维指南、在线文档、相关资料、社区在线提问以及技术分享访问​​​​​​​达梦官网