rman備份腳本
#! /bin/bash
su - oracle <<!
rman target /<<EOF
backup AS COMPRESSED BACKUPSET database
include current controlfile format'/orabak/db_%d_%T_%s'
plus archivelog format'/orabak/arch_%d_%T_%s' delete allinput;
delete noprompt obsolete;
exit;
EOF
第三個備份保存平台自動清理過期的備份文件
#! /bin/bash
for file in `ls /orabak`
do
if [[ ${file:0:2} == "db" ]];then
fdate=${file:10:8}
mydate=`date +%Y%m%d -d "-7 day"`
if [[ $fdate < $mydate ]];then
rm -rf $file;
else
echo $file;
fi
else
fdate=${file:12:8}
mydate=`date +%Y%m%d -d "-7 day"`
if [[ $fdate < $mydate ]];then
rm -rf $file;
else
echo $file;
fi
fi
done