0 20 * * * /home/oracle/admin/del_arch.sh >> /home/oracle/admin/del_arch.log 2>&1
[oracle@shanxi admin]$ cat /home/oracle/admin/del_arch.sh
#!/bin/bash
. /home/oracle/.bash_profile
reserve=5
max_seq=`sqlplus -s '/ as sysdba '<
select max(sequence#) from v\\$archived_log where name is not null;
exit;
EOF`
#echo ${max_seq}
echo "------------------------PROD-------------------------"
echo "----------------------Begin:`date`-----------------------"
hig_seq=`expr ${max_seq} - ${reserve} `
#echo $hig_seq
rman target sys/XXX@221.204.2XX.XXPROD <
delete noprompt expired archivelog all;
delete noprompt archivelog high sequence ${hig_seq};
exit;
EOF
echo -e "----------------------End:`date`-------------------------------\n"
echo -e "\n-----------------------ST---------------------------"
echo "----------------------Begin:`date`-----------------------"
rman target sys/XXX@221.204.XXX.XXX/ST <
delete noprompt expired archivelog all;
delete noprompt archivelog high sequence ${hig_seq};
exit;
EOF
echo -e "----------------------End:`date`-------------------------------\n"