oracle 備份腳步

標籤：div   class   ack   upd   time   dir   version   $nf   app   

 1 #!/bin/sh 2 # Date: 2016-08-13 15:34 3 # Author: chzh 4 # Version: 0.0.1 5 # Update: Add copy db backup file to remote back server 6  7 export ORACLE_BASE=/u01/app/oracle 8 export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 9 export PATH=$ORACLE_HOME/bin:$PATH10 export ORACLE_OWNER=oracle11 export ORACLE_SID=orcl12 export NLS_LANG=American_America.ZHS16GBK13 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib14 15 cd /home/oracle/db_backup_18816 exptime=`date +%Y-%m-%d_%H`17 nfs_mount_dir=`df -h | grep -i ‘211.153.66.111‘ | awk ‘{print $6}‘`18 [ -n $nfs_mount_dir ] && remote_back_dir=${nfs_mount_dir}/db_backup_oracle_6.17419 20 echo "backup the log file"21 [ -d script_execute_log ] || mkdir script_execute_log22 mv exp.log script_execute_log/exp_`date +%Y-%m-%d`.log23 24 cat exp.list | while read dbUser dbPasswd25 do26         echo $dbUser27         exp $dbUser/$dbPasswd GRANTS=Y file=$dbUser"_"$exptime.dmp28         if [ "0" == $? ]29         then30                 tar -zcvf $dbUser"_"$exptime.dmp.tar.gz $dbUser"_"$exptime.dmp31         [ -d ${remote_back_dir}/`date +%Y-%m` ] || mkdir ${remote_back_dir}/`date +%Y-%m`32         /bin/cp $dbUser"_"$exptime.dmp.tar.gz ${remote_back_dir}/`date +%Y-%m`33                 rm $dbUser"_"$exptime.dmp34         fi35 done36 37 # 10 mean 3 day ago, Because have to user exported tables.38 if [ `ls -l *.tar.gz | wc -l` -gt 6 ]; then39     find . -mtime +2 -name "*.dmp.tar.gz" |xargs /bin/rm -f > /dev/null40 fi

同目錄下exp.list檔案存放帳戶名稱和密碼。

 

oracle 備份腳步