ITPub博客

首页 > 数据库 > Oracle > [oracle] 数据库日志清理脚本

[oracle] 数据库日志清理脚本

原创 Oracle 作者:匠人xin 时间:2021-01-20 18:43:03 0 删除 编辑

vi /root/db_clearlog.sh
chmod 700 /root/db_clearlog.sh
55 6 * * * /bin/sh db_clearlog.sh

cat db_clearlog.sh
##############################################################################################

#!/bin/bash
######################################
#warning!!!!!!!!!!!!!
#please adjust values below:
#cluster_name,inst_name
######################################
cluster_name=db
inst_name=db1
db_aud_path=/u01/app/oracle/admin/${cluster_name}/adump
db_diag_path=/u01/app/oracle/diag/rdbms/${cluster_name}/${inst_name}/trace/

######################################
#aud log clear
######################################

cd /tmp/;
find ${db_aud_path} -mtime +15 -print|xargs rm -rf "*.aud";
find /u01/app/12.2.0/grid/rdbms/audit/ -mtime +15 -print|xargs rm -rf "*.aud";

######################################
#diag log clear
######################################

cd /tmp/;
find ${db_diag_path} -mtime +15 -print|xargs rm -rf "*.trm";
find ${db_diag_path} -mtime +15 -print|xargs rm -rf "*.trc";
find /u01/app/grid/diag/crs/`hostname`/crs/trace -mtime +15 -print|xargs rm -rf "*.trc";
find /u01/app/grid/diag/crs/`hostname`/crs/trace -mtime +15 -print|xargs rm -rf "*.trm";

######################################
#listen log clear
######################################
cd /tmp/;
find /u01/app/grid/diag/tnslsnr/`hostname`/listener_scan1/alert -mtime +30 -print|xargs rm -rf "*.xml";
find /u01/app/grid/diag/tnslsnr/`hostname`/asmnet1lsnr_asm/alert -mtime +30 -print|xargs rm -rf "*.xml";
find /u01/app/grid/diag/tnslsnr/`hostname`/listener/alert -mtime +30 -print|xargs rm -rf "*.xml";


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/69993564/viewspace-2751528/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2021-01-19

  • 博文量
    33
  • 访问量
    39512