rman 自动备份脚本

最新推荐文章于 2021-06-01 17:31:38 发布

安伦_Alan

最新推荐文章于 2021-06-01 17:31:38 发布

阅读量1.5k

点赞数

分类专栏： oracle数据库

本文链接：https://blog.csdn.net/bff1022/article/details/17409899

版权

本文介绍了如何使用Oracle 10G的RMAN（ Recovery Manager）创建自动备份脚本，包括全量备份、差异增量备份（0级、1级、2级）以及备份策略。脚本根据一周中的不同日期执行不同级别的备份，并包含了详细的RMAN配置参数和备份日志管理。

摘要由CSDN通过智能技术生成

ORACLE 10G rman 备份脚本

#!/bin/bash

back_path="/10g/backup";

back_log="/10g/backup/log";

rman_name=“cisco”;

rman_pw="rman";

rman_log_name="rman";

rman_log_pass="cisco";

rman_sid=“zsh1”;

rman_bin=/opt/oracle/product/9.2.0.4/bin

date_w=`date+%w`;

case$date_w in

5)#指的是周五执行

$rman_binlog $back_log/level0_`date +%Y-%m-%d`.log <<EOF

connect target $rman_name/$rman_pw

run{

allocatechannel d1 type disk;

allocatechannel d2 type disk;

backupfull database format '$back_path/`date +%Y%m%d`_full_%d_%s_%p_%u.bak'

tag='full'include current controlfile;

sql 'alter system archive log current';

backuparchivelog all format '$back_path/`date +%Y%m%d`_archivelog_%d_%s_%p_%u.bak'delete all input;

releasechannel d2;

releasechannel d1;

}

crosscheckbackup;

deletenoprompt expired backup;

deletenoprompt obsolete;

exit

EOF

;;

#以上是完全备份

7) #指的是周日执行

$rman_binlog $back_log/level0_`date +%Y-%m-%d`.log <<EOF

connectcatalog $rman_log_name/$rman_log_pass

connecttarget $rman_name/$rman_pw

run{

allocatechannel d1 type disk;

allocatechannel d2 type disk;

backupincremental level 0 database format '$back_path/`date+%Y%m%d`_level0_%d_%s_%p_%u.bak'

tag='level0' include current controlfile;

sql'alter system archive log current';

backuparchivelog all format '$back_path/`date +%Y%m%d`_archivelog_%d_%s_%p_%u.bak'delete all input;

releasechannel d2;

releasechannel d1;

}

crosscheckbackup;

deletenoprompt expired backup;

deletenoprompt obsolete;

resynccatalog;

exit

EOF

;;

#以上是0级备份

3)#指的是周三执行

$rman_binlog $back_log/level1_`date +%Y-%m-%d`.log <<EOF

connectcatalog $rman_log_name/$rman_log_pass

connecttarget $rman_name/$rman_pw

run{

allocatechannel d1 type disk;

backupincremental level 1 format '$back_path/`date +%Y%m%d`_level1_%d_%s_%p_%u.bak'tag = 'level 1' database;

sql'alter system archive log current';

backuparchivelog all format '$back_path/`date +%Y%m%d`_archivelog_%d_%s_%p_%u.bak'delete all input;

releasechannel d1;

}

crosscheckbackup;

deletenoprompt expired backup;

deletenoprompt obsolete;

resynccatalog;

exit;

EOF

;;

#以上是1级备份

1|2|4|5|6) #指的是周一，二，四，五，六执行

$rman_binlog $back_log/level2_`date +%Y-%m-%d`.log <<EOF

connectcatalog $rman_log_name/$rman_log_pass

connecttarget $rman_name/$rman_pw

利用LINUX的crintab 进行执行！！

RMAN备份脚本及自动批处理(windows)

2010-02-09 00:05

RMAN备份脚本及自动批处理(windows)

接上章RMAN备份前工作：
C:\Documents and Settings\Administrator>rman catalog rmanuser1/rmanuser1 target
system/system@oradb
RMAN>show all;
设置控制文件的自动备份和自动备份的目录（建议设置，备份目录自定）
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP ON;
RMAN>CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'd:/backup/%F';
RMAN>exit;
按如上设置后，控制文件和spfile就会随着数据库备份自动备份到d:/backup下；

建立脚本文件和批处理文件：
脚本文件，如文件名为orabackup.rcv，具体内容如下：
run {
allocate channel d1 type disk;
allocate channel d2 type disk;
backup incremental level 0 database format 'd:\back