1级增量备份
vi Incr1.sh
#Date 2014/4/6
export ORACLE_SID=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export PATH=$PATH:$ORACLE_HOME/bin:
rman target/ <
allocate channel c1 type disk;
backup incremental level 1 tag 'db1' format 'u01/app/oracle/Backup/db0_%d_%T_%s' database
include current controlfile;
delete nopromp obsolete;
release channel c1;
}
#end
chmod 755 BackupFull.sh
chmod 755 Incr1.sh
自动执行备份脚本
crontab –e
0 1 * * 0 /u01/app/oracle/Backup/BackupFull.sh
>>/u01/app/oracle/Backup/BackupFull.log
0 1 * * 3 /u01/app/oracle/Backup/BackupFull.sh
>>/u01/app/oracle/Backup/BackupFull.log
30 1 * * 1-2 /u01/app/oracle/Backup/Incr1.sh
>>/u01/app/oracle/Backup/Incr1.log
30 1 * * 4-6 /u01/app/oracle/Backup/Incr1.sh
>>/u01/app/oracle/Backup/Incr1.log
Ps:周日和周三凌晨1点执行0级全库备份,其余天数1:30执行1级增量备份
查看crontab
crontab –l
推荐阅读: