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 (责任编辑:IT) |