crontab 設定

> crontab -l
30 * * * *  /hq/toa/data/ottoa/.cronjob/alog_clean.sh > /tmp/alog_clean_bstoa1.log 2>&1
> more /paic/hq/toa/data/ottoa/.cronjob/alog_clean.sh
ORACLE_SID=yltoa
export ORACLE_SID
ORACLE_HOME=/hq/toa/data/app/oracle/product/10.2.0
export ORACLE_HOME
NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
export NLS_DATE_FORMAT
/hq/toa/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-1/8';
}
EOF

 

==================

DELETE noprompt ARCHIVELOG UNTIL TIME 'SYSDATE-1/8';   刪除3個小時前的日誌.