自动清理归档

[ccb@zbdb ~]$ crontab -l
00 05 * * * /home/ccb/clean_arch.sh>/dev/null 2>&1

[ccb@zbdb ~]$

[ccb@zbdb ~]$ cat /home/ccb/clean_arch.sh
#!/bin/bash


if [ -f ~/.bash_profile ]; then  
. ~/.bash_profile  
fi  
  
$ORACLE_HOME/bin/rman <<EOF 
connect target /  
run{  
crosscheck archivelog all;  
delete noprompt expired archivelog all;  
delete noprompt archivelog all completed before 'sysdate-3';  
}  
exit;
EOF
exit
[ccb@zbdb ~]$