环境:
OS:Centos 7
DB:DMV8
1.停掉dmwatcher并删除服务
[root@host02 root]# systemctl stop DmWatcherServiceGRP1
[root@host02 root]# cd /dmdbms/product/script/root
[root@host02 root]# ./dm_service_uninstaller.sh -n DmWatcherServiceGRP1
2.删除实时归档
[dmdba@host02 DAMENG]$ vi dmarch.ini [ARCHIVE_REALTIME] ARCH_TYPE = REALTIME #实时归档类型 ARCH_DEST = DAMENG #实时归档目标实例名,这里是主库的实例名 [ARCHIVE_LOCAL1] ARCH_TYPE = LOCAL #本地归档类型 ARCH_DEST = /dmdbms/arch #本地归档文件存放路径 ARCH_FILE_SIZE = 2048 #单位Mb,本地单个归档文件最大值 ARCH_SPACE_LIMIT = 0 #单位Mb,0 表示无限制,范围 1024~4294967294M ARCH_FLUSH_BUF_SIZE = 0 ARCH_HANG_FLAG = 1
删除实时归档部分
3.若在该机器配置部署了监控机的话也要删除
[root@host02 root]#systemctl stop DmMonitorServiceMonitor
[root@host02 root]# ./dm_service_uninstaller.sh -n DmMonitorServiceMonitor
4.删除dmmal.ini配置文件
注意这里还需要修改配置文件,把MAL_INI参数原来的1改成0,ALTER_MODE_STATUS原来的0该成1
vi /dmdbms/data/DAMENG/dm.ini
MAL_INI= 0 #dmmal.ini
ALTER_MODE_STATUS =1
5.重启数据库
systemctl stop DmServiceDMSERVER.service
systemctl start DmServiceDMSERVER.service
6.重置oguid并修改模式
SQL>alter database mount; SQL>sp_set_oguid(0); SQL>alter database normal; SQL> select name,status$,mode$,OGUID from v$instance; LINEID name status$ mode$ OGUID ---------- --------- ------- ------ ----------- 1 DAMENGBAK OPEN NORMAL 0 used time: 0.590(ms). Execute id is 504.
标签:host02,删除,root,数据库,SQL,主从关系,归档,ARCH,达梦 From: https://www.cnblogs.com/hxlasky/p/18094402