RMAN脚本.docx

1、RMAN脚本ORACLE 10G rman 备份脚本上一篇 / 下一篇 2010-01-23 21:44:55 / 个人分类：ORACLE #!/bin/bashback_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/bindate_w=date +%w;case $date_w in5) #指的是周五执行$rma

2、n_bin log $back_log/level0_date +%Y-%m-%d.log EOFconnect target $rman_name/$rman_pwrun allocate channel d1 type disk;allocate channel d2 type disk;backup full database format $back_path/date +%Y%m%d_full_%d_%s_%p_%u.baktag=full include current controlfile;sql alter system archive log current;backup

3、archivelog all format $back_path/date +%Y%m%d_archivelog_%d_%s_%p_%u.bak delete all input;release channel d2;release channel d1;crosscheck backup;delete noprompt expired backup;delete noprompt obsolete;exitEOF;#以上是完全备份7) #指的是周日执行$rman_bin log $back_log/level0_date +%Y-%m-%d.log EOFconnect catalog $r

4、man_log_name/$rman_log_passconnect target $rman_name/$rman_pwrun allocate channel d1 type disk;allocate channel d2 type disk;backup incremental level 0 database format $back_path/date +%Y%m%d_level0_%d_%s_%p_%u.baktag=level 0 include current controlfile;sql alter system archive log current;backup ar

5、chivelog all format $back_path/date +%Y%m%d_archivelog_%d_%s_%p_%u.bak delete all input;release channel d2;release channel d1;crosscheck backup;delete noprompt expired backup;delete noprompt obsolete;resync catalog;exitEOF;#以上是0级备份3) #指的是周三执行$rman_bin log $back_log/level1_date +%Y-%m-%d.log EOFconne

6、ct catalog $rman_log_name/$rman_log_passconnect target $rman_name/$rman_pwrun allocate channel d1 type disk;backup incremental 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;backup archivelog all format $back_path/date +%Y%m%

7、d_archivelog_%d_%s_%p_%u.bak delete all input;release channel d1;crosscheck backup;delete noprompt expired backup;delete noprompt obsolete;resync catalog;exit;EOF;#以上是1级备份1|2|4|5|6) #指的是周一，二，四，五，六执行$rman_bin log $back_log/level2_date +%Y-%m-%d.log rman catalog rmanuser1/rmanuser1 target system/syste

8、moradbRMANshow all;设置控制文件的自动备份和自动备份的目录（建议设置，备份目录自定）RMANCONFIGURE CONTROLFILE AUTOBACKUP ON;RMANCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO d:/backup/%F;RMANexit;按如上设置后，控制文件和spfile就会随着数据库备份自动备份到d:/backup下；建立脚本文件和批处理文件：脚本文件，如文件名为orabackup.rcv，具体内容如下：run allocate channel d1 type dis

9、k;allocate channel d2 type disk;backup incremental level 0 database format d:backuplevel0_%d_%s_%p_%u.bak;sql alter system archive log current;backup archivelog all format d:backuplog_%d_%s_%p_%u.bak delete all input;release channel d2;release channel d1;crosscheck backup;delete noprompt expired bac

10、kup;delete noprompt obsolete;resync catalog;exit批处理文件，如文件名为orabackup.bat，具体内容如下rman catalog rmanuser1/rmanuser1orada target system/systemoradb CMDFILE d：backuporabackup.rcv LOG d:backuporacl_%date将orabackup.bat和orabackup.rcv存放在同一目录下，执行orabackup.bat就可以调用orabackup.rcv备份数据库了，你可以再windows的计划任务里执行orabacku

11、p.bat就可以自动备份了；RMAN备份脚本 = 作者: hxhy()发表于: 2007.10.31 09:35分类: ORACLE学习资料 出处: - 注意:此文档是本人由网络资料整理而成 备份策略:星期天 0 级星期一,二,四,五六 2 级星期三 1 级-本地 mkdir /home/oracle/backupmkdir /home/oracle/backup/scriptmkdir /home/oracle/backup/logmkdir /home/oracle/backup/export-备份目的地mkdir /home/oracle/rman_backupcreate tables

12、pace rman_tbs datafile /oradata/luke/rman_tbs01.dbf size 1024M;create user rman identified by rman default tablespace rman_tbs temporary tablespace temp;grant connect,resource ,recovery_catalog_owner to rman;rman catalog rman/rmancreate catalog tablespace rman_tbs;connect target sys/lukewhxlukeregis

13、ter database;report schema;configure retention policy to redundancy 2;configure retention policy to recovery window of 7 days;-倒出RMAN用户数据脚本exp_rman.paruserid=rman/rman file=/home/oracle/backup/export/rman.dmplog=/home/oracle/backup/log/rman.log-倒出RMAN数据SHELL脚本exp_rman.sh#!/bin/bashcd $HOME. .bash_pr

14、ofilecd $HOME/backup/scriptexp parfile=exp_rman.par-零级备份RMAN脚本level0_backup.rcvconnect catalog rman/rmanconnect target sys/unumallunu2run allocate channel d1 type disk;allocate channel d2 type disk;backup incremental level 0 database format /home/oracle/rman_backup/level0_%d_%s_%p_%u.baktag=level 0

15、include current controlfile;sql alter system archive log current;backup archivelog all format /home/oracle/rman_backup/log_%d_%s_%p_%u.bak delete all input;release channel d2;release channel d1;crosscheck backup;delete noprompt expired backup;delete noprompt obsolete;resync catalog;-零级备份SHELL脚本的leve

16、l0_backup.sh#!/bin/bashcd $HOME. .bash_profilecd $HOME/backup/scriptrman cmdfile=level0_backup.rcv msglog=$HOME/backup/log/level0_backup.log. /home/oracle/backup/script/exp_rman.sh-一级差异增量备份RMAN脚本level1_backup.rcvconnect catalog rman/rmanconnect target sys/lukelukerun allocate channel d1 type disk;ba

17、ckup incremental level 1 format /home/oracle/rman_backup/level1_%d_%s_%p_%u.bak tag = level 1 database;sql alter system archive log current;backup archivelog all format /home/oracle/rman_backup/log_%d_%s_%p_%u.bak delete all input;release channel d1;crosscheck backup;delete noprompt expired backup;d

18、elete noprompt obsolete;resync catalog;-一级差异增量备份SHELL脚本level1_backup.sh#!/bin/bashcd $HOME. .bash_profilecd /home/oracle/backup/scriptrman cmdfile=level1_backup.rcv msglog=$HOME/backup/log/level1.log. /home/oracle/backup/script/exp_rman.sh-二级差异增量备份RMAN脚本level2_backup.rcvconnect catalog rman/rmanconn

19、ect target sys/lukelukerun allocate channel d1 type disk;backup incremental level 2 format /home/oracle/rman_backup/level2_%d_%s_%p_%u.bak tag = level 2 database;sql alter system archive log current;backup archivelog all format /home/oracle/rman_backup/log_%d_%s_%p_%u.bak delete all input;release ch

20、annel d1;crosscheck backup;delete noprompt expired backup;delete noprompt obsolete;resync catalog;-二级差异增量备份SHELL脚本level2_backup.sh#!/bin/bashcd $HOME. .bash_profilecd /home/oracle/backup/scriptrman cmdfile=level2_backup.rcv msglog=$HOME/backup/log/level2.log. /home/oracle/backup/script/exp_rman.sh提高

21、RMAN增量备份性能alter database enable block change tracking using file/u01/app/oracle/admin/devdb/bdump/luke.log;desc v$block_change_tracking;oracle rman备份脚本收集2，常用备份脚本：备份到磁盘：(如果是磁带，将DISK改成SBT_TAPE)0级备份脚本：RUN ALLOCATE CHANNEL ch00 TYPE DISK;ALLOCATE CHANNEL ch01 TYPE DISK;BACKUP INCREMENTAL LEVEL=0 SKIP IN

22、ACCESSIBLE TAG hot_db_bk_level0 FILESPERSET 5 FORMAT bk_%s_%p_%t DATABASE; sql alter system archive log current;RELEASE CHANNEL ch00;RELEASE CHANNEL ch01;ALLOCATE CHANNEL ch00 TYPE DISK;ALLOCATE CHANNEL ch01 TYPE DISK;BACKUP filesperset 20 FORMAT al_%s_%p_%t ARCHIVELOG ALL DELETE INPUT;RELEASE CHANN

23、EL ch00;RELEASE CHANNEL ch01;ALLOCATE CHANNEL ch00 TYPE DISK;BACKUP FORMAT cntrl_%s_%p_%t CURRENT CONTROLFILE;RELEASE CHANNEL ch00;1级差异增量备份：RUN ALLOCATE CHANNEL ch00 TYPE DISK;ALLOCATE CHANNEL ch01 TYPE DISK;BACKUP INCREMENTAL LEVEL=1 SKIP INACCESSIBLE TAG hot_db_bk_level0 FILESPERSET 5 FORMAT bk_%s

24、_%p_%t DATABASE; sql alter system archive log current;RELEASE CHANNEL ch00;RELEASE CHANNEL ch01;ALLOCATE CHANNEL ch00 TYPE DISK;ALLOCATE CHANNEL ch01 TYPE DISK;BACKUP filesperset 20 FORMAT al_%s_%p_%t ARCHIVELOG ALL DELETE INPUT;RELEASE CHANNEL ch00;RELEASE CHANNEL ch01;ALLOCATE CHANNEL ch00 TYPE DI

25、SK;BACKUP FORMAT cntrl_%s_%p_%t CURRENT CONTROLFILE;RELEASE CHANNEL ch00;1级累积增量备份脚本：RUN ALLOCATE CHANNEL ch00 TYPE DISK;ALLOCATE CHANNEL ch01 TYPE DISK;BACKUP INCREMENTAL LEVEL=1 CUMULATIVE SKIP INACCESSIBLE TAG hot_db_bk_level0 FILESPERSET 5 FORMAT bk_%s_%p_%t DATABASE; sql alter system archive log

26、 current;RELEASE CHANNEL ch00;RELEASE CHANNEL ch01;ALLOCATE CHANNEL ch00 TYPE DISK;ALLOCATE CHANNEL ch01 TYPE DISK;BACKUP filesperset 20 FORMAT al_%s_%p_%t ARCHIVELOG ALL DELETE INPUT;RELEASE CHANNEL ch00;RELEASE CHANNEL ch01;ALLOCATE CHANNEL ch00 TYPE DISK;BACKUP FORMAT cntrl_%s_%p_%t CURRENT CONTR

27、OLFILE;RELEASE CHANNEL ch00;恢复脚本：RUN ALLOCATE CHANNEL ch00 TYPE DISK;ALLOCATE CHANNEL ch01 TYPE DISK;RESTORE DATABASE;RECOVER DATABASE;RELEASE CHANNEL ch00;RELEASE CHANNEL ch01;Oracle Rman 备份脚本编辑一个文本, oracleoracle bak$vi full.baksource /.bash_profile /加上这个是为了当我们crontab自动调用时可以执行.rman target / eofrun

28、change archivelog all crosscheck; /标定控制文件中归档日志的状态.crosscheck backup; /交叉检测,系统删除了,但rman不知道.delete noprompt expired backup; /让ramn知道,在系统里已经被删除的.sql alter system archive log current / 归档当前日志backup archivelog all format /oraclebak/backup/ar_%u; /备份归档日志backup incremental level 0 database format /oraclebak/0_%u; /0级数据库备份(包括数据,控制,参数文件)allocate channel C1 type disk;allocate channel C2 type disk;delete noprompt obsolete; 删除除其他版本的备份.release channel C1;release channel C2;exi