#### 備份腳本 - 修改SID,ORACLE_HOME,LOCAL_DIR（本地備份目錄）,REMOTE_DIR(NFS目錄),用戶,密碼 ``` #!/bin/sh #Author:BrandynX #Date:2017-03-27 #Remark: FOracle backup scripts #Declare the oracle variable export ORACLE_BASE=/app/oracle11g export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1 export ORACLE_SID=dingdb export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK; #Declare the script variable NFS_SAVEDAYS="7" LOCAL_SAVEDAYS="1" TODAY=`date +%Y%m%d` LOCAL_BACKUPDIR_DAY=`date -d "-$LOCAL_SAVEDAYS days" +%Y%m%d` NFS_BACKUPDIR_DAY=`date -d "-$NFS_SAVEDAYS days " +%Y%m%d` LOCAL_DIR=/data/backup REMORT_DIR=/nfsdir/oracle LOG_DIR=/app/scripts # UID Check if [ $UID -ne 0 ];then echo "Please use root to execute the script." exit fi #Loacl backup file processing #Create today backupdir and backup if [ -d $LOCAL_DIR/$TODAY ];then echo "WARNING INFORMATION: $LOCAL_DIR/$TODAY Backup directory already exists" | tee -a $LOG_DIR/scripts.log exit else mkdir -p $LOCAL_DIR/$TODAY fi #Create today export log directory if [ ! -d $LOG_DIR/$TODAY-dingdb ];then mkdir -p $LOG_DIR/$TODAY-dingdb fi #Export oracle data exp ding/iC43sld7h@dingdb file=$LOCAL_DIR/$TODAY/$TODAY-dingdb.dmp log=$LOG_DIR/$TODAY-dingdb/$TODAY-dingdb.log #Compress backup file cd $LOCAL_DIR tar czf $LOCAL_DIR/$TODAY-dingdb.tar.gz $TODAY echo "####################" >> $LOG_DIR/scripts.log echo "BACKUP INFORMATION: LOCAL $TODAY bakcup is complete." | tee -a $LOG_DIR/scripts.log #Synchornize file to NFS #To determine whether there is a bakcup if [ -f $REMORT_DIR/$TODAY-dingdb.tar.gz ];then echo "WARNING INFORMATION: NFS already exists in $TODAY backup file." | tee -a $LOG_DIR/scripts.log exit else cp $LOCAL_DIR/$TODAY-dingdb.tar.gz $REMORT_DIR echo "BACKUP INFORMATION: Remote NFS $TODAY bakcup is complete." |tee -a $LOG_DIR/scripts.log fi #Delete local backup if [ -d $LOCAL_DIR/$LOCAL_BACKUPDIR_DAY ];then rm -rf $LOCAL_DIR/$LOCAL_BACKUPDIR_DAY rm -f $LOCAL_DIR/$LOCAL_BACKUPDIR_DAY-dingdb.tar.gz echo "DELETE INFORMATION: LOCALDIR DELETE $LOCAL_BACKUPDIR_DAY backup is delete. " |tee -a $LOG_DIR/scripts.log fi #Delete nfs backup rm -rf $LOG_DIR/$NFS_BACKUPDIR_DAY-dingdb rm -f $REMORT_DIR/$NFS_BACKUPDIR_DAY-dingdb.tar.gz echo "DELETE INFORMATION: REMOTE NFS DELETE $NFS_BACKUPDIR_DAY backup is delete. " |tee -a $LOG_DIR/scripts.log echo "####################" >> $LOG_DIR/scripts.log echo "" >> $LOG_DIR/scripts.log ``` ##### 增加定時任務 ```shell 50 23 * * * /bin/sh /app/scripts/oracle_bakcup.sh > /dev/null 2>&1 ```