`

写一个脚本来移动RMAN备件文件的位置。

 
阅读更多

做DUPLICATE总是报错,因为时间点找不好。想多保留一天的备份但一个文件系统放不下两天的备份文件。写一个脚本来完成这个需求。脚本如下:

$ more /global/oracle/orahome1/local/scripts/mv_backups_to_new.sh
# /usr/bin/ksh
# Modified by henry on July 10,2008
# Move older backup files to new place
cd /global/oracle/oradump1/ARSPRD/backup/
/usr/bin/find . -type f -mtime +2 | sed 's/^..//g' >/global/oracle/orahome1/local/scripts/files_to_mv
#exec 4< /global/oracle/orahome1/local/scripts/files_to_rm
#while read -u4 rec
#do
#if (( ${#rec} == 0 )); then
# continue
# fi
#cd /global/oracle/oradump1/ARSPRD/backup/
#rm -f $(print $rec)
#cd /global/oracle/oradump2/ARSPRD/backup
#rm -f $(print $rec)
#done

exec 4< /global/oracle/orahome1/local/scripts/files_to_mv
#
#mv each file listed in the files_to_mv file
#
while read -u4 rec
do
## exit if not records in oratab
if (( ${#rec} == 0 )); then
continue
fi
## mv it

#mv and ln it.
cd /global/oracle/oradump1/ARSPRD/backup/
mv $(print $rec) /global/oracle/oradump2/ARSPRD/backup
# echo "cat /global/oracle/orahome1/local/scripts/files_to_mv|sed 's///global//oracle3//ORADUMP//ARSPRD//backup////global//oracle/
/oradump2//ARSPRD//backup/'|ln -s /global/oracle/oradump2/ARSPRD/backup/$(print $rec)"

cat /global/oracle/orahome1/local/scripts/files_to_mv|ln -s /global/oracle/oradump2/ARSPRD/backup/$(print $rec)
# ln -s sed 's//$(print /$rec)/global//oracle//oradump2//ARSPRD//backup/' $(print $rec)
cp /global/oracle/orahome1/local/scripts/files_to_mv /global/oracle/orahome1/local/scripts/files_to_rm
done

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics