达梦数据库--DSC报错处理

log file path: +DMLOG/DSC0_LOG01.log

log file path: +DMLOG/DSC0_LOG02.log

log file path: +DMLOG/DSC1_LOG01.log

log file path: +DMLOG/DSC1_LOG02.log

write to dir [+DMDATA/data/DSC].
create rlog file +DMLOG/DSC0_LOG02.log failed, code: -7013.
fail to init db.

症状：redo log创建失败
原因：dminit.ini配置文件中定义的log_size超过了+DMLOG最大大小，由于定义的是创建4个2048M大小的redo，创建时由于空间不足导致。

dsc1:/dm/dmdbms/dsc_config(db1)$lsblkNAMEMAJ:MINRMSIZEROTYPEMOUNTPOINTsda8:0020G0disk├─sda18:101G0part/boot└─sda28:2018G0part├─klas-root253:0016G0lvm/└─klas-swap253:102G0lvm[SWAP]sdb8:1601G0disksdc8:3201G0disksdd8:4804G0disksde8:64050G0disksdf8:80010G0disksr011:011024M0romdsc1:/dm/dmdbms/ds{c}_{c}onfig(db1)$ls -lrt /dev/dm
总用量 0
lrwxrwxrwx 1 dmdba dinstall 6 5月 12 13:38 asm-dmarch -> …/sdf
lrwxrwxrwx 1 dmdba dinstall 6 5月 12 13:40 asm-dmvote -> …/sdb
lrwxrwxrwx 1 dmdba dinstall 6 5月 12 13:40 asm-dmlog -> …/sdd
lrwxrwxrwx 1 dmdba dinstall 6 5月 12 13:40 asm-dmdata -> …/sde
lrwxrwxrwx 1 dmdba dinstall 6 5月 12 13:40 asm-dmdcr -> …/sdc

解决:
修改dminit.ini中的LOG_SIZE= 256（满足使用环境大小即可），重新初始化实例

5.2启动DB实例报错：

数据库日志：dm_dsc0.log
2023-05-12 18:19:20.129 [ERROR] database P0000014652 T0000000000000014652 Read rfil[‘+DMLOG/DSC1_LOG01.log’] from offset[923136] failed, code[-723]
2023-05-12 18:19:20.129 [ERROR] database P0000014652 T0000000000000014652 redo_rfil_grp_pwr_collect->rlog4_first_rpkg_seqno_get failed, code:-723
2023-05-12 18:19:20.129 [INFO] database P0000014652 T0000000000000014652 cur_fil:[+DMLOG/DSC1_LOG01.log], cur_free:[923136], l_next_seq:[4186], g_next_seq:[4186]
2023-05-12 18:19:20.129 [FATAL] database P0000014652 T0000000000000014652 redo_pwr_collect error, code = -723
2023-05-12 18:19:20.129 [INFO] database P0000014652 T0000000000000014652 hlog_sys_destroy set rlog_arr[0] from 0x7f54e95527e8 to NULL
2023-05-12 18:19:20.129 [INFO] database P0000014652 T0000000000000014652 hlog_sys_destroy set rlog_arr[1] from 0x7f54e99527e8 to NULL

原因：
1.共享磁盘绑定，出现问题
2.Redo日志损坏，损坏原因怀疑和手动误杀进程，并且顺序有误，先杀ASM或者CSS进程导致

解决：
原因1重新绑定共享磁盘，修改规则文件
原因2删除实例后，重新初始化实例

5.3 使用dmasmtool报错
创建磁盘组时报错：

解决：原因是重新初始化实例的时候，dd磁盘但没有初始化磁盘组导致,重新初始化磁盘组后，启动CSS和ASM服务后，再创建磁盘组
ASM>create asmdisk ‘/dev/dm/asm-dmdata’ ‘DATA0’
[TRACE]The ASM initialize asmdisk /dev/dm/asm-dmdata to name DMASMDATA0
Used time: 35.040(ms).
ASM>create asmdisk ‘/dev/dm/asm-dmlog’ ‘LOG0’
[TRACE]The ASM initialize asmdisk /dev/dm/asm-dmlog to name DMASMLOG0
Used time: 29.868(ms).
ASM>create asmdisk ‘/dev/dm/asm-dmarch’ ‘ARCH0’
[TRACE]The ASM initialize asmdisk /dev/dm/asm-dmarch to name DMASMARCH0
Used time: 32.419(ms).

5.4 启动DMCSS服务失败，磁盘checksum校验失败

[dmdba@DSC1 dsc_config]$ /dm/dmdbms/bin/dmcss DCR_INI=/dm/dmdbms/dsc_config/dmdcr.ini
DMCSS V8
Check vote disk group_id:[126] failed, expected id:[125].
dmcss startup failed:[CODE:-13217],error info:磁盘checksum校验失败

[dmdba@DSC1 dsc_config]$ dmasmcmd
DMASMCMD V8
ASM>listdisks ‘/dev/raw’
[/dev/raw/raw4]: Unused ASM disk, name:[DMASMDATA0], size:[46902M]
[/dev/raw/raw3]: Unused ASM disk, name:[DMASMLOG0], size:[4095M]
[/dev/raw/raw1]: Used ASM disk, name:[DMASMdcr], size:[100M], group_id:[126], disk_id:[0]
[/dev/raw/raw2]: Used ASM disk, name:[DMASMvote], size:[100M], group_id:[125], disk_id:[0]
Used time: 2.072(ms).

通过对比发现这里有错误：
Check vote disk group_id:[126] 在listdisks 命令看是dcr盘，而非vote disk。

因为刚开始搭建，所有直接使用init 命令重新初始化一下：
[dmdba@DSC1 dsc_config]$ /dm/dmdbms/bin/dmasmcmd
DMASMCMD V8
ASM>init dcrdisk ‘/dev/raw/raw1’ from ‘/dm/dmdbms/dsc_config/dmdcr_cfg.ini’ identified by ‘liu123456’
[TRACE]DG 126 alloc one extent for inodes, addr(disk_id, disk_auno, extent_no):(0,0,1).
[TRACE]DG 126 allocate 4 extents for file 0xfe000002.
[TRACE]DG 126 alloc 4 extents for 0xfe000002, addr(disk_id, disk_auno, extent_no):(0, 0, 2)->(0, 0, 5), need_init = 1.
Used time: 26.822(ms).
ASM>init votedisk ‘/dev/raw/raw2’ from ‘/dm/dmdbms/dsc_config/dmdcr_cfg.ini’
[TRACE]DG 125 alloc one extent for inodes, addr(disk_id, disk_auno, extent_no):(0,0,1).
[TRACE]DG 125 allocate 4 extents for file 0xfd000002.
[TRACE]DG 125 alloc 4 extents for 0xfd000002, addr(disk_id, disk_auno, extent_no):(0, 0, 2)->(0, 0, 5), need_init = 1.
Used time: 00:00:09.631.

后续重启成功！

达梦技术社区地址：https://eco.dameng.com