rman删除备份集 笔记

《rman删除备份集 笔记》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、RMAN删除备份集笔记1自动删除删除归档日志deleteinput;reportobsolete命令报告过期备份RMAN>reportobsolete;deleteobsolete删除所有以前的备份（包括数据文件、归档、控制文件）RMAN>deleteobsolete;RMAN>crosscheckarchivelogall;2手动删除手工删除备份集，之后用如下命令同步RMAN>crosscheckbackup;RMAN>deleteexpiredbackup;编写的oraclerman脚本#!/bin/bash#Usage:#backup_rman_v1.1

2、.sh[all

3、repeat

4、sync]#all:listallbackupfile.#repeat:repeatlevel-1incrementbackup.#sync:syncbackupfiletotargetdatabase.exportORACLE_HOME=/u01/app/11.2.0exportORACLE_SID=healthexportLD_LIBRARY_PATH=${ORACLE_HOME}/lib:${ORACLE_HOME}/ctx/libexportPATH=$PATH:${ORACLE_HOME}/bin#exportNLS_L

5、ANG="American_america.zhs16gbk"exportNLS_LANG="American_america.al32utf8"exportORACLE_OWNER=oracleexportbackup_dir=/sda/backupexportlog=/sda/backup/logrsync_dir=$backup_dir#syncdircontrolfile_dir=$backup_dir/controlfileusername=oracle#targetOS,oracleuserpassword=go2north#targetoracl

6、euserpasswordtarget_host=61.158.131.94today_backup=`date+'%Y-%m-%d'`mail_to_admin="zhaorupeng@yeah.net"########setdisplaycolor#########white=$（echo-e"e[39;40m"）green=$（echo-e"e[36;40m"）red=$（echo-e"e[31;40m"）purple=$（echo-e"e[35;40m"）yellow=$（echo-e"e[33;40m"）blue=$（echo-e"e[3

7、4;40m"）########colorsetend#############databackupstatus.#0:backupfailed.#2:default#9:successbackup_status=2#databasestatuscheck,Ifit'snotturnon,thevalueis0,orelse1ora_stat=`ps-ef

8、grep-i'ora_smon_*'

9、grep-vgrep

10、wc-l`#databasemodecheck,Ifit'sarchivemode,thatvalueis1,orelse0;arch=`ps-ef

11、

12、grep-i'ora_arc_*'

13、grep-vgrep

14、wc-l`functionopen_database（）{if["$ora_stat"=0];thencat《EOF

15、$ORACLE_HOME/bin/sqlplus'/assysdba'shutdownimmediate;startup;quit;EOFbackup_status=2if["$?"=1];thenecho"databaseunablestrtup!"backup_status=0exit1fifi}functionopen_archive_mode（）{if["$arch"=0];t

16、hen#ifarch=1,nothing,becauseitwasalreadyonarchivemodeecho"****************openarchivemode*************"cat《EOF

17、$ORACLE_HOME/bin/sqlplus'/assysdba'shutdownimmediate;startupmount;alterdatabasearchivelog;alterdatabaseopen;quit;EOFfi}functionreturn_initaliztion_mode（）{if["$arch"=0-a"$ba

18、ckup_status">0];the