1 达梦数据库-Linux DM数据守护主备集群改为单机-记录总结

1.1需求描述

当前DM数据库守护主备集群处于正常运行状态，需将数据守护主备集群改为2个数据库单机。

1.1环境说明

1.2原主备集群环境

信息查询
select * from v$version;

1.3操作步骤

1.3.1检查确认监视器服务并停止

su - dmdba
DmMonitorServiceGRP1 stop

1.3.2主备机检查确认守护服务并停止

su - dmdba
DmWatcherServiceGRP1 stop

1.3.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.3.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.3.5修改原主备库dm.ini中MAL_INI=0

修改dm.ini中MAL_INI = 0
关注是否有基于dmmal的link功能，如果有，则不关闭，则不需要重启数据库服务
DmServiceDAMENG restart
SELECT PARA_NAME,PARA_VALUE FROM V$DM_INI WHERE PARA_NAME IN (‘MAL_INI’);

1.3.6修改主备机上DmServiceDAMENG中

START_MODE=mount改为START_MODE=open
如果重启，观察

1.3.7取消主备机上已注册的数据守护服务

[root@ ~]# bash /opt/dmdbms/script/root/dm_service_uninstaller.sh -n DmWatcherServiceGRP1
[root@~]# systemctl disable DmWatcherServiceGRP1.service

1.3.8监视器机器取消已注册的监视器服务

[root@~]#bash /opt/dmdbms/script/root/dm_service_uninstaller.sh -n DmMonitorServiceGRP1
[root@~]# systemctl disable DmMonitorServiceGRP1.service