oracle数据备份

find/ -name oracle

#####################################################
## 程序名称： backuptab_reception.sh
## 程序功能： 备份 2008-2010日志表
#####################################################

export HOME=/home/gmcc
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/product/10.2.0/db_1
export ORACLE_SID=zjdata
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/network/lib:$ORACLE_HOME/lib:/lib:/usr/lib
NLS_LANG="Simplified Chinese_china".ZHS16GBK ; export NLS_LANG

##etl用户数据库登陆信息
etlpath="/home/gmcc/etl"
ETLUSERNAME=`cat $etlpath/etc/schema.ini | grep "ETLUSERNAME" | awk -F "=" '{print $2}'`
ETLPASSWORD=`cat $etlpath/etc/schema.ini | grep "ETLPASSWORD" | awk -F "=" '{print $2}'`
DBNAME=`cat $etlpath/etc/schema.ini | grep "DBNAME" | awk -F "=" '{print $2}'`

logininfo=$ETLUSERNAME/$ETLPASSWORD@$DBNAME

##备份路径
despath="/data/backup"

##备份文件日期
filedt=`date +%d`

cd $despath
>$comname.dmp
>$comname.log

comname="CS_REC_RECEPTION_2008"
exp $logininfo tables='BO.CS_REC_RECEPTION_2008' rows=y indexes=n compress=n buffer=65536 feedback=100000 volsize=0 file=$comname.dmp log=$comname.log
mv $comname.dmp $comname.$filedt.dmp
gzip -f $comname.$filedt.dmp
mv $comname.log $comname.$filedt.log
echo "CS_REC_RECEPTION_2008备份结束时间："`date`

comname="CS_REC_RECEPTION_2009"
exp $logininfo tables='BO.CS_REC_RECEPTION_2009' rows=y indexes=n compress=n buffer=65536 feedback=100000 volsize=0 file=$comname.dmp log=$comname.log
mv $comname.dmp $comname.$filedt.dmp
gzip -f $comname.$filedt.dmp
mv $comname.log $comname.$filedt.log
echo "CS_REC_RECEPTION_2009备份结束时间："`date`

comname="CS_REC_RECEPTION_2010"
exp $logininfo tables='BO.CS_REC_RECEPTION_2010' rows=y indexes=n compress=n buffer=65536 feedback=100000 volsize=0 file=$comname.dmp log=$comname.log
mv $comname.dmp $comname.$filedt.dmp
gzip -f $comname.$filedt.dmp
mv $comname.log $comname.$filedt.log
echo "CS_REC_RECEPTION_2010备份结束时间："`date`

exit