1.背景
在日常运维中难免会遇到有迁移磁盘的需求,例如从A盘迁移到B盘,该如何去操作呢?下面给大家分享下,单机环境,与读写分离集群操作相同
2.记录原环境信息
[dmdba@node3 ~]$ ps -ef|grep dmdb
dmdba 998291 1 1 3月04 ? 02:26:31 /opt/dm8/bin/dmserver /dmdata/DAMENG/dm.ini -noconsole mount
dmdba 3212876 1 0 2月09 ? 00:01:10 /opt/dm8/bin/dmap
dmdba 3315873 1 0 2月10 ? 01:10:59 /opt/dm8/bin/dmwatcher /dmdata/DAMENG/dmwatcher.ini
3.停止数据库服务与守护进程
DmWatcherServiceDMWATCHER stop
DmServiceDMSERVER stop
4.拷贝数据文件到新目录
拷贝整个数据文件到新路劲下:
cp -r dmdata /data
5.转换原控制文件
cd /opt/dm8/bin/
./dmctlcvt TYPE=1 SRC=/dmdata/DAMENG/dm.ctl DEST=/dmdata/DAMENG/dmctl.txt
6.修改dmctl.txt路径参数
查询需要修改的内容:
[dmdba@node3 DAMENG]$ cat dmctl.txt |grep /dmdata/
fil_path=/dmdata/DAMENG/SYSTEM.DBF
fil_path=/dmdata/DAMENG/ROLL.DBF
fil_path=/dmdata/DAMENG/DAMENG01.log
fil_path=/dmdata/DAMENG/DAMENG02.log
fil_path=/dmdata/DAMENG/MAIN.DBF
fil_path=/dmdata/OADATA/GCLOUD_SRR01.dbf
fil_path=/dmdata/OADATA/GCLOUD_SRR_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_BSP01.dbf
fil_path=/dmdata/OADATA/GCLOUD_BSP_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_BPM01.dbf
fil_path=/dmdata/OADATA/GCLOUD_BPM_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_CFORM01.dbf
fil_path=/dmdata/OADATA/GCLOUD_CFORM_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_SC01.dbf
fil_path=/dmdata/OADATA/GCLOUD_SC_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_PORTAL01.dbf
fil_path=/dmdata/OADATA/GCLOUD_PORTAL_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_CFILE01.dbf
fil_path=/dmdata/OADATA/GCLOUD_CFILE_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_EDOC01.dbf
fil_path=/dmdata/OADATA/GCLOUD_EDOC_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_MEETING01.dbf
fil_path=/dmdata/OADATA/GCLOUD_MEETING_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_CMS01.dbf
fil_path=/dmdata/OADATA/GCLOUD_CMS_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_MOBILESERVER01.dbf
fil_path=/dmdata/OADATA/GCLOUD_MOBILESERVER_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_FTS01.dbf
fil_path=/dmdata/OADATA/GCLOUD_FTS_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_OA01.dbf
fil_path=/dmdata/OADATA/GCLOUD_OA_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_PLAN01.dbf
fil_path=/dmdata/OADATA/GCLOUD_PLAN_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_EXSRR01.dbf
fil_path=/dmdata/OADATA/GCLOUD_EXSRR_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_EXBSP01.dbf
fil_path=/dmdata/OADATA/GCLOUD_EXBSP_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_EXEDOC01.dbf
fil_path=/dmdata/OADATA/GCLOUD_EXEDOC_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_EXPORTAL01.dbf
fil_path=/dmdata/OADATA/GCLOUD_EXPORTAL_IDX01.dbf
fil_path=/dmdata/OADATA/GCLOUD_EXSC01.dbf
fil_path=/dmdata/OADATA/GCLOUD_EXSC_IDX01.dbf
htspath=/dmdata/DAMENG/HMAIN
[dmdba@node3 DAMENG]$
修改/dmdata为/data
7.更新控制文件
把原来的 dm.ctl 文件备份为 dm.ctl.bak ,转换新的 dmctl.txt 为新的 dm.ctl
cd /opt/dm8/bin/
./dmctlcvt TYPE=2 SRC=/dmdata/DAMENG/dmctl.txt DEST=/data/DAMENG/dm.ctl
8.修改配置文件
vi dm.ini把所有的/dmdata改为/data
同时需要修改dmarch.ini 归档日志路径
9.修改服务器启动脚本
将原来的/dmdata替换为/data
cd /opt/dm8/bin
vi DmServiceDMSERVER
INI_PATH=“/data/DAMENG/dm.ini”
#修改守护进程服务地址
vi DmWatcherServiceDMWATCHER
INI_PATH=“/data/DAMENG/dmwatcher.ini”
10.启动数据库服务
DmServiceDMSERVER start
DmWatcherServiceDMWATCHER start
注意:
如果是集群数据,备库修改可能会遇到一个问题,备库停止服务之后会导致主库处于 挂起 的状态影响业务
解决办法:是将主备恢复正常,通过监视器将备库剔除集群服务,登录监视器使用以下命令操作
detach database DM2
恢复完成之后,如何加入集群呢?使用方式如下
attach database DM2
文章
阅读量
获赞