rman备份脚本

## 配置保留策略（3个副本）
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
-- CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 days;

## 脚本具体内容
bakdir=fullbak_`date +%Y%m%d-%H%M%S`
mkdir /databak/$bakdir
source /home/oracle/.bash_profile
rman target / << EOF >> /databak/$bakdir.log
crosscheck backup;
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete noprompt expired backup;
delete noprompt obsolete;
delete noprompt archivelog until time 'sysdate-31';
backup as compressed backupset database format '/databak/${bakdir}/%d_Full_%T_%u_%p_%c'
plus archivelog format '/databak/${bakdir}/%d_Arch_%T_%u_%p_%c';
exit;
EOF

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29843794/viewspace-1270301/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29843794/viewspace-1270301/