热门搜索
分布式
数据库一体机
云数据库
建设银行
保险核心
密集交易
注册
生产环境DSC更换存储
技术分享/ 文章详情 /

生产环境DSC更换存储

竹蜻蜓vYv 2024/08/09 696 0 0

1.查看新的磁盘

3600e000000a0d4706128dce81f56b537 /dev/sdu 16.0G
3600e000000a0d4706128e2f733aefdf3 /dev/sdy 16.0G
3600e000000a0d47061290971457581af /dev/sdab 2867.2G

2.配置multipath.conf和rules文件
2.1.配置multipath.conf（每个节点都修改）

[root@poc01:/root]# cat /etc/multipath.conf
defaults {
  polling_interval        30
  failback                immediate
  no_path_retry           5
  rr_min_io               100
  path_checker            tur
  user_friendly_names     yes
  find_multipaths         yes
  path_grouping_policy    multibus
}

blacklist {
  devnode "^(ram|raw|loop|fd|md|dm-|sr|scd|st)[0-9]*"
  devnode "^(hd|xvd|vd)[a-z]*"
}

multipaths {
  #multipath {
  #  wwid   "200173800664e00b5"
  #  alias  dmdcr01
  #}
  #multipath {
  #  wwid   "200173800664e00b6"
  #  alias  dmvote01
  #}
  multipath {
    wwid   "200173800664e00b3"
    alias  dmdata01
  }
  multipath {
    wwid   "36000e000000a0d470612022a67b29b2d"
    alias  H3Cdata01
  }
  multipath {
    wwid   "3600e000000a0d4706128dce81f56b537"
    alias  dmdcr001
  }
  multipath {
    wwid   "3600e000000a0d4706128e2f733aefdf3"
    alias  dmvote001
  }
  multipath {
    wwid   "3600e000000a0d47061290971457581af"
    alias  dmdata001
  }
}

devices {
  device {
    path_grouping_policy  group_by_prio
    prio alua  #failover
  }
}

2.2.配置12-dm-permissions.rules（每个节点都修改）

#KERNEL=="dm-*", ENV{DM_UUID}=="mpath-200173800664e00b5", SYMLINK+="asmdisk/dmdcr01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
#KERNEL=="dm-*", ENV{DM_UUID}=="mpath-200173800664e00b6", SYMLINK+="asmdisk/dmvote01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-200173800664e00b3", SYMLINK+="asmdisk/dmdata01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-3600e000000a0d4706128dce81f56b537", SYMLINK+="asmdisk/dmdcr001", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-3600e000000a0d4706128e2f733aefdf3", SYMLINK+="asmdisk/dmvote001", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-3600e000000a0d47061290971457581af", SYMLINK+="asmdisk/dmdata001", OWNER="dmdba", GROUP="dinstall", MODE="0660"

2.3.使asm磁盘生效（每个节点都修改）

multipath -F && multipath -r
/sbin/udevadm control --reload-rules                 # 重新加载udev规则
/sbin/udevadm trigger --type=devices --action=change # 触发设备变化事件

2.4.查看asm磁盘

lrwxrwxrwx 1 root root 8 7月  30 12:25 dmdata001 -> ../dm-10
lrwxrwxrwx 1 root root 7 7月  30 12:25 dmdata01 -> ../dm-2
lrwxrwxrwx 1 root root 8 7月  30 12:25 dmdcr001 -> ../dm-12
lrwxrwxrwx 1 root root 8 7月  30 12:25 dmvote001 -> ../dm-11

3.修改dmdcr_cfg.ini

[dmdba@poc01:~/dmdata/DMDSC]$ cat dmdcr_cfg.ini
DCR_N_GRP = 3
DCR_VTD_PATH = /dev/asmdisk/dmvote001
DCR_OGUID = 420507
[GRP]
DCR_GRP_TYPE = CSS
DCR_GRP_NAME = GRP_CSS
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[GRP_CSS]
DCR_EP_NAME = CSS0
DCR_EP_HOST = 192.168.2.131
DCR_EP_PORT = 9341
[GRP_CSS]
DCR_EP_NAME = CSS1
DCR_EP_HOST = 192.168.2.132
DCR_EP_PORT = 9341
[GRP]
DCR_GRP_TYPE = ASM
DCR_GRP_NAME = GRP_ASM
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[GRP_ASM]
DCR_EP_NAME = ASM0
DCR_EP_SHM_KEY = 93360
DCR_EP_SHM_SIZE = 512
DCR_EP_HOST = 192.168.2.131
DCR_EP_PORT = 9351
DCR_EP_ASM_LOAD_PATH = /dev/asmdisk
[GRP_ASM]
DCR_EP_NAME = ASM1
DCR_EP_SHM_KEY = 93361
DCR_EP_SHM_SIZE = 512
DCR_EP_HOST = 192.168.2.132
DCR_EP_PORT = 9351
DCR_EP_ASM_LOAD_PATH = /dev/asmdisk
[GRP]
DCR_GRP_TYPE = DB
DCR_GRP_NAME = GRP_DMDSC
DCR_GRP_N_EP = 2
DCR_GRP_DSKCHK_CNT = 60
[GRP_DMDSC]
DCR_EP_NAME = DMDSC0
DCR_EP_SEQNO = 0
DCR_EP_PORT = 5236
DCR_CHECK_PORT = 9361
[GRP_DMDSC]
DCR_EP_NAME = DMDSC1
DCR_EP_SEQNO = 1
DCR_EP_PORT = 5236
DCR_CHECK_PORT = 9361

4.初始化ASM磁盘
4.1.修改asmdisk.txt文件

[dmdba@poc01:~/dmdata/DMDSC]$ cat asmdisk.txt 
#asm script file
create dcrdisk '/dev/asmdisk/dmdcr001' 'dmdcr001'
create votedisk '/dev/asmdisk/dmvote001' 'dmvote001'
create asmdisk '/dev/asmdisk/dmdata001' 'dmdata001'
init dcrdisk '/dev/asmdisk/dmdcr001' from '/home/dmdba/dmdata/DMDSC/dmdcr_cfg.ini' identified by 'Dameng1'
init votedisk '/dev/asmdisk/dmvote001' from '/home/dmdba/dmdata/DMDSC/dmdcr_cfg.ini'

4.2.初始化asm磁盘

dmasmcmd script_file=asmdisk.txt

5.修改dmdcr.ini（每个节点都修改）

DMDCR_PATH                 = /dev/asmdisk/dmdcr001
DMDCR_MAL_PATH             = /home/dmdba/dmdata/DMDSC/dmasvrmal.ini
DMDCR_SEQNO                = 0
DMDCR_ASM_RESTART_INTERVAL = 180
DMDCR_ASM_STARTUP_CMD      = /home/dmdba/dmdbms/bin/DmASMSvrServiceAsmsvr start
DMDCR_DB_RESTART_INTERVAL  = 360
DMDCR_DB_STARTUP_CMD       = /home/dmdba/dmdbms/bin/DmServiceDMDSC start
DMDCR_AUTO_OPEN_CHECK      = 111
DMDCR_ASM_TRACE_LEVEL      = 2

6.重启CSS和ASM（先启动控制节点，再启动普通节点）

DmCSSServiceCss start
DmASMSvrServiceAsmsvr start

7.拷贝数据文件

dmasmtool dcr_ini=/home/dmdba/dmdata/DMDSC/dmdcr.ini
cp +DMDATA/dmdata/DMDSC/V7_DATA01.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA02.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA03.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA04.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA05.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA06.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA07.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA08.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA09.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA10.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA11.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA12.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA13.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA14.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA15.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA16.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_DATA17.DBF        +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_INDEX_DATA01.DBF  +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_INDEX_DATA02.DBF  +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_INDEX_DATA03.DBF  +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_INDEX_DATA04.DBF  +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_INDEX_DATA05.DBF  +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_INDEX_DATA06.DBF  +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_INDEX_DATA07.DBF  +DATA/dmdata/DMDSC
cp +DMDATA/dmdata/DMDSC/V7_INDEX_DATA08.DBF  +DATA/dmdata/DMDSC

8.修改参数文件路径

sed -i 's/\+DMDATA/\+DATA/g' dmarch.ini
sed -i 's/\+DMDATA/\+DATA/g' dm.ini

9.修改控制文件

dmctlcvt TYPE=1 SRC=+DATA/dmdata/DMDSC/dm.ctl DEST=/home/dmdba/dmctl.txt DCR_INI=/home/dmdba/dmdata/DMDSC/dmdcr.ini
sed -i 's/\+DMDATA/\+DATA/g' dmctl.txt
dmctlcvt TYPE=2 SRC=/home/dmdba/dmctl.txt DEST=+DATA/dmdata/DMDSC/dm.ctl DCR_INI=/home/dmdba/dmdata/DMDSC/dmdcr.ini

10.启动数据库实例（先启动控制节点，再启动普通节点）

DmServiceDMDSC start

11.删除旧的磁盘组
11.1.修改multipath。conf（每个节点都修改）

[root@poc01:/dev/asmdisk]# cat /etc/multipath.conf
defaults {
  polling_interval        30
  failback                immediate
  no_path_retry           5
  rr_min_io               100
  path_checker            tur
  user_friendly_names     yes
  find_multipaths         yes
  path_grouping_policy    multibus
}

blacklist {
  devnode "^(ram|raw|loop|fd|md|dm-|sr|scd|st)[0-9]*"
  devnode "^(hd|xvd|vd)[a-z]*"
}

multipaths {
  #multipath {
  #  wwid   "200173800664e00b5"
  #  alias  dmdcr01
  #}
  #multipath {
  #  wwid   "200173800664e00b6"
  #  alias  dmvote01
  #}
  #multipath {
  #  wwid   "200173800664e00b3"
  #  alias  dmdata01
  #}
  multipath {
    wwid   "36000e000000a0d470612022a67b29b2d"
    alias  H3Cdata01
  }
  multipath {
    wwid   "3600e000000a0d4706128dce81f56b537"
    alias  dmdcr001
  }
  multipath {
    wwid   "3600e000000a0d4706128e2f733aefdf3"
    alias  dmvote001
  }
  multipath {
    wwid   "3600e000000a0d47061290971457581af"
    alias  dmdata001
  }
  multipath {
    wwid   "3600e000000a0d470612c378d77fbaca7"
    alias h3ctest
  }
}

devices {
  device {
    path_grouping_policy  group_by_prio
    prio alua  #failover
  }
}

11.2.修改规则文件（每个节点都修改）

[root@poc01:/root]# cat /etc/udev/rules.d/12-dm-permissions.rules 
#KERNEL=="dm-*", ENV{DM_UUID}=="mpath-200173800664e00b5", SYMLINK+="asmdisk/dmdcr01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
#KERNEL=="dm-*", ENV{DM_UUID}=="mpath-200173800664e00b6", SYMLINK+="asmdisk/dmvote01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
#KERNEL=="dm-*", ENV{DM_UUID}=="mpath-200173800664e00b3", SYMLINK+="asmdisk/dmdata01", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-3600e000000a0d4706128dce81f56b537", SYMLINK+="asmdisk/dmdcr001", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-3600e000000a0d4706128e2f733aefdf3", SYMLINK+="asmdisk/dmvote001", OWNER="dmdba", GROUP="dinstall", MODE="0660"
KERNEL=="dm-*", ENV{DM_UUID}=="mpath-3600e000000a0d47061290971457581af", SYMLINK+="asmdisk/dmdata001", OWNER="dmdba", GROUP="dinstall", MODE="0660"

11.3.使multipath和rules文件重新生效（每个节点都修改）

multipath -F && multipath -r
/sbin/udevadm control --reload-rules                 # 重新加载udev规则
/sbin/udevadm trigger --type=devices --action=change # 触发设备变化事件

11.4.启动数据库

DmCSSServiceCss start（每个节点都修改）
dmcssm /home/dmdba/dmdata/DMDSC/dmcssm.ini
ep startup GRP_ASM
ep startup GRP_DMDSC
show
上一篇：
不同场景dexp和dimp逻辑导出导入
评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服
logo
logo
logo
鄂Copyright © 达梦国产化应用创新实验室
达梦在线服务平台社区用户管理规范

鄂ICP备18017926号-1