Oracle自动备份脚本
程序员文章站
2022-07-05 21:13:21
废话不多说了,直接给大家贴代码了,具体代码如下所示:
#!/bin/sh
#******************************************...
废话不多说了,直接给大家贴代码了,具体代码如下所示:
#!/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必须有更改权限,否则无法备份。
上一篇: 从前序与中序遍历序列构造二叉树-二叉树