一、需求
周日做全备份,周一到周六备份归档
保留14天
控制文件自动备份
二、实施过程
1)配置保留策略
RMAN> CONFIGURE RETENTION POLICY TO recovery window of 14 days;
新的 RMAN 配置参数:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
已成功存储新的 RMAN 配置参数
2)配置控制文件自动备份
3)脚本
主脚本rmanbackup.bat
@echo off
set v_date=%date:~11,4%
set v_sunday=星期日
if "%v_date%"=="%v_sunday%" (call E:\rmanbakscript\full_rmanbak.bat) else call E:\rmanbakscript\arch_rmanbak.bat
周日全备份脚本full_rmanbak.bat
rman target / nocatalog cmdfile=E:\rmanbakscript\full_bak.sql log=E:\rmanbakscript\full_bak_%date:~0,4%%date:~5,2%%date:~8,2%.log
full_bak.sql
run{
allocate channel c1 type disk;
backup database format 'E:\rmanbak\db_%d_%T_%s'
plus archivelog format 'E:\rmanbak\arch_%d_%T_%s' delete all input;
release channel c1;
}
delete noprompt obsolete;
周一到周六归档备份脚本arch_rmanbak.bat
rman target / nocatalog cmdfile=E:\rmanbakscript\arch_bak.sql log=E:\rmanbakscript\arch_bak_%date:~0,4%%date:~5,2%%date:~8,2%.log
arch_bak.sql
run{
backup archivelog all format 'E:\rmanbak\arch_%d_%T_%s' delete all input;
}
周日做全备份,周一到周六备份归档
保留14天
控制文件自动备份
二、实施过程
1)配置保留策略
RMAN> CONFIGURE RETENTION POLICY TO recovery window of 14 days;
新的 RMAN 配置参数:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
已成功存储新的 RMAN 配置参数
2)配置控制文件自动备份
3)脚本
主脚本rmanbackup.bat
@echo off
set v_date=%date:~11,4%
set v_sunday=星期日
if "%v_date%"=="%v_sunday%" (call E:\rmanbakscript\full_rmanbak.bat) else call E:\rmanbakscript\arch_rmanbak.bat
周日全备份脚本full_rmanbak.bat
rman target / nocatalog cmdfile=E:\rmanbakscript\full_bak.sql log=E:\rmanbakscript\full_bak_%date:~0,4%%date:~5,2%%date:~8,2%.log
full_bak.sql
run{
allocate channel c1 type disk;
backup database format 'E:\rmanbak\db_%d_%T_%s'
plus archivelog format 'E:\rmanbak\arch_%d_%T_%s' delete all input;
release channel c1;
}
delete noprompt obsolete;
周一到周六归档备份脚本arch_rmanbak.bat
rman target / nocatalog cmdfile=E:\rmanbakscript\arch_bak.sql log=E:\rmanbakscript\arch_bak_%date:~0,4%%date:~5,2%%date:~8,2%.log
arch_bak.sql
run{
backup archivelog all format 'E:\rmanbak\arch_%d_%T_%s' delete all input;
}
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26937943/viewspace-1606923/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26937943/viewspace-1606923/