首页 > 数据库 > Oracle > adrci -age后面的参数单位是分钟
echo "INFO: adrci purge started at `date`"
AGE1DAY=1440
AGE7DAYS=10080
AGE10DAYS=14400
AGE15DAYS=21600
AGE30DAYS=43200
PURGETARGET=$AGE7DAYS
RETENTION=$DDAYS
for f in $( adrci exec="show homes" | grep -v "ADR Homes:" )
do
echo "Purging ${f} older than $DDAYS days:"
adrci
exec="set home $f;
purge -age
$PURGETARGET"
done
echo "INFO: adrci purge finished at `date`"
if [ $? != 0 ];then
# echo "failed"
continue
fi
fi
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/14377/viewspace-2374977/ ,如需转载,请注明出处,否则将追究法律责任。