windows+oracle环境的RMAN备份计划
备份计划分为三个类型:1、数据库完全备份2、数据库增量备份3、归档日志备份
具体执行计划
1、保存两个完整数据库备份
2、每周日凌晨4:30开始执行数据库完全备份
3、每周三凌晨4:30点开始执行数据库增量备份
4、每隔1小时执行一次归档日志备份[@more@]
修改RMAN配置
命令提示符模式下输入:
rman target /
进入RMAN操作界面,执行:
RMAN>CONFIGURE BACKUP OPTIMIZATION ON;
RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO ‘e:databasebakdbnameCTL%U’;
备份脚本
数据库完全备份:
文件路径e:databasebakdbfullbak.bat
内容:
rman cmdfile='e:databasebakdbfullbak.txt' log='e:databasebaklogFULL%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.log'
数据库增量备份:
文件路径e:databasebakdbinc1bak.bat
内容:
rman cmdfile='e:databasebakdbinc1bak.txt' log='e:databasebaklogINC1%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.log'
数据库归档备份
文件路径e:databasebakdbarcbak.bat
内容:
rman cmdfile='e:databasebakdbarcbak.txt' log='e:databasebaklogARC%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.log'
数据库完全备份脚本内容
文件路径e:databasebak
connect target /
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup incremental level 0 database format 'e:databasebakdbnamedbfull%U' plus archivelog format 'e:databasebakdbnamearch%U' delete all input;
release channel c1;
release channel c2;
crosscheck backup;
report obsolete;
delete obsolete;
}
数据库增量备份脚本内容
文件路径e:databasebakdbinc1bak.txt
connect target /
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup incremental level 1 database format 'e:databasebakdbnamedbinc1%U' plus archivelog format 'e:databasebakdbnamearch%U' delete all input;
release channel c1;
release channel c2;
}
数据库归档备份脚本内容
文件路径e:databasebakdbarcbak.txt
connect target /
run {
allocate channel c1 type disk;
allocate channel c2 type disk;
backup archivelog all format 'e:databasebakdbnamearch%U' delete all input;
release channel c1;
release channel c2;
}