会python真的可以为所欲为0(回)
351天前
这里还有人吗1(回)
536天前这里还有人吗0(回)
536天前
每天面对着电脑屏幕，敲打键盘。我所面对的并不只是代码，而是一种生活方式。0(回)
761天前到处都是羊，不想上班0(回)
841天前
鸽子
0(回)
845天前#!/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 |
