Linux 下crontab管理RMAN一周自动增量备份

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本
#!/bin/sh
export ORACLE_SID=orcl
rman log='/rmanbk/bakl0.log' append <connect target /;
run{
allocate channel cha1 type disk;
backup
incremental level 0
format '/rmanbk/incremental_level0_%u_%T'
tag backup_inc0
database;
release channel cha1;
}
EOF
exit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/sh
export ORACLE_SID=orcl
rman log='/rmanbk/bakl1.log' append <connect target /;
run{
allocate channel cha1 type disk;
backup
incremental level 1
format '/rmanbk/incremental_level1_%u_%T'
tag backup_inc1
database;
release channel cha1;
}
EOF
exit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本
#!/bin/sh
export ORACLE_SID=orcl
rman log='/rmanbk/bakl2.log' append <connect target /;
run{
allocate channel cha1 type disk;
backup
incremental level 2
format '/rmanbk/incremental_level2_%u_%T'
tag backup_inc2
database;
release channel cha1;
}
EOF
exit

在root身份下添加crontab任务计划
[root@oracle11gR2 ~]# crontab -e
59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份
59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份
59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份
59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份
59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份
59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份
59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份
保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划
Stopping crond: [ OK ]
Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读：