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