ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 配置计划任务定期清理数据库trc文件

配置计划任务定期清理数据库trc文件

原创 Linux操作系统 作者:winnzheng 时间:2023-09-20 15:38:32 0 删除 编辑


#add trc log clear

0 14 * * * find /u01/app/oracle/admin/MESRPT/adump -mtime +1 -name "*.aud"|xargs rm -fr "*.aud"

5 14 * * * find /u01/app/oracle/diag/rdbms/rptdb/RPTDB1/trace -mtime +1 -name "*.trm"|xargs rm -fr "*.trm"

10 14 * * * find /u01/app/oracle/diag/rdbms/rptdb/RPTDB1/trace -mtime +1 -name "*.trc"|xargs rm -fr "*.trc"

15 14 * * * find /u01/app/11.2.0/grid/log/diag/tnslsnr/zhrptdb01/listener_scan1/alert -mtime +1 -name "*.xml"|xargs rm -fr "*.xml"



#add trc log clear

0 14 * * * find /u01/app/oracle/admin/MESRPT/adump -mtime +1 -name "*.aud"|xargs rm -fr "*.aud"

5 14 * * * find /u01/app/oracle/diag/rdbms/rptdb/RPTDB2/trace -mtime +1 -name "*.trm"|xargs rm -fr "*.trm"

10 14 * * * find /u01/app/oracle/diag/rdbms/rptdb/RPTDB2/trace -mtime +1 -name "*.trc"|xargs rm -fr "*.trc"

15 14 * * * find /u01/app/11.2.0/grid/log/diag/tnslsnr/zhrptdb02/listener_scan1/alert -mtime +1 -name "*.xml"|xargs rm -fr "*.xml"



#auto delete trc&trm

0 15 * * * find  /u01/app/oracle/diag/rdbms/fdc/fdc2/trace  -mtime +1 -name "*.trc" -exec rm -rf {} \;

3 15 * * * find  /u01/app/oracle/diag/rdbms/fdc/fdc2/trace  -mtime +1 -name "*.trm" -exec rm -rf {} \;

5 15 * * * find  /u01/app/oracle/diag/rdbms/eda/eda2/trace  -mtime +1 -name "*.trc" -exec rm -rf {} \;

7 15 * * * find  /u01/app/oracle/diag/rdbms/eda/eda2/trace  -mtime +1 -name "*.trm" -exec rm -rf {} \;

8 15 * * * find  /u01/app/oracle/diag/rdbms/apc/apc2/trace  -mtime +1 -name "*.trc" -exec rm -rf {} \;

9 15 * * * find  /u01/app/oracle/diag/rdbms/apc/apc2/trace  -mtime +1 -name "*.trm" -exec rm -rf {} \;

10 15 * * * find  /u01/app/grid/diag/tnslsnr/zhrddb02/listener/alert/  -mtime +1 -name "*.xml" -exec rm -rf {} \;

11 15 * * * find  /u01/app/grid/diag/tnslsnr/zhrddb02/listener_scan1/alert/  -mtime +1 -name "*.xml" -exec rm -rf {} \;

12 15 * * * find  /u01/app/grid/diag/tnslsnr/zhrddb02/asmnet1lsnr_asm/alert/  -mtime +5 -name "*.xml" -exec rm -rf {} \;


0 14 * * * find /u01/app/grid/diag/asm/+asm/+ASM2/trace -mtime +2 -name "+ASM2*"|xargs rm -fr "+ASM2*"

5 14 * * * find /u01/app/grid/diag/crs/zhrddb02/crs/trace -mtime +2 -name "*.trm"|xargs rm -fr "*.trm"

10 14 * * * find /u01/app/grid/diag/crs/zhrddb02/crs/trace -mtime +2 -name "*.trc"|xargs rm -fr "*.trc"

15 14 * * * find /u01/app/grid/admin/_mgmtdb/adump -mtime +2 -name "*.aud"|xargs rm -fr "*.aud"

20 14 * * * find /u01/app/grid/diag/rdbms/_mgmtdb/-MGMTDB/incident -mtime +2 -name "incdir*"|xargs rm -fr "incdir*"


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

下一篇: 关闭sql tunning
请登录后发表评论 登录
全部评论
Happy --开心 Appreciation --心怀感恩 Passion --激情四溢 Performance --出类拔萃 Young --充满活力

注册时间:2023-09-04

  • 博文量
    30
  • 访问量
    24392