为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。 【DM版本】:DM8 【操作系统】：centos7.6 【CPU】:64 【问题描述】*：想问下对于生产环境，单实例的达梦8数据库，备份恢复策略有推荐的吗？我刚看了备份还原文档，应该是通过disql进行库的全量备份，之后定期增量备份，恢复的话就用dmrman去恢复。有没有一个更加详细的流程看看呢，完整的步骤等等。
可以设置晚上定时备份，周六全量备份，其余时间增量备份，备份保留1个月，首先要开启归档，定时备份脚本如下：
–作业环境初始化 SP_INIT_JOB_SYS(1) –定时每周六运行，进行全量备份 call SP_CREATE_JOB(‘JOB_FULL_BAK_TIMELY’,1,0,‘’,0,0,‘’,0,‘’); call SP_JOB_CONFIG_START(‘JOB_FULL_BAK_TIMELY’); call SP_ADD_JOB_STEP(‘JOB_FULL_BAK_TIMELY’, ‘定时全量备份’, 6, ‘01000000/dmdata/dmbak’, 1, 2, 0, 0, NULL, 0); call SP_ADD_JOB_SCHEDULE(‘JOB_FULL_BAK_TIMELY’, ‘JOB_FULL_BAK_TIMELY’, 1, 2, 1, 64, 0, ‘00:06:08’, NULL, ‘2020-07-07 12:06:08’, NULL, ‘’); call SP_JOB_CONFIG_COMMIT(‘JOB_FULL_BAK_TIMELY’);
–定时每天运行，进行增量备份(晚上,周六除外) call SP_CREATE_JOB(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’,1,0,‘’,0,0,‘’,0,‘’); call SP_JOB_CONFIG_START(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’); call SP_ADD_JOB_STEP(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’, ‘定时增量备份’, 6, ‘11000000/dmdata/dmbak|/dmdata/dmbak’, 1, 2, 0, 0, NULL, 0); call SP_ADD_JOB_SCHEDULE(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’, ‘JOB_INCREMENT_BAK_TIMELY_NIGHT’, 1, 2, 1, 63, 0, ‘00:08:07’, NULL, ‘2020-07-07 12:08:07’, NULL, ‘’); call SP_JOB_CONFIG_COMMIT(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’);
–定时每周日运行，删除前30天的备份，包括全量和增量 call SP_CREATE_JOB(‘JOB_DEL_BAK_TIMELY’,1,0,‘’,0,0,‘’,0,‘’); call SP_JOB_CONFIG_START(‘JOB_DEL_BAK_TIMELY’); call SP_ADD_JOB_STEP(‘JOB_DEL_BAK_TIMELY’, ‘定时删除备份’, 0, ‘SF_BAKSET_BACKUP_DIR_ADD(’‘DISK’‘,’‘/dmdata/dmbak’‘); CALL SP_DB_BAKSET_REMOVE_BATCH(’‘DISK’‘,SYSDATE - 30);’, 1, 2, 0, 0, NULL, 0); call SP_ADD_JOB_SCHEDULE(‘JOB_DEL_BAK_TIMELY’, ‘JOB_DEL_BAK_TIMELY’, 1, 1, 1, 0, 0, ‘00:10:10’, NULL, ‘2020-07-07 12:13:10’, NULL, ‘’); call SP_JOB_CONFIG_COMMIT(‘JOB_DEL_BAK_TIMELY’);
可以设置晚上定时备份，周六全量备份，其余时间增量备份，备份保留1个月，首先要开启归档，定时备份脚本如下：
–作业环境初始化
SP_INIT_JOB_SYS(1)
–定时每周六运行，进行全量备份
call SP_CREATE_JOB(‘JOB_FULL_BAK_TIMELY’,1,0,‘’,0,0,‘’,0,‘’);
call SP_JOB_CONFIG_START(‘JOB_FULL_BAK_TIMELY’);
call SP_ADD_JOB_STEP(‘JOB_FULL_BAK_TIMELY’, ‘定时全量备份’, 6, ‘01000000/dmdata/dmbak’, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(‘JOB_FULL_BAK_TIMELY’, ‘JOB_FULL_BAK_TIMELY’, 1, 2, 1, 64, 0, ‘00:06:08’, NULL, ‘2020-07-07 12:06:08’, NULL, ‘’);
call SP_JOB_CONFIG_COMMIT(‘JOB_FULL_BAK_TIMELY’);
–定时每天运行，进行增量备份(晚上,周六除外)
call SP_CREATE_JOB(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’,1,0,‘’,0,0,‘’,0,‘’);
call SP_JOB_CONFIG_START(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’);
call SP_ADD_JOB_STEP(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’, ‘定时增量备份’, 6, ‘11000000/dmdata/dmbak|/dmdata/dmbak’, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’, ‘JOB_INCREMENT_BAK_TIMELY_NIGHT’, 1, 2, 1, 63, 0, ‘00:08:07’, NULL, ‘2020-07-07 12:08:07’, NULL, ‘’);
call SP_JOB_CONFIG_COMMIT(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’);
–定时每周日运行，删除前30天的备份，包括全量和增量
call SP_CREATE_JOB(‘JOB_DEL_BAK_TIMELY’,1,0,‘’,0,0,‘’,0,‘’);
call SP_JOB_CONFIG_START(‘JOB_DEL_BAK_TIMELY’);
call SP_ADD_JOB_STEP(‘JOB_DEL_BAK_TIMELY’, ‘定时删除备份’, 0, ‘SF_BAKSET_BACKUP_DIR_ADD(’‘DISK’‘,’‘/dmdata/dmbak’‘);
CALL SP_DB_BAKSET_REMOVE_BATCH(’‘DISK’‘,SYSDATE - 30);’, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(‘JOB_DEL_BAK_TIMELY’, ‘JOB_DEL_BAK_TIMELY’, 1, 1, 1, 0, 0, ‘00:10:10’, NULL, ‘2020-07-07 12:13:10’, NULL, ‘’);
call SP_JOB_CONFIG_COMMIT(‘JOB_DEL_BAK_TIMELY’);