Rman备份_Ziqiu-ChinaUnix博客

公告：【5月博客评选】欢迎提交本月原创作品

Anywhere

http://blog.chinaunix.net/space.php?uid=59012

首页 | 博文目录 | 相册 | 博客圈 | 关于我 | 留言

个人资料

Ziqiu

微博论坛

发纸条打招呼加关注加好友

博客访问：201209
博文数量：71
博客积分：3000
博客等级：中校
注册时间：2006-08-18 17:41:38

文章分类

订阅我的博客

字体大小：大中小博文

Rman备份 (2006-08-21 13:10)

分类： Oracle

前些天由于工作需要，写了一个用rman进行自动备份的脚本。现放到blog中，算是庆祝blog的开通吧！

脚本说明：

1、运行这个rman.sh的脚本会自动生成rman_0.sh,rman_1.sh,rman_2.sh,(0,1,2分别表示增量备份的等级),且会根据备份的策略自动调用这三个sh。

2、根据不同需求，需要对sh脚本的环境变量进行修改。

3、会自动生成rman的备份集目录，rman脚本sh的存放目录，以及日志目录等sh运行环境的目录。

4、如果是rac环境，在备份archivelog时可能要修改对应的代码。

5、此sh脚本在rh-as4+oracle10.2.0.1环境下成功应用，经修改部分代码后成功应用于rh-as4+oracle10.1.0.1 rac环境中。

脚本运行方法：

1、修改实际的环境变量

2、把rman.sh加载到系统oracle 用户crontab任务中

#!/bin/bash
#By XuefengMa 2006-08-10
#版权说明:未经允许不得转载
#版本说明:每次修改脚本需要对版本进行说明
#version: 1.0
# 暂不提供磁带机备份的功能
#version:2.0
# 整合了以前rman_0,rman_1,rman_2三个脚本，只需要运行rman.sh即可生成3个脚本，且自动调用
#
#
#Set Oracle Environment Variable
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/10.2.0/db_1
export ORACLE_SID=ziqiu
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/sbin
export LANG=en_US
export LC_ALL=en_US
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
#
#
#
#
#Set The Script Environment Variable
#
SHELL=$SHELL
backup_base=/opt/rman
backup_controlfile=$backup_base/controlfile
backup_archivelog=$backup_base/archivelog
backup_database=$backup_base/database
backup_log=$backup_base/log
day=`date +%y%m%d`
log=$backup_log/$day.log
sid_target=ziqiu
sid_catalog=rman
user_target=sys
pwd_target=ziqiu
user_catalog=rman
pwd_catalog=rman
time=`date +%a`
sh_base=/home/oracle
sh_rman=$sh_base/rman
rman_0=$sh_rman/rman_0.sh
rman_1=$sh_rman/rman_1.sh
rman_2=$sh_rman/rman_2.sh

if [ -w $log ]
then
rm $log
fi

if [ -n "`echo $$`" ]
then
   echo "################# `date -u +%y%m%d%H%M%S` The Script Of RMAN Begin Now! #################\n">>$log
else
   echo "################# `date -u +%y%m%d%H%M%S` The Script Of RMAN Is Defeat Begin Now! #################\n">>$log
   exit 1
fi

if [ ! -d $backup_controlfile ]
then
mkdir $backup_controlfile
echo "################# `date -u +%y%m%d%H%M%S` Create The $backup_controlfile Succ! #################\n">>$log
fi

if [ ! -d $backup_archivelog ]
then
mkdir $backup_archivelog
echo "################# `date -u +%y%m%d%H%M%S` Create The $backup_archivelog Succ! #################\n">>$log
fi

if [ ! -d $backup_spfile ]
then
   mkdir $backup_spfile
   echo "################# `date -u +%y%m%d%H%M%S` Create The $backup_spfile Succ! #################\n">>$log
fi

if [ ! -d $backup_database ]
then
mkdir $backup_database
echo "################# `date -u +%y%m%d%H%M%S` Create The $backup_database Succ! #################\n">>$log
fi

if [ ! -d $backup_log ]
then
mkdir $backup_log
echo "################# `date -u +%y%m%d%H%M%S` Create The $backup_log Succ! #################\n">>$log
fi

if [ ! -d $sh_rman ]
then
mkdir $sh_rman
echo "################# `date -u +%y%m%d%H%M%S` Create The $sh_rman Succ! #################\n">>$log
fi

if [ ! -w $rman_0.sh ]
  then
  echo "#!$SHELL">>$rman_0
  echo "#Set Oracle Environment Variable">>$rman_0
    echo "export ORACLE_BASE=$ORACLE_BASE" >>$rman_0
    echo "export ORACLE_HOME=$ORACLE_HOME" >>$rman_0
    echo "export ORACLE_SID=$ORACLE_SID"   >>$rman_0
    echo "export PATH=$PATH"        >>$rman_0
    echo "export LANG=$LANG"        >>$rman_0
    echo "export LC_ALL=$LC_ALL"     >>$rman_0
    echo "export NLS_LANG=$NLS_LANG"    >>$rman_0



    echo "#Set The Script Environment Variable" >>$rman_0
    echo "backup_base=$backup_base"       >>$rman_0
    echo "backup_controlfile=$backup_controlfile">>$rman_0
    echo "backup_archivelog=$backup_archivelog" >>$rman_0
    echo "backup_database=$backup_database"   >>$rman_0
    echo "backup_log=$backup_log"        >>$rman_0
    echo "sid_target=$sid_target"        >>$rman_0
    echo "sid_catalog=$sid_catalog"       >>$rman_0
    echo "user_target=$user_target"       >>$rman_0
    echo "pwd_target=$pwd_target"        >>$rman_0
    echo "user_catalog=$user_catalog"      >>$rman_0
    echo "pwd_catalog=$pwd_catalog"       >>$rman_0

    echo "#Backup The Controlfile"       >>$rman_0

    echo "rman target $user_target/$pwd_target@$sid_target catalog $user_catalog/$pwd_catalog@$sid_catalog <<EOF">>$rman_0
    echo "configure controlfile autobackup on;" >>$rman_0
    echo "run"                 >>$rman_0
    echo "     {"             >>$rman_0
    echo "     allocate channel d1 type disk;"         >>$rman_0
    echo "     backup current controlfile format '$backup_controlfile/%d_%T_%s_%p.ctl';" >>$rman_0
    echo "     release channel d1; "              >>$rman_0
    echo "     }"             >>$rman_0


    echo "run "                 >>$rman_0
    echo "          {"             >>$rman_0
    echo "          allocate channel d1 type disk;"        >>$rman_0
    echo "          allocate channel d2 type disk;"        >>$rman_0
    echo "          allocate channel d3 type disk;"        >>$rman_0
    echo "          backup incremental level=0 database format '$backup_database/incr0_%d_%T_%s_%p.bak' ;">>$rman_0
    echo "          release channel d1;"             >>$rman_0
    echo "          release channel d2;"             >>$rman_0
    echo "          release channel d3;"             >>$rman_0
    echo "          }"             >>$rman_0
    echo "run"                 >>$rman_0
    echo "     {"             >>$rman_0
    echo "     allocate channel d1 type disk ;"        >>$rman_0
    echo "     allocate channel d2 type disk ;"        >>$rman_0
    echo "     sql'alter system archive log current';"     >>$rman_0
    echo "     backup archivelog all format '$backup_archivelog/%d_%T_%s_%p.arc' delete all input;" >>$rman_0
    echo "     release channel d1;"    >>$rman_0
    echo "     release channel d2;"    >>$rman_0
    echo "     }"                      >>$rman_0

    echo "exit          "      >>$rman_0

if [ ! -w $rman_1.sh ]
  then
  echo "#!$SHELL">>$rman_1
  echo "#Set Oracle Environment Variable">>$rman_1
    echo "export ORACLE_BASE=$ORACLE_BASE" >>$rman_1
    echo "export ORACLE_HOME=$ORACLE_HOME" >>$rman_1
    echo "export ORACLE_SID=$ORACLE_SID"   >>$rman_1
    echo "export PATH=$PATH"        >>$rman_1
    echo "export LANG=$LANG"        >>$rman_1
    echo "export LC_ALL=$LC_ALL"     >>$rman_1
    echo "export NLS_LANG=$NLS_LANG"    >>$rman_1



    echo "#Set The Script Environment Variable" >>$rman_1
    echo "backup_base=$backup_base"       >>$rman_1
    echo "backup_controlfile=$backup_controlfile">>$rman_1
    echo "backup_archivelog=$backup_archivelog" >>$rman_1
    echo "backup_database=$backup_database"   >>$rman_1
    echo "backup_log=$backup_log"        >>$rman_1
    echo "sid_target=$sid_target"        >>$rman_1
    echo "sid_catalog=$sid_catalog"       >>$rman_1
    echo "user_target=$user_target"       >>$rman_1
    echo "pwd_target=$pwd_target"        >>$rman_1
    echo "user_catalog=$user_catalog"      >>$rman_1
    echo "pwd_catalog=$pwd_catalog"       >>$rman_1


    echo "#Backup The Controlfile"       >>$rman_1
    #
    #
    echo "rman target $user_target/$pwd_target@$sid_target catalog $user_catalog/$pwd_catalog@$sid_catalog <<EOF">>$rman_1
    echo "configure controlfile autobackup on;">>$rman_1
    echo "run ">>$rman_1
    echo "     {">>$rman_1
    echo "     allocate channel d1 type disk;">>$rman_1
    echo "     backup current controlfile format '$backup_controlfile/%d_%T_%s_%p.ctl';">>$rman_1
    echo "     release channel d1; ">>$rman_1
    echo "     }">>$rman_1
    echo "">>$rman_1
    echo "">>$rman_1
    echo "run ">>$rman_1
    echo "          {">>$rman_1
    echo "          allocate channel d1 type disk;">>$rman_1
    echo "          allocate channel d2 type disk;">>$rman_1
    echo "          allocate channel d3 type disk;">>$rman_1
    echo "          backup incremental level=1 database format '$backup_database/incr1_%d_%T_%s_%p.bak' ;">>$rman_1
    echo "          release channel d1;">>$rman_1
    echo "          release channel d2;">>$rman_1
    echo "          release channel d3;">>$rman_1
    echo "          }">>$rman_1
    echo "run">>$rman_1
    echo "     {">>$rman_1
    echo "     allocate channel d1 type disk ;">>$rman_1
    echo "     allocate channel d2 type disk ;">>$rman_1
    echo "     sql'alter system archive log current';">>$rman_1
    echo "     backup archivelog all format '$backup_archivelog/%d_%T_%s_%p.arc' delete all input;">>$rman_1
    echo "     release channel d1;">>$rman_1
    echo "     release channel d2;">>$rman_1
    echo "     }">>$rman_1
    echo "">>$rman_1
    echo "exit          "      >>$rman_1
fi

if [ ! -w $rman_2.sh ]
  then
  echo "#!$SHELL">>$rman_2
  echo "#Set Oracle Environment Variable">>$rman_2
    echo "export ORACLE_BASE=$ORACLE_BASE" >>$rman_2
    echo "export ORACLE_HOME=$ORACLE_HOME" >>$rman_2
    echo "export ORACLE_SID=$ORACLE_SID"   >>$rman_2
    echo "export PATH=$PATH"        >>$rman_2
    echo "export LANG=$LANG"        >>$rman_2
    echo "export LC_ALL=$LC_ALL"     >>$rman_2
    echo "export NLS_LANG=$NLS_LANG"    >>$rman_2



    echo "#Set The Script Environment Variable" >>$rman_2
    echo "backup_base=$backup_base"       >>$rman_2
    echo "backup_controlfile=$backup_controlfile">>$rman_2
    echo "backup_archivelog=$backup_archivelog" >>$rman_2
    echo "backup_database=$backup_database"   >>$rman_2
    echo "backup_log=$backup_log"        >>$rman_2
    echo "sid_target=$sid_target"        >>$rman_2
    echo "sid_catalog=$sid_catalog"       >>$rman_2
    echo "user_target=$user_target"       >>$rman_2
    echo "pwd_target=$pwd_target"        >>$rman_2
    echo "user_catalog=$user_catalog"      >>$rman_2
    echo "pwd_catalog=$pwd_catalog"       >>$rman_2


    echo "#Backup The Controlfile">>$rman_2
    #
    #
    echo "rman target $user_target/$pwd_target@$sid_target catalog $user_catalog/$pwd_catalog@$sid_catalog <<EOF">>$rman_2
    echo "configure controlfile autobackup on;">>$rman_2
    echo "run ">>$rman_2
    echo "     {">>$rman_2
    echo "     allocate channel d1 type disk;">>$rman_2
    echo "     backup current controlfile format '$backup_controlfile/%d_%T_%s_%p.ctl';">>$rman_2
    echo "     release channel d1; ">>$rman_2
    echo "     }">>$rman_2
    echo "">>$rman_2
    echo "">>$rman_2
    echo "run ">>$rman_2
    echo "          {">>$rman_2
    echo "          allocate channel d1 type disk;">>$rman_2
    echo "          allocate channel d2 type disk;">>$rman_2
    echo "          allocate channel d3 type disk;">>$rman_2
    echo "          backup incremental level=2 database format '$backup_database/incr2_%d_%T_%s_%p.bak' ;">>$rman_2
    echo "          release channel d1;">>$rman_2
    echo "          release channel d2;">>$rman_2
    echo "          release channel d3;">>$rman_2
    echo "          }">>$rman_2
    echo "run">>$rman_2
    echo "     {">>$rman_2
    echo "     allocate channel d1 type disk;">>$rman_2
    echo "     allocate channel d2 type disk ;">>$rman_2
    echo "     sql'alter system archive log current';">>$rman_2
    echo "     backup archivelog all format '$backup_archivelog/%d_%T_%s_%p.arc' delete all input;">>$rman_2
    echo "     release channel d1;">>$rman_2
    echo "     release channel d2;">>$rman_2
    echo "     }">>$rman_2
    echo "">>$rman_2
    echo "exit        ">>$rman_2

fi
chmod u+x $rman_0 $rman_1 $rman_2
if [ $time = "Mon" ]
  then echo "################# `$rman_0`################# \n">>$log
elif [ $time = "Tue" ]
  then echo "################# `$rman_2`################# \n">>$log
elif [ $time = "Wed" ]
  then echo "################# `$rman_2`################# \n">>$log
elif [ $time = "Thu" ]
  then echo "################# `$rman_1`################# \n">>$log
elif [ $time = "Fri" ]
  then echo "################# `$rman_2`################# \n">>$log
elif [ $time = "Sat" ]
  then echo "################# `$rman_2`################# \n">>$log
else
#[ $time = "Sun" ]
     echo "################# `$rman_0`################# \n">>$log
fi

博客推荐文章

什么时候使用bitmap索引和b-tree索引 (2小时前)
MongoDB管理与开发精要《红丸出品》2.1 Windows平台的安装 (3小时前)
污染源烟气、烟尘连续监测系统 (6小时前)
oracle字符串转换为数字（复杂的） (6小时前)
ORACLE常用数值函数、转换函数、字符串函数介绍 (6小时前)

分享到：新浪微博 QQ空间开心网豆瓣人人网 twitter fb

0
顶

热门产品推荐

阅读(607)┊ 评论 (0)┊收藏(0)┊举报┊打印

前一篇：我的blog开通啦！

亲，您还没有登录,请[登录]或[注册]后再进行评论