oracle 各平台备份,Windows 平台Oracle RMAN 备份脚本

1批处理内容

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

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

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

2

Rman 命令内容

c:/backup/orabackup.txt 内容:https://www.cndba.cn/dave/article/1830https://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 的计划任务每天定时执行即可。https://www.cndba.cn/dave/article/1830

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

windows rman 备份 恢复