Windows 7下RMAN备份脚本
在执行脚本之前,先修改几个参数值:
1.DB参数:
修改控制文件的保存时间,从默认的7天改成14天
SQL> show parameter control
SQL> alter system set control_file_record_keep_time=14 scope=both;
2.RMAN参数:
开启控制文件的自动备份,开启之后在数据库备份或者数据文件(比如添加数据文件)有修改的时候会自动备份控制文件和spfile文件
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'E:\app\backup\%F';
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
3.备份脚本
rmanbackup.txt,保存至E:\app\backup\scripts\rmanbackup.txt,内容如下:
run {
allocate channel c1 type disk;
backup database format 'E:\app\backup\db_%U' plus archivelog delete all input format 'E:\app\backup\arch_%U';
release channel c1;
}
allocate channel for maintenance device type disk;
crosscheck backupset;
delete noprompt obsolete;
4.批处理文件
rmanbackup.bat,保存至 E:\app\backup\scripts\rmanbackup.bat,内容如下:
rman target / msglog=E:\app\backup\logs\rman_backup_%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%.log cmdfile=E:\app\backup\scripts\rmanbackup.txt
%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%,详见
http://blog.csdn.net/cyxlxp8411/article/details/7555541
5.执行计划
Control Panel\Administrative Tools\Task Scheduler,运行 E:\app\backup\scripts\rmanbackup.bat,设定日程安排中的时间。
备份完成后,在E:\app\backup\logs下会生成 rman_backup_20120511.log 这种格式的log文件
WIN7下计划任务,详见
http://blog.csdn.net/cyxlxp8411/article/details/7553634