[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/，如需轉載，請註明出處，否則將追究法律責任。

定時刪除歸檔（僅保留最近兩天的）

相關文章