达梦数据库手工作业备份的方法

最新推荐文章于 2025-06-07 11:00:04 发布

dmdba1

最新推荐文章于 2025-06-07 11:00:04 发布

阅读量571

点赞数

CC 4.0 BY-SA版权

分类专栏：达梦数据库

本文链接：https://blog.youkuaiyun.com/fengxiaozhenjay/article/details/104997613

达梦数据库专栏收录该内容

171 篇文章

订阅专栏

本文详细介绍了在达梦数据库中如何通过定时任务实现全量与增量备份，以及定期清理旧备份和归档日志的过程。具体步骤包括创建定时作业、配置作业参数、设置作业调度等。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

–开启定时任务进行定时备份和定时删除
SP_INIT_JOB_SYS(1); --开启代理作业

–※定时备份中的路径设置为备份路径，要保持和数据目录不同，同时dm.ini参数中BAK_PATH必须和定时备份路径一致，不一致将导致定时删除备份会失败

–定时每周六运行，进行全量备份
–call SP_DROP_JOB(‘JOB_FULL_BAK_TIMELY’);
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’, ‘STEP_FULL_BAK’, 5, ‘01000C:\DMDBMS\DATA\BAK’, 1, 2, 0, 0, NULL, 0); --BAK1备份
–call SP_ADD_JOB_STEP(‘JOB_FULL_BAK_TIMELY’, ‘STEP_FULL_BAK’, 6, ‘01001000C:\DMDBMS\DATA\BAK’, 1, 2, 0, 0, NULL, 0); --BAK2备份，备份集方式备份
–call SP_ADD_JOB_STEP(‘JOB_FULL_BAK_TIMELY’, ‘STEP_FULL_BAK’, 5, ‘01000/opt/dmdbms/data/bak’, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(‘JOB_FULL_BAK_TIMELY’, ‘SCHEDULE_FULL_BAK’, 1, 2, 1, 64, 0, ‘00:05:56’, NULL, ‘2020-03-20 21:05:57’, NULL, ‘’);
call SP_JOB_CONFIG_COMMIT(‘JOB_FULL_BAK_TIMELY’);

–定时每天运行，进行增量备份(晚上,周六除外)
–call SP_DROP_JOB(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’);
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’, ‘STEP_INCREMENT_BAK’, 5, ‘11000C:\DMDBMS\DATA\BAK|C:\DMDBMS\DATA\BAK’, 1, 2, 0, 0, NULL, 0); --BAK1备份
–call SP_ADD_JOB_STEP(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’, ‘STEP_INCREMENT_BAK’, 6, ‘11001000C:\dmdbms\data\BAK|C:\DMDBMS\DATA\BAK’, 1, 2, 0, 0, NULL, 0); --BAK2备份，备份集方式备份
–call SP_ADD_JOB_STEP(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’, ‘STEP_INCREMENT_BAK’, 5, ‘11000/opt/dmdbms/data/bak|/opt/dmdbms/data/bak’, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’, ‘SCHEDULE_INCREMENT_BAK’, 1, 2, 1, 63, 0, ‘01:05:56’, NULL, ‘2020-03-20 21:05:57’, NULL, ‘’);
call SP_JOB_CONFIG_COMMIT(‘JOB_INCREMENT_BAK_TIMELY_NIGHT’);

–定时每天运行，进行增量备份(白天)
–call SP_DROP_JOB(‘JOB_INCREMENT_BAK_TIMELY_DAY’);
call SP_CREATE_JOB(‘JOB_INCREMENT_BAK_TIMELY_DAY’,1,0,’’,0,0,’’,0,‘定时增量备份’);
call SP_JOB_CONFIG_START(‘JOB_INCREMENT_BAK_TIMELY_DAY’);
call SP_ADD_JOB_STEP(‘JOB_INCREMENT_BAK_TIMELY_DAY’, ‘STEP_INCREMENT_BAK’, 5, ‘11000C:\DMDBMS\DATA\BAK|C:\DMDBMS\DATA\BAK’, 1, 2, 0, 0, NULL, 0);
–call SP_ADD_JOB_STEP(‘JOB_INCREMENT_BAK_TIMELY_DAY’, ‘STEP_INCREMENT_BAK’, 6, ‘11001000C:\dmdbms\data\BAK|C:\DMDBMS\DATA\BAK’, 1, 2, 0, 0, NULL, 0); --BAK2备份，备份集方式备份
–call SP_ADD_JOB_STEP(‘JOB_INCREMENT_BAK_TIMELY_DAY’, ‘STEP_INCREMENT_BAK’, 5, ‘11000/opt/dmdbms/data/bak|/opt/dmdbms/data/bak’, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(‘JOB_INCREMENT_BAK_TIMELY_DAY’, ‘SCHEDULE_INCREMENT_BAK’, 1, 1, 1, 0, 0, ‘12:05:56’, NULL, ‘2020-03-20 21:05:57’, NULL, ‘’);
call SP_JOB_CONFIG_COMMIT(‘JOB_INCREMENT_BAK_TIMELY_DAY’);

–定时每周日运行，删除前30天的备份，包括全量和增量
–call SP_DROP_JOB(‘JOB_DEL_BAK_TIMELY’);
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’, ‘STEP_DEL_BAK’, 0, ‘SP_BATCH_DEL_BAK(’‘DAMENG’’, ‘’’’, 1, sysdate-30, -1);’, 1, 2, 0, 0, NULL, 0); --BAK1备份
–call SP_ADD_JOB_STEP(‘JOB_DEL_BAK_TIMELY’, ‘STEP_DEL_BAK’, 0, ‘SP_DB_BAKSET_REMOVE_BATCH(NULL,SYSDATE-30);’, 1, 2, 0, 0, NULL, 0); --BAK2备份，备份集方式的备份
call SP_ADD_JOB_SCHEDULE(‘JOB_DEL_BAK_TIMELY’, ‘SCHEDULE_DEL_BAK’, 1, 2, 1, 1, 0, ‘00:05:56’, NULL, ‘2020-03-20 21:05:57’, NULL, ‘’);
call SP_JOB_CONFIG_COMMIT(‘JOB_DEL_BAK_TIMELY’);

–定时每周日运行，删除前30天的归档日志
–call SP_DROP_JOB(‘JOB_DEL_ARCH_TIMELY’);
call SP_CREATE_JOB(‘JOB_DEL_ARCH_TIMELY’,1,0,’’,0,0,’’,0,‘定时删除备份’);
call SP_JOB_CONFIG_START(‘JOB_DEL_ARCH_TIMELY’);
call SP_ADD_JOB_STEP(‘JOB_DEL_ARCH_TIMELY’, ‘STEP_DEL_ARCH’, 0, ‘SF_ARCHIVELOG_DELETE_BEFORE_TIME(SYSDATE - 30);’, 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE(‘JOB_DEL_ARCH_TIMELY’, ‘SCHEDULE_DEL_ARCH’, 1, 2, 1, 1, 0, ‘00:05:56’, NULL, ‘2020-03-20 21:05:57’, NULL, ‘’);
call SP_JOB_CONFIG_COMMIT(‘JOB_DEL_ARCH_TIMELY’);