http://www.cndba.cn/dave/article/1830

 1       批处理内容

rmanBackup.bat 脚本内容：

set ORACLE_SID=www.cndba.cn
C:/app/Administrator/product/11.2.0/dbhome_1/BIN/rman target /  cmdfile=C:/backup/backup.rcv log=C:/backup/backup_%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%.log  

2       Rman 命令内容

c:/backup/orabackup.txt 内容:http://www.cndba.cn/dave/article/1830

sql 'alter session set nls_date_format="yyyy-mm-dd hh24:mi:ss"';
run {  
configure controlfile autobackup on;
configure device type disk parallelism 4;
configure retention policy to redundancy 2;
backup database format 'C:/backup/www.cndba.cn_%d_%T_%s_%p';  
sql 'alter system archive log current';  
backup archivelog all delete input format 'C:/backup/www.cndba.cn_arc_%d_%T_%s_%p';  
backup current controlfile tag='bak_ctlfile' format='C:/backup/www.cndba.cn_ctl_file_%d_%T_%s_%p';
backup spfile tag='spfile' format='C:/backup/spfile_%d_%T_%s_%p';
}  
report obsolete; 
delete noprompt obsolete; 
crosscheck backup; 
delete noprompt expired backup;
list backup summary; 
exit;

3       添加windows 批处理任务

将rmanBackup.bat 命令添加到windows 的计划任务每天定时执行即可。

版权声明：本文为博主原创文章，未经博主允许不得转载。

windows rman 备份 恢复