定时删除归档（仅保留最近两天的）

[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博客 ” ，链接：http://blog.itpub.net/27042095/viewspace-750059/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27042095/viewspace-750059/