1. Background notes
The company tape Library is broken. Where does Oracle's backup go every day?
2. Re-planning the backup method
Original Backup method
650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M00/8F/EC/wKiom1jtyzGCsWHOAADObsChJ9A142.png "title=" Backupbefore.png "alt=" Wkiom1jtyzgcswhoaadobschj9a142.png "/>
Current Backup method
650) this.width=650; "src=" Https://s2.51cto.com/wyfs02/M00/8F/EA/wKioL1jtyz2iGxQKAAC6mNObGAg441.png "title=" Backupafter.png "alt=" Wkiol1jtyz2igxqkaac6mnobgag441.png "/>
3. Backup script sharing
Small White wrote a backup of the shell script, share it out
#!/bin/bash# tar oraclebackup file # check rman is run?# When I do an rman backup, I create an rman log, so this log can tell if my Rman executed the filename= "/mnt/rman/log/rmanbackup_ ' date +%y%m%d '. Log" comparedata= "Recovery manager complete." if [ -e $filename ];then echo "' Date ' RMAN is Run " &>> /OPS/tarlogelse echo " ' Date ' RMAN is Not run,please check " &>> /ops/tarlog exit 1fi# check rman is ok? #通过判断我的日志最后结果, to determine if the RMAN backup is successful, if not, I do not need to back up Data= ' tail -1 $ FileName ' if [ ' $data == ' $comparedata ' ];then echo ' Date ' rman backup sucess ' &>> /ops/tarlogelse echo "' Date ' rman backup fail" &>> /ops/tarlog exit 2fi# tar backupfile and move to backupserver# Compress the backup set of the day back up and move to the corresponding NFS-provided folder, my 300GB backup compressed as long as 30 g, compression ratio is still very amazing/usr/bin/find /mnt/rman -name ' Oradb1* ' > /OPS/tarlistfor i in '/bin/cat /ops/tarlist ';d o echo ' Date ' tar $i start &>> /OPS/tarlog tar -zcvf $i .tar.gz $i &>> /ops/tarlog doneif [ $? -eq 0 ];then echo ' Date ' tar end success &>> /OPS/tarlog mv /mnt/rman/*.tar.gz /oraclebackup if [ $? -eq 0 ];then echo "' Date ' move to oraclebackup end success" &>> / Ops/tarlog else echo "' Date ' move to oraclebackup fail" &>> /OPS/tarlog fielse echo "' Date ' tar fail " &>> /ops/tarlogfi
This article is from the "Open World" blog, so be sure to keep this source http://voidyao000.blog.51cto.com/12458042/1915210
Compression and offsite Backup of Oracle Rman backup sets through shell scripting