oracle自动备份脚本文件怎么打开,Oracle自动备份脚本-CSDN博客

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

sql;">

#!/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

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

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

read installdir

mkdir -p $installdir

result=$?

while [ $result -ne 0 ]

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

read redo

if [ $redo != y ]

then

echo "用户退出安装。"

exit 0

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

read installdir

mkdir $installdir

result=$?

done

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

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

read execuser

id $execuser

result=$?

while [ $result -ne 0 ]

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

read redo

if [ $redo != y ]

then

echo "用户退出安装"

exit 0

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

read execuser

id $execuser

result=$?

done

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

read backnum

if [ $backnum -eq 0 ]

then

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

exit 0

scount=0

while [ $scount -lt $backnum ]

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

echo "用户名"

read username[$scount]

echo "密码"

read password[$scount]

echo "服务名"

read sname[$scount]

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

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 ]

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 ]

echo "lftp -u ${rname[$scount]},${rpass[$scount]} ${rtype[$scount]}://${rurl[$scount]}

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

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 ]

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、备份脚本：

sql;">

#!/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必须有更改权限，否则无法备份。

总结

以上是编程之家为你收集整理的Oracle自动备份脚本全部内容，希望文章能够帮你解决Oracle自动备份脚本所遇到的程序开发问题。

如果觉得编程之家网站内容还不错，欢迎将编程之家网站推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。