windows 下RMAN备份脚本实例

jixuji

环境：windows server 2008   +  oracle 10g R2 32bit
例一：

[Shell] 纯文本查看 复制代码

完全备份：
1、创建文件 full_backup.sql ，内容如下

run{
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
allocate channel d1 type disk;   //开启多个通道
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
backup current controlfile format 'h:\rman_backup\ctl_%d_%s_%p_%u.bak';   //备份当前控制文件，并指定备份文件路径
backup as compressed backupset full database format 'h:\rman_backup\full_%d_%s_%p_%u.bak'; //全库备份，并指定备份文件存放路径
sql 'alter system archive log current';   //切换归档日志
backup archivelog all format 'h:\rman_backup\log_%d_%s_%p_%u.bak' delete all input;  //备份所有归档日志
release channel d1; //释放通道
release channel d2;
release channel d3;
release channel d4;
report obsolete;   //报告过期或无效的备份
crosscheck backup;  //交叉检查备份
delete noprompt expired backup;  //删除过期的备份，不需交互确认
delete noprompt obsolete; //删除无效的备份，不需交互确认
}
2、新建bat文件full_backup.bat，内容如下：
1
rman target / cmdfile='h:\rman_backup\script\full_backup.sql'log='h:\rman_backup\script\log\full_backup.log' append

3、把上述创建的两个文件存放在相对应的路径，然后在系统新建计划任务执行full_backup.bat文件即可。
例二：增量备份，备份计划如下图所示：

[Shell] 纯文本查看 复制代码

1、创建增量0级备份文件level0_backup.sql，内容如下：

run{
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
allocate channel d1 type disk;
allocate channel d2 type disk;
backup incremental level=0 database include current controlfile format'h:\rman_backup\level0_%d_%s_%p_%u.bak' plus archivelog format'h:\rman_backup\log_%d_%s_%p_%u.bak';
release channel d2;
release channel d1;
report obsolete;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
delete noprompt ARCHIVELOG until time 'SYSDATE-30';  //删除30天前的归档日志
}
2、创建增量0级备份bat文件level0_backup.bat,内容如下：
1
rman target / cmdfile='h:\rman_backup\script\level0_backup.sql'log='h:\rman_backup\script\log\level0_backup.log' append

3、创建增量1级备份文件level1_backup.sql，内容如下：

run{
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
allocate channel d1 type disk;
allocate channel d2 type disk;
backup incremental level=1 database include current controlfile format'h:\rman_backup\level1_%d_%s_%p_%u.bak' plus archivelog format'h:\rman_backup\log_%d_%s_%p_%u.bak';
release channel d2;
release channel d1;
}
4、创建增量1级备份bat文件level1_backup.bat,内容如下：
1
rman target / cmdfile='h:\rman_backup\script\level1_backup.sql'log='h:\rman_backup\script\log\level1_backup.log' append


5、创建增量1c级备份文件level1c_backup.sql，内容如下：

run{
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 30 DAYS;
allocate channel d1 type disk;
allocate channel d2 type disk;
backup incremental level=1 cumulative database include current controlfile format'h:\rman_backup\level1c_%d_%s_%p_%u.bak' plus archivelog format'h:\rman_backup\log_%d_%s_%p_%u.bak';
release channel d1;
release channel d2;
report obsolete;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
delete noprompt ARCHIVELOG until time 'SYSDATE-30';
}
6、创建增量1级备份bat文件level1c_backup.bat,内容如下：
1
rman target / cmdfile='h:\rman_backup\script\level1c_backup.sql'log='h:\rman_backup\script\log\level1c_backup.log' append

按上图计划在系统中建立相对应的计划任务执行上述bat文件即可。

zhk2369

男人在结婚前觉得适合自己的女人很少，结婚后觉得适合自己的女人很多。

zidong

有事秘书干，没事干秘书!

cjcmay

比我有才的都没我帅，比我帅的都没我有才！

chenjiali

路过，学习下

榕叶

人生不能像做菜、把所有的料都准备好才下锅!

515439429

男人偷腥时的智商仅次于爱因斯坦!