ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 定时删除归档(仅保留最近两天的)

定时删除归档(仅保留最近两天的)

原创 Linux操作系统 作者:perfychi 时间:2012-11-27 14:05:16 0 删除 编辑
[oracle@shanxi ORCL]$ crontab -l
0 4  * * *   /home/oracle/admin/del_arch.sh >>  /home/oracle/oracle_log/del_arch.log 2>&1
0 0  * * *   /home/oracle/admin/truncate_alert.sh >/dev/null 2>&1
5 */2  * * *   /home/oracle/admin/del_udump.sh  > /dev/null 2>&1
10 */2 * * *  /home/oracle/admin/del_bdump2.sh > /dev/null 2>&1


[oracle@shanxi ORCL]$ cat /home/oracle/admin/del_arch.sh 
#!/bin/bash
# Filename: del_arch.sh
# Date: 2012-10-31
# Version: 1.0
# Author : chi
# Desc: clean up the redundancy archivelog but keep the last 2 days

. /home/oracle/.bash_profile
# if database is open , the variable flag will not be empty 
flag=`ps -ef | grep ora_ | grep -v 'grep'`

if [ -z  "$flag" ] ; then
        exit
fi


now=`date "+%Y-%m-%d %H:%M:%S"`
echo "----------------------------$now-------------------------------"
keep=2
rman target / <
delete noprompt archivelog until time 'sysdate-$keep';
exit;
EOF

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

请登录后发表评论 登录
全部评论