用户注册



邮箱:

密码:

用户登录


邮箱:

密码:
记住登录一个月忘记密码?

发表随想


还能输入:200字
云代码 - shell代码库

使用shell远程备份oracle

2012-10-18 作者: 神马举报

[shell]代码库

#!/bin/bash
#function: to execute the oracle built-in  cmd
#version 1
echo "please run this script on cautiously!!!If you forget sth ,or want to abort the script,now ctrl+c will be abort,if you run it bg,you must now how to abort it."
sleep 10;
echo "now begining"
backupdate=`date +%Y%m%d`
mkdir -p $backupdate
if [[ -d $backupdate ]]&& [[ -f /home/oracle/db_list ]]
then
cd $backupdate
cp /home/oracle/db_list .
else
exit
fi
echo "begining exporting....."
#for db_name in db_list
for db_name in `cat db_list`
do
exp $db_name/123 OWNER=$db_name FILE=$backupdate$db_name.emp
if [ $? -eq 0 ]
        then
        echo "you succeed backup the database"
else
#or >
        echo "you failed backup,you must rerun the script. backup failed"|tee -a error.message
                mail -s 16_oracle_bak jinwei.bian@qeegoo.com
        exit 12
fi
done
#use scp with no password,you must use ssh-key to generate the key
scp -pv /home/oracle/$backupdate/*.emp root@192.168.11.21:/data/16_ora_backup/
echo -e "backup finished in $backupdate ." >finished.message
mail -s 16_oracle_bak jinwei.bian@qeegoo.com
exit 0


网友评论    (发表评论)


发表评论:

评论须知:

  • 1、评论每次加2分,每天上限为30;
  • 2、请文明用语,共同创建干净的技术交流环境;
  • 3、若被发现提交非法信息,评论将会被删除,并且给予扣分处理,严重者给予封号处理;
  • 4、请勿发布广告信息或其他无关评论,否则将会删除评论并扣分,严重者给予封号处理。


扫码下载

加载中,请稍后...

输入口令后可复制整站源码

加载中,请稍后...