#!/bin/bash
source /home/oracle/.bash_profile
export LANG=zh_CN.UTF-8
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export ORACLE_SID=hbyttest;
date1=$date
date=$(date +\%Y\%m\%d)
days=3
bakdir=/home/oracle/backup
cd $bakdir
cd hbyt
exp hbyttest/hbyttest grants=y file=/home/oracle/backup/hbyt/hbyt_$date.dmp log=/home/oracle/backup/hbyt/hbyt_$date.log &>/dev/null
tar -zcvf hbyt_$date.tar.gz hbyt_$date.dmp hbyt_$date.log
find $bakdir/hbyt -type f -name "*.log" -exec rm {} \;
find $bakdir/hbyt -type f -name "*.dmp" -exec rm {} \;
find $bakdir/hbyt -type f -name "*.tar.gz" -mtime +$days -exec rm -rf {} \;
export ORACLE_SID=orcl;
scp hbyt_$date.tar.gz root@10.188.1.7:/backup/hbyt
echo "$(date +"%Y-%m-%d %X") -------------- 备份成功!!" >>/home/oracle/logs/backup.log
source /home/oracle/.bash_profile
export LANG=zh_CN.UTF-8
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
export ORACLE_SID=hbyttest;
date1=$date
date=$(date +\%Y\%m\%d)
days=3
bakdir=/home/oracle/backup
cd $bakdir
cd hbyt
exp hbyttest/hbyttest grants=y file=/home/oracle/backup/hbyt/hbyt_$date.dmp log=/home/oracle/backup/hbyt/hbyt_$date.log &>/dev/null
tar -zcvf hbyt_$date.tar.gz hbyt_$date.dmp hbyt_$date.log
find $bakdir/hbyt -type f -name "*.log" -exec rm {} \;
find $bakdir/hbyt -type f -name "*.dmp" -exec rm {} \;
find $bakdir/hbyt -type f -name "*.tar.gz" -mtime +$days -exec rm -rf {} \;
export ORACLE_SID=orcl;
scp hbyt_$date.tar.gz root@10.188.1.7:/backup/hbyt
echo "$(date +"%Y-%m-%d %X") -------------- 备份成功!!" >>/home/oracle/logs/backup.log
echo "" >>/home/oracle/logs/backup.log
可放在crontab定时任务中,每天备份
另有一数据库字符集编码设置的更改操作方式
http://blog.itpub.net/29151695/viewspace-1173238/