达梦逻辑导出备份简易参考

用dmdba用户登录

vi /bak/dmbak.sh

 脚本内容

#!/bin/bash
source /home/dmdba/.bash_profile

d=prod_$(date '+%y%m%d')

dexp SYSDBA/SYSDBA owner=bi,ploan,app directory=/bak/ file=$d-%U.dmp log=$d.log parallel=4

tar zcvf /bak/$d.tar.gz /bak/$d-*.dmp /bak/$d.log --remove-files

find /bak/ -mtime +8 -name "*.tar.gz" -exec rm -rf {} \;

 设置权限

chmod +x /bak/dmbak.sh

 设置计划任务

30 20 * * * /bak/dmbak.sh