####自定义脚本配置定时任务,定期备份达梦数据库,定期清理历史备份集###
vi /dm8/backup/bak_dm.sh
####bak_dm.sh脚本起始###
#/bin/bash
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/dm8/bin"
export DM_HOME="/dm8"
export PATH=$PATH:$DM_HOME/bin:$DM_HOME/tool
#当天年月日
CUR_DATE=`date +'%Y%m%d%H%M%S'`
#获取当天是星期几
WEEKDAY_INDEX=`date +'%w'`
#逻辑备份全库
dexp sysdba/***@localhost:5236 file=dexp_${CUR_DATE}.dmp directory=/dm8/backup/dmp log=dexp_${CUR_DATE}.log full=y
#在线物理备份全库、归档日志,每周六全量备份,其他日期增量备份。同时删除30天前的历史备份集
if [[ $WEEKDAY_INDEX -eq 6 ]]; then
disql sysdba/***@localhost:5236<<EOF
backup database full backupset '/dm8/backup/full/dmdb01_full_${CUR_DATE}';
SF_BAKSET_BACKUP_DIR_ADD('DISK','/dm8/backup/full');
call sp_db_bakset_remove_batch('DISK',now()-30);