当前位置:操作系统 > Unix/Linux >>

rman备份脚本

rman备份脚本
 
rman shell脚本编辑
先在rman里面测试,看是否正常备份,在进行判断语句测试。
备份脚本
sh命令
rmanl0.sh
rman target / msglog=/oracle/ora10g/rmanbak/bakl0.log cmdfile=/oracle/ora10g/rmanbak/script/rman_bak_l0.sql
rmanl1.sh
rman target / msglog=/oracle/ora10g/rmanbak/bakl1.log cmdfile=/oracle/ora10g/rmanbak/script/rman_bak_l1.sql
rmanl2.sh
rman target / msglog=/oracle/ora10g/rmanbak/bakl2.log cmdfile=/oracle/ora10g/rmanbak/script/rman_bak_l2.sql
 
rman脚本
全备脚本(每月执行一次全备)
[oracle@redhat script]$ cat full_bak.sql 
run{
allocate channel c1 type disk;
sql 'alter system archive log current';
backup full tag 'order' database
include current controlfile format '/oracle/ora10g/rmanbak/fullback_%d_%T_%s'
plus archivelog format '/oracle/ora10g/rmanbak/bakarch_%d_%T_%s' delete all input;
delete obsolete;
release channel c1;
}
0级备份
cat rman_bak_l0.sql
run{
allocate channel cha1 type disk;
backup
incremental level 0
format "/oracle/ora10g/rmanbak/inc0_%u_%T"
tag wolf_inc0
database;
release channel cha1;
}
1级备份
cat rman_bak_l1.sql
run{
allocate channel cha1 type disk;
backup
incremental level 1
format "/oracle/ora10g/rmanbak/inc0_%u_%T"
tag wolf_inc1
database;
release channel cha1;
}
2级备份
cat rman_bak_l2.sql
run{
allocate channel cha1 type disk;
backup
incremental level 2
format "/oracle/ora10g/rmanbak/inc0_%u_%T"
tag wolf_inc2
database;
release channel cha1;
}
 
每周日执行0级备份,周3执行1级备份,其余时间执行2级备份,shell脚本如下:
 
[oracle@redhat script]$ cat startrman.sh 
#!/bin/bash
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_BASE=/oracle/ora10g
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORACLE_SID=wolf
export ORACLE_TERM=xterm
export PATH=/usr/sbin:$PATH
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/usr/x11R6/lib64
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export LD_ASSUME_KERNEL=2.6.18
export NLS_LANG="SIMPLIFIED CHINESE_CHINA.UTF8"
export PATH=/oracle/ora10g/product/10.2.0/db_1/bin:/usr/sbin:/usr/lib/qt-3.3/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin
SH_HOME=/oracle/ora10g/rmanbak
export SH_HOME
DATE=`date +"%Y%m%d-%H%M"`
week=`date +"%w"`
#-------------------------------------
#confirm whether the oracle is runing
#-------------------------------------
ps -ef | grep dbw0_$ORACLE_SID | grep -v grep >>/dev/null
#-------------------------------------
#begin to backup
#-------------------------------------
if [ $? -eq 0 ]; then
   if [ $week = "0" ]; then
          rman target / @$SH_HOME/script/rman_bak_l0.sql log=$SH_HOME/logs/oraclel0$DATE.log
   else if [ $week = "3" ]; then
          rman target / @$SH_HOME/script/rman_bak_l1.sql log=$SH_HOME/logs/oraclel1$DATE.log
   else 
          rman target / @$SH_HOME/script/rman_bak_l2.sql log=$SH_HOME/logs/oraclel1$DATE.log
fi
fi
fi
  
计划任务
计划任务crontab
root执行
cron文件语法:
            分     小时   日       月       星期     命令
         0-59   0-23   1-31   1-12     0-6     command     (取值范围,0表示周日一般一行对应一个任务)
使用root用户编辑
crontab -e -u oracle               指定为oracle用户编辑计划任务
[oracle@redhat script]$ crontab -l
30 3 * * *              /oracle/ora10g/rmanbak/script/startrman.sh >> /oracle/ora10g/rmanbak/script/crontab.log
 
shell脚本的知识不全面,问了朋友才搞定的,当然最好自己系统的学习一下shell脚本
一些脚本的基本知识(可以分段检查shell程序是否能够执行)
注意标点符号
判断语句,先检查是否存在,然后在进行下面的命令
[oracle@redhat /]$ cat 3.sh 
ps -ef | grep dbw0_$ORACLE_SID | grep -v grep >>/dev/null
if [ $? -eq 0 ]; then
  echo "oracle backup begin"
  else
  echo "oracle_sid error"
  exit 1
fi
[oracle@redhat /]$
ps -ef | grep dbw0_$ORACLE_SID | grep -v grep >>/dev/null
if [ $? -eq 0 ]; then
  echo "oracle backup begin"
  else
  echo "oracle_sid error"
  exit 1                              这个1可以传递给echo $? 意思是说这个命令执行是否成功
fi
[oracle@redhat /]$ cat 2.sh 
ps -ef 
if [ $? -eq 0 ]; then
echo 0000000
fi
[oracle@redhat /]$
echo $?    可以用来检查上一个命令是否正确,如果正常输出为0,错误则为1
DATE=`date +"%Y%m%d"`   这些基本的命令都可以在系统里面一个一个测试
week=`date +"%w"` 
 
[oracle@redhat script]$ cat 22222.sh 
DATE=`date +"%Y%m%d"`
week=`date +"%w"`
echo $DATE
echo $week
if [ $week = 0 ]; then
echo 0000000000000
else echo error
fi
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,