windows 逻辑备份&rman备份

一,逻辑备份步骤:
1，创建bat脚本,名称假定exp_scripts.bat,内容如下,:

@echo off
echo 删除n天前的备分文件和日志

forfiles /p "F:\exp_backup" /m *.dmp /d -7 /c "cmd /c del @path"
forfiles /p "F:\exp_backup" /m *.log /d -7 /c "cmd /c del @path"

echo 正在执行逻辑备份，请稍等……
D:\app\Administrator\product\11.2.0\dbhome_1\BIN\exp system/oracle@orclfile=F:/exp_backup/exp%date:~0,4%%date:~5,2%%date:~8,2%.dmp log=F:/exp_backup/exp%date:~0,4%%date:~5,2%%date:~8,2%.log full=y buffer=65535
echo 任务完成!

二  rman备份

1,创建bat文件，内容rman_bak.bat文件

rman target / nocatalog cmdfile 'D:/rman_bak/rman_bk_script.txt' log 'D:/rman_bak/%DATE:~0,4%%DATE:~5,2%%DATE:~8,2%".log'

2，创建备份脚本rman_bk_script

RUN {
 delete noprompt obsolete ;
 crosscheck archivelog all;
 delete noprompt expired archivelog all;
 crosscheck backup;
 delete noprompt expired backup;
 allocate channel c1 type disk;
 allocate channel c2 type disk;
 allocate channel c3 type disk;
 backup database format 'D:/rman_bak/db_%U' plus archivelog delete all input format 'd:/rman_bak/arch_%U';
 release channel c1;
 release channel c2;
 release channel c3;
 }

exit

这里要说下，上边的备份路径问题，优先级递减

备份语句中指定的format  > rman 中显现的configure channel device type disk format '/oracle/orclarch/%U_%d'的路径 > 闪回恢复区>$ORACLE_HOME/dbs 
 

3、运行tackschd.msc,进行定制job运行备份命令即可。