达梦shell备份脚本

#!/bin/bash
export LD_LIBRARY_PATH=“$LD_LIBRARY_PATH:/dm8/soft/bin”
export DM_HOME=“/dm8/soft”
export PATH=$DM_HOME/bin:$DM_HOME/tool:$PATH:$HOME/bin
export time=date +"%Y-%m-%d-%H-%M-%S"
export timeH=date +"%Y-%m-%d-%H-%M-%S"
disql sysdba/dmorcl123456:15236 -e "
backup database full to full_back backupset ‘/dm8/backup/SDB_DM_FULL_${time}’;"
if [ $? = 0 ];then
echo “${timeH} 备份成功” >>/dm8/backup/backup.log
else
echo “${timeH} 备份失败” >>/dm8/backup/backup.log
fi

disql sysdba/dmorcl123456:15236 -e <<EOF
set ECHO OFF LINESHOW OFF HEADING OFF timing off
spool 1.log
select SF_BAKSET_CHECK(‘DISK’,‘/dm8/backup/SDB_DM_FULL_${time}’);
spool off
exit 0
EOF

resut=more 1.log |awk '{print $1}'|grep 1|wc -l

if [ ${resut} == 1 ];then
echo “数据库备份集校验正常” >> /dm8/backup/backup.log
else
echo “数据库备份集校验异常” >> /dm8/backup/backup.log
fi

案例：
[dmdba@db01 backup]$ ls -l
总用量 8
-rwxr-xr-x 1 dmdba dinstall 909 6月 23 17:14 backup.sh
drwxr-xr-x 2 dmdba dinstall 135 6月 23 15:07 DB_DM_FULL_2022_06_23_15_07_44
-rwxr-xr-x 1 dmdba dinstall 223 6月 23 16:13 delete.sh

[dmdba@db01 backup]$ ls -l
总用量 16
-rw-r–r-- 1 dmdba dinstall 149 6月 23 17:19 1.log
-rw-r–r-- 1 dmdba dinstall 64 6月 23 17:19 backup.log
-rwxr-xr-x 1 dmdba dinstall 909 6月 23 17:14 backup.sh
drwxr-xr-x 2 dmdba dinstall 135 6月 23 15:07 DB_DM_FULL_2022_06_23_15_07_44
-rwxr-xr-x 1 dmdba dinstall 223 6月 23 16:13 delete.sh
drwxr-xr-x 2 dmdba dinstall 138 6月 23 17:19 SDB_DM_FULL_2022-06-23-17-19-37

[dmdba@db01 backup]$ cat backup.log
2022-06-23-17-19-37 备份成功
数据库备份集校验正常

达梦shell删除1天前备份集

案列：手动添加目录测试,删除1天前所有目录为SDB_DM_FULL开头
#!/bin/bash
del_date=date +%Y%m%d -d "1 days ago"
cd /dm8/backup/
for d in ls -d SDB_DM_FULL*|cut -b 13-22|awk '{print $1}';do
if [[ $d < $del_date || $d = $del_date ]];then
rm -rf /dm8/backup/SDB_DM_FULL_${d}*
fi
done

drwxr-xr-x 2 dmdba dinstall 6 6月 23 17:22 SDB_DM_FULL_2022-06-18-17-19-37
drwxr-xr-x 2 dmdba dinstall 6 6月 23 17:22 SDB_DM_FULL_2022-06-19-17-19-37
drwxr-xr-x 2 dmdba dinstall 6 6月 23 17:22 SDB_DM_FULL_2022-06-20-17-19-37
drwxr-xr-x 2 dmdba dinstall 6 6月 23 17:21 SDB_DM_FULL_2022-06-21-17-19-37
drwxr-xr-x 2 dmdba dinstall 6 6月 23 17:21 SDB_DM_FULL_2022-06-22-17-19-37
drwxr-xr-x 2 dmdba dinstall 138 6月 23 17:19 SDB_DM_FULL_2022-06-23-17-19-37

drwxr-xr-x 2 dmdba dinstall 6 6月 23 17:21 SDB_DM_FULL_2022-06-22-17-19-37
drwxr-xr-x 2 dmdba dinstall 138 6月 23 17:19 SDB_DM_FULL_2022-06-23-17-19-37

备注：生产环境尽量用find方式去删除目录，因为目录是每天生成的备份集