使用类型：系统负载集中在某那个时间段，如白天8小时，晚上基本很闲，所以在晚上就可以对数据进行备份
与之相对应的是全库备份：
http://blog.csdn.net/jacson_bai/article/details/39636915
1、env:
ip: 10.244.171.180/181
oracle database oracle 11.2.0.3
os rhel 5.5
backup toos:rman，shell,crontab
2、备份计划（增量计划）
sunday :execute level 0 incremental back
monday :execute level 2 incremental back
tuesday :execute level 2 incremental back
wednesday:execute level 1 incremental back
thursday :execute level 2 incremental back
friday :execute level 2 incremental back
saturday :execute level 2 incremental back
3、在node2规划backup 目录
--先创建保存备份脚本的目录
$mkdir -p /data/scripts/rman/
--创建备份数据的目录
$mkdir -p /data/rmandata/ --存放备份的数据目录
3、制定*.sql和rman_backup.sh脚本
--全备lv0级：
$cd /data/scripts/rman/
$vi backup_lv0.sql
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
backup incremental level 0 database
include current controlfile format '/data/rmandata/backup_%t_%s_%u_%t.lv0'
plus archivelog delete all input format '/data/arch/backup_%t_%s_%p_%t.arc';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
}
--增量备lv1级：
vi backup_lv1.sql
run{
allocate channel c1 type disk;
backup incremental level 1 database include current controlfile
format '/data/rmandata/backup_%t_%s_%p.lv1';
release channel c1;
}
--累计备lv2级：
$vi backup_lv2.sql
run{
allocate channel c1 type disk;
backup incremental level 2 database include current controlfile
format '/data/rmandata/backup_%t_%s_%p.lv2';
release channel c1;
}
4、编写shell脚本
--脚本要实现的功能：
1.正确判断星期
2.记录每个rman备份运行的时间
#!/bin/bash
source /home/oracle/.bash_profile
myweek=`date +%a`
mydate=`date +%y%m%d`
mydir=/data/
#monday
if [ $myweek == mon ]; then
rman target sys/oracle msglog=${mydir}/backup_${mydate}.log cmdfile=${mydir}/scripts/rman/backup_lv2.sql
fi
#tuesday
if [ $myweek == tue ]; then
rman target sys/oracle msglog=${mydir}/backup_${mydate}.log cmdfile=${mydir}/scripts/rman/backup_lv2.sql
fi
#wednesday
if [ $myweek == wed ]; then
rman target sys/oracle msglog=${mydir}/backup_${mydate}.log cmdfile=${mydir}/scripts/rman/backup_lv1.sql
fi
#thursday
if [ $myweek == thu ]; then
rman target sys/oracle msglog=${mydir}/backup_${mydate}.log cmdfile=${mydir}/scripts/rman/backup_lv2.sql
fi
#friday
if [ $myweek == fri ]; then
rman target sys/oracle msglog=${mydir}/backup_${mydate}.log cmdfile=${mydir}/scripts/rman/backup_lv2.sql
fi
#saturday
if [ $myweek == sat ]; then
rman target sys/oracle msglog=${mydir}/backup_${mydate}.log cmdfile=${mydir}/scripts/rman/backup_lv2.sql
fi
#sunday
if [ $myweek == sun ]; then
rman target sys/oracle msglog=${mydir}/backup_${mydate}.log cmdfile=${mydir}/scripts/rman/backup_lv0.sql
fi
5、crontab脚本指定
$crontab -e
30 20 * * * sh /data/script/rman/rman_backup.sh;