oracle 11g 清理log日志

最新推荐文章于 2024-07-08 17:30:40 发布

bestsun999

最新推荐文章于 2024-07-08 17:30:40 发布

阅读量1.6k

点赞数

文章标签： oracle 数据库

本文链接：https://blog.csdn.net/kevinyu998/article/details/130293789

版权

记录下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