linux 达梦数据库备份

#!/bin/bash
# DM path
export DM_HOME=/home/dmdba/dmdbms/
export PATH=${DM_HOME}:${PATH}

#需求管理后台文件pofile
backFileDIR=/data/bluesys/bluesys/pofile
#文件服务器地址
fileServiceDIR=/data/bluesys/FileSocketServer/file
#达梦数据库用户名
user=SYSWARE_ORM_340_TEST
#达梦数据库密码
passwd=SYSWARE_ORM_340_TEST
#达梦数据库端口
port=5736
#备份后的目录
backupDIR=/home/dm8/backup
runTime=`date +%Y%m%d_%H%M`
logFile=${backupDIR}/backup_${runTime}.log
deleteTime=7

echo "BACK START"
#删除deleteTime天前的备份文件
find ${backupDIR} -type f -name "*" -ctime +${deleteTime} -exec rm -f {} \; >> ${logFile} 2>&1

mkdir -p  ${backupDIR}/${runTime}/DMback ${backupDIR}/${runTime}/POback ${backupDIR}/${runTime}/fileBack

DMbackPath=${backupDIR}/${runTime}/DMback
PObackPath=${backupDIR}/${runTime}/POback
fileBackPath=${backupDIR}/${runTime}/fileBack
chmod -R 777 DMbackPath PObackPath fileBackPath
echo "DMbackPath:$backFileDIR ,PObackPath:$PObackPath,fileBackPath:$fileBackPath"


echo $DMbackPath

cd ${DM_HOME}/bin

echo "BACK_DM START"

#四种级别：full,owner,schemas,tables
#全库导出full
./dexp ${user}/${passwd}:${port} DIRECTORY=${DMbackPath} FILE=bak_${runTime}.dmp full=y LOG=exp_bak_${runTime}.log   >> ${logFile} 2>&1
echo "BACK_DM end"
echo "BACK_PO START"
tar -cvf  ${PObackPath}/poback.tar ${backFileDIR}/
echo "BACK_PO END"
echo "BACK_FILE START"
tar -cvf  ${fileBackPath}/fileBack.tar ${fileServiceDIR}/ 
echo "BACK_FILE END"

echo "BACK SUCCESS"

给脚本授权

chmod 777 backup.sh

定时启动配置（每周五0点0分以root用户执行backup.sh脚本：

sudo service cron start
vim /etc/crontab
0 */5 * * * dmdba /home/backup.sh
service cron restart