Oracle自动备份脚本

废话不多说了，直接给大家贴代码了，具体代码如下所示：

				?

									#!/bin/sh

									#******************************************************************

									# File: oraclebak.sh

									# Creation Date: 2014/1/22 17:57:32

									# Last Modified: 2014/1/22 17:57:34

									# 脚本功能:oracle备份脚本

									# 执行方法:1、第一次执行需要root用户执行，脚本会以询问的方式创建备份目录和相关参数

									# 2、脚本会自动写入crontab调度里面定时执行，crontab设置是在第一次执行的时候自动添加的

									#******************************************************************

									echo $USER

									if [ $USER != root ]

									then

									echo "检测到安装用户不是root用户，请用root用户登录再执行安装文件"

									exit 1

									fi

									echo "开始安装oracle数据库备份工具.........................."

									echo "请输入备份程序的安装目录："

									read installdir

									mkdir -p $installdir

									result=$?

									while [ $result -ne 0 ]

									do

									echo "无法创建目录，请重新输入或退出安装。输入y重新输入，输入n退出安装。"

									read redo

									if [ $redo != y ]

									then

									echo "用户退出安装。"

									exit 0

									fi

									echo "请输入备份程序的安装目录："

									read installdir

									mkdir $installdir

									result=$?

									done

									echo "安装目录创建完成。"

									echo "请输入执行备份用户(一般为oracle用户)："

									read execuser

									id $execuser

									result=$?

									while [ $result -ne 0 ]

									do

									echo "不存在该用户，是否更换其它用户或者退出安装新建用户，输入y更换用户，输入n退出安装"

									read redo

									if [ $redo != y ]

									then

									echo "用户退出安装"

									exit 0

									fi

									echo "请输入执行备份的用户(一般为tnmsdb2用户)"

									read execuser

									id $execuser

									result=$?

									done

									echo "你希望建立备份的数据库数量(一般为1)"

									read backnum

									if [ $backnum -eq 0 ]

									then

									echo "无备份数据库，退出安装"

									exit 0

									fi

									scount=0

									while [ $scount -lt $backnum ]

									do

									echo "请输入第"$(($scount+1))"个备份登录登录oracle数据库的用户名和密码，以及本地服务名"

									echo "用户名"

									read username[$scount]

									echo "密码"

									read password[$scount]

									echo "服务名"

									read sname[$scount]

									su -l -c"sqlplus /nolog" $execuser<<insert

									whenever sqlerror exit sql.sqlcode;

									connect ${username[$scount]}/${password[$scount]}@${sname[$scount]}

									exit

									insert

									result=$?

									if [ $result -ne 0 ]

									then

									echo "输入数据库信息无法被连接，是否重新输入？输入y重新输入，输入n退出安装。"

									read redo

									if [ $redo != y ]

									then

									echo "用户退出安装"

									exit 0

									fi

									else

									scount=$(($scount+1))

									fi

									done

									echo "输入值守时间，值守时间的格式为 mm hh dd MM E 。"

									echo "m代表分钟，h代表小时，d代表日期，M代表月份，E代表星期"

									echo "不输入则为任意时间"

									scount=0

									iscontinue=y

									while [ $iscontinue == y ]

									do

									echo "输入第$(($scount+1))个值守时间"

									echo "分钟"

									read min

									echo "小时"

									read hour

									echo "日期"

									read day

									if [ ! $day ]

									then

									day="*"

									fi

									echo "月份"

									read mouth

									if [ ! $mouth ]

									then

									mouth="*"

									fi

									week="*"

									backtime[$scount]="$min $hour $day $mouth $week"

									echo -e "${backtime[$scount]}"

									echo "是否输入更多值守时间？输入y继续，输入n进入下一步。"

									read iscontinue

									scount=$(($scount+1))

									done

									echo "是否要进行远程备份？输入y为进行远程备份，输入n进入下一步"

									scount=0

									read iscontinue

									while [ $iscontinue == y ]

									do

									echo "请选择远程备份类型，输入s为sftp备份类型，否则为ftp备份类型"

									read iss

									if [ $iss == s ]

									then

									rtype[$scount]="sftp"

									else

									rtype[$scount]="ftp"

									fi

									echo "请输入远程备份地址，可以为域名，计算机名或者ip地址"

									read rurl[$scount]

									echo "请输入远程备份登录名"

									read rname[$scount]

									echo "请输入远程备份登录密码"

									read rpass[$scount]

									echo "是否输入更多远程备份地址？输入y重新输入，n进入下一步"

									read iscontinue

									scount=$(($scount+1))

									done

									# installdir

									# execuser

									# username password sname

									# backtime

									# rtype rurl rname rpass

									echo "您所作的备份配置如下："

									sresult=$(echo -n "$installdir" | grep '^/')

									if [ ! $sresult ]

									then

									installdir="$PWD/$installdir"

									else

									installdir=$installdir

									fi

									echo "本地备份目录为$installdir"

									echo "执行备份系统用户为$execuser"

									echo "系统备份数据库："

									allcount=${#username[@]}

									scount=0

									while [ $scount -lt $allcount ]

									do

									echo "${username[$scount]}/${password[$scount]}@${sname[$scount]}"

									scount=$(($scount+1))

									done

									echo "执行备份的值守时间表，*代表任意"

									scount=0

									backnum=${#backtime[@]}

									while [ $scount -lt $backnum ]

									do

									echo "${backtime[$scount]}"

									scount=$(($scount+1))

									done

									rnum=${#rtype[@]}

									if [ $rnum -ne 0 ]

									then

									echo "远程备份的服务地址为:"

									scount=0

									while [ $scount -lt $rnum ]

									do

									echo "连接方式:${rtype[$scount]},连接地址:${rurl[$scount]},用户名:${rname[$scount]},密码:${rpass[$scount]}"

									scount=$(($scount+1))

									done

									fi

									echo "是否确认安装？输入y继续，输入n退出安装"

									read isgoon

									if [ $isgoon != y ]

									then

									exit 0;

									fi

									echo "正在生产目录结构................................";

									mkdir -p $installdir/logs

									mkdir -p $installdir/temp

									mkdir -p $installdir/zip

									chown -Rvf $execuser $installdir

									echo "目录结构生成完成................................"

									echo "生成备份执行文件................................"

									echo "#!/bin/bash">$installdir/runback.sh

									echo "source ~/.bash_profile">>$installdir/runback.sh

									echo "nowdate=\$(date +%Y-%m-%d_%k.%M.%S)">>$installdir/runback.sh

									echo "nowmouth=\$(date +%Y-%m)">>$installdir/runback.sh

									echo "echo \"\$nowdate开始备份.......................................\">>$installdir/logs/\$nowmouth.log">>$installdir/runback.sh

									scount=0

									snum=${#username[@]}

									while [ $scount -lt $snum ]

									do

									echo "exp ${username[$scount]}/${password[$scount]}@${sname[$scount]} file=$installdir/temp/${username[$scount]}_${sname[$scount]}\$nowdate.dmp compress=N>>$installdir/logs/\$nowmouth.log 2>&1">>$installdir/runback.sh

									scount=$(($scount+1))

									done

									echo "echo \"\$(date +%Y-%m-%d_%k.%M.%S)完成备份.......................................\">>$installdir/logs/\$nowmouth.log">>$installdir/runback.sh

									echo "echo \"\$(date +%Y-%m-%d_%k.%M.%S)开始打包.......................................\">>$installdir/logs/\$nowmouth.log">>$installdir/runback.sh

									echo "gzip $installdir/zip/\$nowdate.zip $installdir/temp/>>$installdir/logs/\$nowmouth.log 2>&1">>$installdir/runback.sh

									echo "rm -Rvf $installdir/temp/*>>$installdir/logs/\$nowmouth.log 2>&1">>$installdir/runback.sh

									echo "echo \"\$(date +%Y-%m-%d_%k.%M.%S)打包完成.......................................\">>$installdir/logs/\$nowmouth.log">>$installdir/runback.sh

									scount=0

									if [ ${#rtype[@]} -ne 0 ]

									then

									echo "echo \"\$(date +%Y-%m-%d_%k.%M.%S)进行远程备份.......................................\">>$installdir/logs/\$nowmouth.log">>$installdir/runback.sh

									snum=${#rtype[@]}

									while [ $scount -lt $snum ]

									do

									echo "lftp -u ${rname[$scount]},${rpass[$scount]} ${rtype[$scount]}://${rurl[$scount]}<<remote">>$installdir/runback.sh

									echo "mkdir remotedbback">>$installdir/runback.sh

									echo "cd remotedbback">>$installdir/runback.sh

									echo "mput $installdir/zip/\$nowdate.zip">>$installdir/runback.sh

									echo "exit">>$installdir/runback.sh

									echo "remote">>$installdir/runback.sh

									scount=$(($scount+1))

									done

									echo "echo \"\$(date +%Y-%m-%d_%k.%M.%S)完成远程备份.......................................\">>$installdir/logs/\$nowmouth.log">>$installdir/runback.sh

									fi

									echo "exit 0">>$installdir/runback.sh

									chmod 775 $installdir/runback.sh

									chown $execuser $installdir/runback.sh

									echo "生成备份执行文件完成............................"

									echo "开始定制值守时间................................"

									scount=0

									snum=${#backtime[@]}

									while [ $scount -lt $snum ]

									do

									echo "${backtime[$scount]} $installdir/runback.sh">>$installdir/planlist

									scount=$(($scount+1))

									done

									su -l -c"crontab $installdir/planlist" oracle

									echo "完成值守时间定制................................"

									exit 0

接下来给大家介绍linux oracle自动备份脚本

1、备份脚本：

				?

									#!/bin/sh 

									export ORACLE_BASE=/home/oracle 

									export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1 

									export ORACLE_SID=orcl 

									export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin 

									export DATA_DIR=/home/bakup/data 

									export LOGS_DIR=/home/bakup/logs 

									export DELTIME=`date -d "7 days ago" +%Y%m%d` 

									export BAKUPTIME=`date +%Y%m%d%H%M%S` 

									mkdir -p $DATA_DIR 

									mkdir -p $LOGS_DIR 

									echo "Starting bakup..."

									echo "Bakup file path $DATA_DIR/$BAKUPTIME.dmp"

									exp shop/lyisABC0987@orcl file=$DATA_DIR/$BAKUPTIME.dmp log=$LOGS_DIR/$BAKUPTIME.log 

									echo "Delete the file bakup before 7 days..."

									rm -rf $DATA_DIR/$DELTIME*.dmp 

									rm -rf $LOGS_DIR/$DELTIME*.log 

									echo "Delete the file bakup successfully. "

									echo "Bakup completed."

2、添加到任务调度

crontab -u oracle -e
* 3 * * * /home/bakup/bakup.sh
即每天凌晨3点进行备份
如需每天备份多次，可设置不同时间段备份：
例如：* 3,13,18 * * * /home/bakup/bakup.sh，即每天3点、13点、18点进行备份。
说明：文件备份目录，用户oracle必须有更改权限，否则无法备份。

相关文章

热门资讯