windows rman備份指令碼

一、需求
 週日做全備份，週一到週六備份歸檔
 保留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;
}