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

达梦数据库日志清理脚本

PYZ 2024/09/14 868 3 0
摘要

功能描述:

删除超过两个月的日志文件

#!/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.
评论
后发表回复

作者

文章

阅读量

获赞

扫一扫
联系客服