Oracle Rman-备份脚本

 oracle@dbservera ~]$ crontab -l
0 0 * * * /u01/rmanbak/rmanbak.sh > /u01/rmanbak/rmanbak.log 2>&1
[oracle@dbservera ~]$ cat /u01/rmanbak/rmanbak.sh
#!/bin/bash


. ~/.bash_profile


echo -------------------------start-----------------------;date
rman target/<<EOF
backup as compressed backupset database include current controlfile format '/u01/rman/rmanbak/full_%U.bak';
delete noprompt obsolete;
delete noprompt force archivelog all completed before 'sysdate-7';
exit;
EOF
echo -------------------------end-----------------------;date

注意：EOF后面不要有空格，不然会有警告

总之一共三步，首先创建备份脚本，之后创建备份的目标目录（要注意目录权限），最后通过crontab -e -u oracle来编辑oracle的执行计划。