DM逻辑备份

1、编辑环境变量

vi ~/.bash_profile

[dmdba@mydm ~]$ cat .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:/dm/dbms/bin"

export DM_HOME="/dm/dbms"

添加以下内容

DM_HOME=/dm/dbms

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:${DM_HOME}/bin

export PATH=$PATH:${DM_HOME}/bin

2、编写shell脚本

[dmdba@mydm dm]$ cat backup.sh

##定义变量文件名

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

##导出用户TEST的数据

dexp SYSDBA/SYSDBA owner=SYSDBA directory=/dm/bak/ file=$d-%U.dmp log=$d.log parallel=4

##压缩备份文件和日志文件

tar zcvf /dm/bak/$(date '+%y%m%d')_TEST.tar.gz /dm/bak/*_TEST*.dmp /dm/bak/*_TEST*.log --remove-files

##保存7天备份文件，删除6天之前备份

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

赋予脚本执行权限

[dmdba@mydm ~]$chmod +x /dm/bak/backup.sh

3、编写定时任务

[dmdba@mydm ~]$ crontab -l

00 00 * * * /dm/backup.sh

全量备份 + 增量备份 + 删除

此备份策略适用于数据量大于 100G 并且小于 3T 的场景下。注意开启数据库归档，确定备份路径。

—设置 2 分钟后自动进行一次全量备份

call SP_INIT_JOB_SYS(1);

call SP_CREATE_JOB('bakall_one',1,0,'',0,0,'',0,'执行一次全量备份');

call SP_JOB_CONFIG_START('bakall_one');

call SP_ADD_JOB_STEP('bakall_one', 'bakall', 6, '01020000/opt/dmdbms/data/DAMENG/bak/all', 1, 1, 0, 0, NULL, 0);

call SP_ADD_JOB_SCHEDULE('bakall_one', 'bakall_one_time01', 1, 0, 0, 0, 0, NULL, NULL, SYSDATE()+0.0014, NULL, '');

call SP_JOB_CONFIG_COMMIT('bakall_one');

--设置全量备份

call SP_CREATE_JOB('bakall',1,0,'',0,0,'',0,'每月第一个周六23:00全量备份');

call SP_JOB_CONFIG_START('bakall');

call SP_ADD_JOB_STEP('bakall', 'bakall', 6, '01020000/opt/dmdbms/data/DAMENG/bak/all', 1, 1, 0, 0, NULL, 0);

call SP_ADD_JOB_SCHEDULE('bakall', 'bakall_time01', 1, 4, 1, 7, 0, '23:00:00', NULL, '2019-01-01 01:01:01', NULL, '');

call SP_JOB_CONFIG_COMMIT('bakall');

--设置增量备份 + 删除备份

call SP_CREATE_JOB('bakadd_delbak',1,0,'',0,0,'',0,'每天(除周六)23:00增量备份、删除30天前的增量备份、删除40天前的全量备份');

call SP_JOB_CONFIG_START('bakadd_delbak');

call SP_ADD_JOB_STEP('bakadd_delbak', 'bakadd', 6, '11020000/opt/dmdbms/data/DAMENG/bak/all|/opt/dmdbms/data/DAMENG/bak/add', 3, 1, 0, 0, NULL, 0);

call SP_ADD_JOB_STEP('bakadd_delbak', 'delbak', 0, 'SF_BAKSET_BACKUP_DIR_ADD(''DISK'',''/opt/dmdbms/data/DAMENG/bak/add'');

CALL SP_DB_BAKSET_REMOVE_BATCH(''DISK'',SYSDATE-30);

SF_BAKSET_BACKUP_DIR_ADD(''DISK'',''/opt/dmdbms/data/DAMENG/bak/all'');

CALL SP_DB_BAKSET_REMOVE_BATCH(''DISK'',SYSDATE-40);', 1, 1, 0, 0, NULL, 0);

call SP_ADD_JOB_SCHEDULE('bakadd_delbak', 'bakadd_delbak_time01', 1, 2, 1, 63, 0, '23:00:00', NULL, '2019-01-01 01:01:01', NULL, '');

call SP_JOB_CONFIG_COMMIT('bakadd_delbak');