备份discuz论坛数据：

#!/bin/bash
#desc:bak discuz mysql data
#date:2008.04.17
#author:dougq
date
echo "Begin to sync discuz data to a bak disk"
declare -x DATE=$(date +%Y%m%d)
declare -x BAK_DATA_DIR=/data5/Backup/discuz_mysql
declare -x RUN_DATA_DIR=/home/db
declare -x BAK_DB_PATH=$BAK_DATA_DIR/$DATE
if [ ! -d $BAK_DB_PATH ]; then
  mkdir $BAK_DB_PATH
  chmod 775 $BAK_DB_PATH
else
  chmod 775 $BAK_DB_PATH
fi
rsync -a $RUN_DATA_DIR/ $BAK_DB_PATH &
echo "End of sync."
date

备份Oracle数据库数据：

脚本一：
#!/bin/bash
#desc:clear the bak file of before 14 days ago in every day.
#see:crontab -e
#date:2008.4.24
#author:dougq
export NOW_DATELINE=$(date +%s)
export SECOND_TOTAL=$[24*3600*15]
export BEFORE_DATELINE=$[$NOW_DATELINE-$SECOND_TOTAL]
export BEFORE_NOW_YMD=`date -d '1970-01-01 UTC '$BEFORE_DATELINE' seconds' +%Y%m%d`
export BASE_DIR="/data3/Backup/Oracle/TRSWCM52/old_backup"
export DEL_FILE1="$BASE_DIR/TRSWCM52_Oracle_bak_$BEFORE_NOW_YMD.dmp"
export DEL_FILE2="$BASE_DIR/TRSWCM52_Oracle_bak_$BEFORE_NOW_YMD.log"
export DEL_FILE3="$BASE_DIR/TRSWCM_PLUGINS_Oracle_bak_$BEFORE_NOW_YMD.dmp"
export DEL_FILE4="$BASE_DIR/TRSWCM_PLUGINS_Oracle_bak_$BEFORE_NOW_YMD.log"
if [ -f $DEL_FILE1 ]; then
  rm -rf $DEL_FILE1;
  ＃e cho "$DEL_FILE1 is deleted!"
fi
if [ -f $DEL_FILE2 ]; then
  rm -rf $DEL_FILE2;
  ＃e cho "$DEL_FILE2 is deleted!"
fi
if [ -f $DEL_FILE3 ]; then
  rm -rf $DEL_FILE3;
  ＃e cho "$DEL_FILE3 is deleted!"
fi
if [ -f $DEL_FILE4 ]; then
  rm -rf $DEL_FILE4;
  ＃e cho "$DEL_FILE4 is deleted!"
fi

脚本二
#!/bin/bash
#desc:move the backup dir to a old backup dir and clear this dir prepare to next backup.
#date:2008.04.23
#author:dougq
declare -x WCM_BAK_HOME=/data3/Backup/Oracle/TRSWCM52
cp -Rf $WCM_BAK_HOME/backup/* $WCM_BAK_HOME/old_backup/
rm -Rf $WCM_BAK_HOME/backup/*

脚本三：
#!/bin/bash
#desc:backup wcm plugins data.
#date:2008.04.23
#author:dougq
declare -x ORACLE_BASE=/lun0/oracle
declare -x ORACLE_HOME=$ORACLE_BASE/OraHome1
declare -x ORACLE_SID=HUAWEN
declare -x ORACLE_TERM=xterm
declare -x DATE=$(date +%Y%m%d)
declare -x PATH=$ORACLE_HOME/bin
declare -x WCM_BAK_HOME=/data3/Backup/Oracle/TRSWCM52
declare -x WCM_BAK_DIR=$WCM_BAK_HOME/backup
declare -x WCM_PLUGINS_BAK_NAME=TRSWCM_PLUGINS_Oracle_bak_$DATE.dmp
declare -x WCM_PLUGINS_LOG_NAME=TRSWCM_PLUGINS_Oracle_bak_$DATE.log
exp TRSWCM_PLUGINS/huawentrs log="$WCM_BAK_DIR/$WCM_PLUGINS_LOG_NAME" file="$WCM_BAK_DIR/$WCM_PLUGINS_BAK_NAME" full=n owner=TRSWCM_PLUGINS

脚本四：
#!/bin/bash
#desc:backup wcm data.
#date:2008.04.24
#author:dougq
export ORACLE_BASE=/lun0/oracle
export ORACLE_HOME=$ORACLE_BASE/OraHome1
export ORACLE_SID=HUAWEN
export ORACLE_TERM=xterm
export DATE=$(date +%Y%m%d)
export PATH=$ORACLE_HOME/bin
export WCM_BAK_HOME=/data3/Backup/Oracle/TRSWCM52
export WCM_BAK_DIR=$WCM_BAK_HOME/backup
export WCM_BAK_NAME=TRSWCM52_Oracle_bak_$DATE.dmp
export WCM_LOG_NAME=TRSWCM52_Oracle_bak_$DATE.log
exp TRSWCM52/huawentrs log="$WCM_BAK_DIR/$WCM_LOG_NAME"  file="$WCM_BAK_DIR/$WCM_BAK_NAME" full=n owner=TRSWCM52

UploadFiles/2008-4/429339155.rar