windows平台定期执行rman全备
脚本准备:
D:\backup\rman.bat
rman target sys/oracle cmdfile 'd:/backup/rman_backup.txt' log 'd:/backup/%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%".log'
D:\backup\rman_backup.txt
RUN {
delete noprompt obsolete ;
allocate channel c1 type disk;
backup database format 'd:/backup/full_%U' plus archivelog delete all input format 'd:/backup/arch_%U';
release channel c1;
}
exit
运行D:\backup\rman.bat批处理文件 可观察D:\backup目录下生成的备份集
制定任务:
cmd 下 执行taskschd.msc