> 文章列表 > oracle 11g 清理log日志

oracle 11g 清理log日志

oracle 11g 清理log日志

记录下2个方法清理清理log

1、 删除GI/RDBMS日志和trace文件,同时删除侦听日志的指令
/opt/purgeLogs -orcl 10 -lsnr -aud -dryrun

注: mos上下载purgeLogs 

2、在系统中直接删除-路径根据实际情况调整

[root@db1 ~]#  more /opt/del_log.sh
 find  /u01/app/11.2.0/grid_1/rdbms/audit/  -name "*.aud"  -mmin +0 | xargs rm -rf "*.aud"
 find  /u01/app/oracle/admin/orcl/adump/  -name "*.aud"  -mmin +0 | xargs rm -rf "*.aud"
 find  /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/  -name "*.trm"  -mmin +0 | xargs rm -rf "*.trm"
 find  /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/  -name "*.trc"  -mmin +0 | xargs rm -rf "*.trc"    
 find /u01/app/grid/diag/tnslsnr/db1/listener/alert/  -name "log_*.xml"  -mmin +0 | xargs rm -rf "log_*.xml"    
 find /u01/app/11.2.0/grid_1/log/diag/tnslsnr/db1/listener_scan1/alert/  -name "log_*.xml"  -mmin +0 | xargs rm -rf "log_*.xml"    
 cat /dev/null > /u01/app/grid/diag/tnslsnr/db1/listener/trace/listener.log
 cat /dev/null > /u01/app/11.2.0/grid_1/log/diag/tnslsnr/db1/listener_scan1/trace/listener_scan1.log

[root@db2 ~]# cat /opt/del_log.sh
 find  /u01/app/11.2.0/grid_1/rdbms/audit/  -name "*.aud"  -mmin +0 | xargs rm -rf "*.aud"
 find  /u01/app/oracle/admin/orcl/adump/  -name "*.aud"  -mmin +0 | xargs rm -rf "*.aud"
 find  /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/  -name "*.trm"  -mmin +0 | xargs rm -rf "*.trm"
 find  /u01/app/oracle/diag/rdbms/orcl/orcl2/trace/  -name "*.trc"  -mmin +0 | xargs rm -rf "*.trc"    
 find /u01/app/grid/diag/tnslsnr/db2/listener/alert/  -name "log_*.xml"  -mmin +0 | xargs rm -rf "log_*.xml"    
 find /u01/app/11.2.0/grid_1/log/diag/tnslsnr/db2/listener_scan1/alert/  -name "log_*.xml"  -mmin +0 | xargs rm -rf "log_*.xml"    
 cat /dev/null > /u01/app/grid/diag/tnslsnr/db2/listener/trace/listener.log
 cat /dev/null > /u01/app/11.2.0/grid_1/log/diag/tnslsnr/db2/listener_scan1/trace/listener_scan1.log