Oracle 11g rman 备份脚本

一、创建rman备份路径

 

cd /u01/

mkdir rmanbak

chown oracle:oinstall rmanbak

 

二、创建rman备份脚本

 

su - oracle

vi /u01/rmanbak/rmanbak.sh

#!/bin/bash
. ~/.bash_profile
echo -------------------------start-----------------------;date
rman target /<<EOF
backup as compressed backupset database include current controlfile format '/u01/rmanbak/full_%U.bak';
delete noprompt obsolete;
#自动删除七天前的归档日志
delete noprompt force archivelog all completed before 'sysdate-7';
exit;
EOF
echo -------------------------end-----------------------;date

 

三、增加定时计划

 

crontab -e

0 1 * * * /u01/rmanbak/rmanbak.sh >rmanbak.log 2>&1