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 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<$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]}<$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

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."