oracle 备份脚步

 #!/bin/sh

 # Date: -- :

 # Author: chzh

 # Version: 0.0.

 # Update: Add copy db backup file to remote back server

 export ORACLE_BASE=/u01/app/oracle

 export ORACLE_HOME=$ORACLE_BASE/product/11.2./db_1

 export PATH=$ORACLE_HOME/bin:$PATH

 export ORACLE_OWNER=oracle

 export ORACLE_SID=orcl

 export NLS_LANG=American_America.ZHS16GBK

 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

 cd /home/oracle/db_backup_188

 exptime=`date +%Y-%m-%d_%H`

 nfs_mount_dir=`df -h | grep -i '211.153.66.111' | awk '{print $6}'`

 [ -n $nfs_mount_dir ] && remote_back_dir=${nfs_mount_dir}/db_backup_oracle_6.

 echo "backup the log file"

 [ -d script_execute_log ] || mkdir script_execute_log

 mv exp.log script_execute_log/exp_`date +%Y-%m-%d`.log

 cat exp.list | while read dbUser dbPasswd

 do

         echo $dbUser

         exp $dbUser/$dbPasswd GRANTS=Y file=$dbUser"_"$exptime.dmp

         if [ "" == $? ]

         then

                 tar -zcvf $dbUser"_"$exptime.dmp.tar.gz $dbUser"_"$exptime.dmp

         [ -d ${remote_back_dir}/`date +%Y-%m` ] || mkdir ${remote_back_dir}/`date +%Y-%m`

         /bin/cp $dbUser"_"$exptime.dmp.tar.gz ${remote_back_dir}/`date +%Y-%m`

                 rm $dbUser"_"$exptime.dmp

         fi

 done

 #  mean  day ago, Because have to user exported tables.

 if [ `ls -l *.tar.gz | wc -l` -gt  ]; then

     find . -mtime + -name "*.dmp.tar.gz" |xargs /bin/rm -f > /dev/null

 fi

同目录下exp.list文件存放帐户名和密码。