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