oracle归档日志过大导致磁盘满了，如何设置定时清理

#!/bin/bash   

 

if [ -f ~/.bash_profile ]; then 

. ~/.bash_profile  

fi  

   

ORACLE_SID=XXX2

ORACLE_HOME=XXX2



export  ORACLE_SID=$ORACLE_SID

$ORACLE_HOME/bin/rman log=/tmp/rman.log <<EOF     

connect target /  

run{  

crosscheck archivelog all;  

delete noprompt expired archivelog all;  

delete noprompt archivelog all completed before 'sysdate - 1';  

}  

exit;  

EOF



2、将脚本保存为auto_rman.sh，添加到计划任务<pre class="html " data-pbcklang="html" data-pbcktabsize="4">echo "* 23 * * * oracle /脚本所在目录/auto_rman.sh" >> /etc/crontab</pre><p>

</p></eof>