oracle安装自动备份,Oracle自动备份脚本

废话不多说了&＃xff0c;直接给大家贴代码了&＃xff0c;具体代码如下所示&＃xff1a;

#!/bin/sh

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

# File: oraclebak.sh

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

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

# 脚本功能:oracle备份脚本

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

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

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

echo $USER

if [ $USER !&＃61; root ]

then

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

exit 1

fi

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

echo "请输入备份程序的安装目录&＃xff1a;"

read installdir

mkdir -p $installdir

result&＃61;$?

while [ $result -ne 0 ]

do

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

read redo

if [ $redo !&＃61; y ]

then

echo "用户退出安装。"

exit 0

fi

echo "请输入备份程序的安装目录&＃xff1a;"

read installdir

mkdir $installdir

result&＃61;$?

done

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

echo "请输入执行备份用户(一般为oracle用户)&＃xff1a;"

read execuser

id $execuser

result&＃61;$?

while [ $result -ne 0 ]

do

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

read redo

if [ $redo !&＃61; y ]

then

echo "用户退出安装"

exit 0

fi

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

read execuser

id $execuser

result&＃61;$?

done

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

read backnum

if [ $backnum -eq 0 ]

then

echo "无备份数据库&＃xff0c;退出安装"

exit 0

fi

scount&＃61;0

while [ $scount -lt $backnum ]

do

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

echo "用户名"

read username[$scount]

echo "密码"

read password[$scount]

echo "服务名"

read sname[$scount]

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

whenever sqlerror exit sql.sqlcode;

connect ${username[$scount]}/${password[$scount]}&＃64;${sname[$scount]}

exit

insert

result&＃61;$?

if [ $result -ne 0 ]

then

echo "输入数据库信息无法被连接&＃xff0c;是否重新输入&＃xff1f;输入y重新输入&＃xff0c;输入n退出安装。"

read redo

if [ $redo !&＃61; y ]

then

echo "用户退出安装"

exit 0

fi

else

scount&＃61;$(($scount&＃43;1))

fi

done

echo "输入值守时间&＃xff0c;值守时间的格式为 mm hh dd MM E 。"

echo "m代表分钟&＃xff0c;h代表小时&＃xff0c;d代表日期&＃xff0c;M代表月份&＃xff0c;E代表星期"

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

scount&＃61;0

iscontinue&＃61;y

while [ $iscontinue &＃61;&＃61; y ]

do

echo "输入第$(($scount&＃43;1))个值守时间"

echo "分钟"

read min

echo "小时"

read hour

echo "日期"

read day

if [ ! $day ]

then

day&＃61;"*"

fi

echo "月份"

read mouth

if [ ! $mouth ]

then

mouth&＃61;"*"

fi

week&＃61;"*"

backtime[$scount]&＃61;"$min $hour $day $mouth $week"

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

echo "是否输入更多值守时间&＃xff1f;输入y继续&＃xff0c;输入n进入下一步。"

read iscontinue

scount&＃61;$(($scount&＃43;1))

done

echo "是否要进行远程备份&＃xff1f;输入y为进行远程备份&＃xff0c;输入n进入下一步"

scount&＃61;0

read iscontinue

while [ $iscontinue &＃61;&＃61; y ]

do

echo "请选择远程备份类型&＃xff0c;输入s为sftp备份类型&＃xff0c;否则为ftp备份类型"

read iss

if [ $iss &＃61;&＃61; s ]

then

rtype[$scount]&＃61;"sftp"

else

rtype[$scount]&＃61;"ftp"

fi

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

read rurl[$scount]

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

read rname[$scount]

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

read rpass[$scount]

echo "是否输入更多远程备份地址&＃xff1f;输入y重新输入&＃xff0c;n进入下一步"

read iscontinue

scount&＃61;$(($scount&＃43;1))

done

# installdir

# execuser

# username password sname

# backtime

# rtype rurl rname rpass

echo "您所作的备份配置如下&＃xff1a;"

sresult&＃61;$(echo -n "$installdir" | grep &＃39;^/&＃39;)

if [ ! $sresult ]

then

installdir&＃61;"$PWD/$installdir"

else

installdir&＃61;$installdir

fi

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

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

echo "系统备份数据库&＃xff1a;"

allcount&＃61;${#username[&＃64;]}

scount&＃61;0

while [ $scount -lt $allcount ]

do

echo "${username[$scount]}/${password[$scount]}&＃64;${sname[$scount]}"

scount&＃61;$(($scount&＃43;1))

done

echo "执行备份的值守时间表&＃xff0c;*代表任意"

scount&＃61;0

backnum&＃61;${#backtime[&＃64;]}

while [ $scount -lt $backnum ]

do

echo "${backtime[$scount]}"

scount&＃61;$(($scount&＃43;1))

done

rnum&＃61;${#rtype[&＃64;]}

if [ $rnum -ne 0 ]

then

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

scount&＃61;0

while [ $scount -lt $rnum ]

do

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

scount&＃61;$(($scount&＃43;1))

done

fi

echo "是否确认安装&＃xff1f;输入y继续&＃xff0c;输入n退出安装"

read isgoon

if [ $isgoon !&＃61; 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&＃61;\$(date &＃43;%Y-%m-%d_%k.%M.%S)">>$installdir/runback.sh

echo "nowmouth&＃61;\$(date &＃43;%Y-%m)">>$installdir/runback.sh

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

scount&＃61;0

snum&＃61;${#username[&＃64;]}

while [ $scount -lt $snum ]

do

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

scount&＃61;$(($scount&＃43;1))

done

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

echo "echo \"\$(date &＃43;%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 &＃43;%Y-%m-%d_%k.%M.%S)打包完成.......................................\">>$installdir/logs/\$nowmouth.log">>$installdir/runback.sh

scount&＃61;0

if [ ${#rtype[&＃64;]} -ne 0 ]

then

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

snum&＃61;${#rtype[&＃64;]}

while [ $scount -lt $snum ]

do

echo "lftp -u ${rname[$scount]},${rpass[$scount]} ${rtype[$scount]}://${rurl[$scount]}<>$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&＃61;$(($scount&＃43;1))

done

echo "echo \"\$(date &＃43;%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&＃61;0

snum&＃61;${#backtime[&＃64;]}

while [ $scount -lt $snum ]

do

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

scount&＃61;$(($scount&＃43;1))

done

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

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

exit 0

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

1、备份脚本&＃xff1a;

#!/bin/sh

export ORACLE_BASE&＃61;/home/oracle

export ORACLE_HOME&＃61;$ORACLE_BASE/product/10.2.0/db_1

export ORACLE_SID&＃61;orcl

export PATH&＃61;$PATH:$HOME/bin:$ORACLE_HOME/bin

export DATA_DIR&＃61;/home/bakup/data

export LOGS_DIR&＃61;/home/bakup/logs

export DELTIME&＃61;&＃96;date -d "7 days ago" &＃43;%Y%m%d&＃96;

export BAKUPTIME&＃61;&＃96;date &＃43;%Y%m%d%H%M%S&＃96;

mkdir -p $DATA_DIR

mkdir -p $LOGS_DIR

echo "Starting bakup..."

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

exp shop/lyisABC0987&＃64;orcl file&＃61;$DATA_DIR/$BAKUPTIME.dmp log&＃61;$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点进行备份

如需每天备份多次&＃xff0c;可设置不同时间段备份&＃xff1a;

例如&＃xff1a;* 3,13,18 * * * /home/bakup/bakup.sh&＃xff0c;即每天3点、13点、18点进行备份。

说明&＃xff1a;文件备份目录&＃xff0c;用户oracle必须有更改权限&＃xff0c;否则无法备份。