删除archivelog的脚本和cron设置
g2cs6010:10g:dmbecif > pwd
/paic/bank/becif/data/otbecif/.cronjob
g2cs6010:10g:dmbecif > ls
alog_clean.sh crontab_becif
g2cs6010:10g:dmbecif > cat alog_clean.sh
ORACLE_SID=dmbecif
export ORACLE_SID
ORACLE_HOME=/paic/bank/becif/data/app/oracle/product/10.2.0
export ORACLE_HOME
NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
export NLS_DATE_FORMAT
/paic/bank/becif/data/app/oracle/product/10.2.0/bin/rman nocatalog target / <
run{
crosscheck archivelog all;
delete noprompt expired archivelog all;
DELETE noprompt ARCHIVELOG UNTIL TIME 'SYSDATE-3/24';
}
EOF
g2cs6010:10g:dmbecif > cat crontab_becif
30 * * * * /paic/bank/becif/data/otbecif/.cronjob/alog_clean.sh > /tmp/alog_clean.log 2>&1
g2cs6010:10g:dmbecif >chmod 755 alog_clean.sh
g2cs6010:10g:dmbecif > crontab crontab_becif
g2cs6010:10g:dmbecif > crontab -l
30 * * * * /paic/bank/becif/data/otbecif/.cronjob/alog_clean.sh > /tmp/alog_clean.log 2>&1
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/14385647/viewspace-748471/ ，如需转载，请注明出处，否则将追究法律责任。
