注册
达梦数据库系统日志清理脚本
技术分享/ 文章详情 /

达梦数据库系统日志清理脚本

醉酒方知浓 2025/09/05 15 0 0

功能描述:
删除超过两个月的日志文件
vi dmlog_del.sh

#!/bin/bash
DMDIR=`dirname $(ps -ef |grep -v grep |grep dmserver |awk '{print $8}' |awk -F "/" '{OFS="/"}{$NF="";print}')`
DMLOGDIR=${DMDIR}/log

SHOW_LOG() {
find ${DMLOGDIR} -type f -mtime +60 -name "dm_*_*.log" | while read -r file;
do  
    stat -c '%x %s %n' ${file} | awk '{  
        printf "File: %-40s Size_MB: %-5.2f Modified: %s.%s\n", $5,$4/1024/1024,$1,$2;  
    }'  
done
}

SHOW_LOG
echo ""
while true
do
read -p "#### Please Check Files Then deleted. (Y/N): " CHOOSE
if [ ${CHOOSE} == "Y" -o ${CHOOSE} == "y" ];
then
    find ${DMLOGDIR} -type f -mtime +60 -name "dm_*_*.log" -exec rm -f {} \;
    if [ $? -eq 0 ];then
        echo "#### Delete Successful."
        exit 0
    else
        echo "#### Delete Fail."
        exit 1
    fi
elif [ ${CHOOSE} == "N" -o ${CHOOSE} == "n" ];
then
    exit 0
else
    echo "#### Input Error !"
fi
done

示例:

[root@test ~]# sh dmlog_del.sh 
File: /dm8/log/dm_unknown_202407.log           Size_MB: 0.00  Modified: 2024-07-08.17:42:16.404999459
File: /dm8/log/dm_dmap_202407.log              Size_MB: 0.00  Modified: 2024-07-08.17:42:16.441999457
File: /dm8/log/dm_DMSERVER_202407.log          Size_MB: 6.00  Modified: 2024-07-08.17:42:16.479999455
File: /dm8/log/dm_BAKRES_202407.log            Size_MB: 0.04  Modified: 2024-07-09.00:34:18.954985078
File: /dm8/log/dm_dmrman_202407.log            Size_MB: 0.02  Modified: 2024-07-09.00:34:18.960985078
File: /dm8/log/dm_dmap_br_202407.log           Size_MB: 0.00  Modified: 2024-07-09.00:35:18.490982373

#### Please Check Files Then deleted. (Y/N): y
#### Delete Successful.
评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服