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

vi /root/db_clearlog.sh chmod 700 /root/db_clearlog.sh 55 6 * * * /bin/sh db_clearlog.shcat 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";