oracle数据库备份脚本

#!/bin/sh
source /home/oracle/.bash_profile
rman target sys/oracle msglog='/tmp/full.log' append <<EOF
run {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
allocate channel ch3 device type disk;
allocate channel ch4 device type disk;
allocate channel ch5 device type disk;
allocate channel ch6 device type disk;
allocate channel ch7 device type disk;
allocate channel ch8 device type disk;
delete noprompt obsolete;
crosscheck archivelog all;
delete noprompt expired archivelog all;
crosscheck backup;
delete noprompt expired backup;
backup database format '/data/backup/full_%d_%T_%s_%p';
backup current controlfile format '/data/backup/control_%d_%T_%s_%p';
release channel ch1;
release channel ch2;
release channel ch3;
release channel ch4;
release channel ch5;
release channel ch6;
release channel ch7;
release channel ch8;
}
EOF

cd /data/backup/
find . -name "full_ORCL_*" -mtime +1 -exec rm -rf {} \;
find . -name "control_ORCL_*" -mtime +1 -exec rm -rf {} \