达梦数据备份还原及定时操作

1、先开启数据库归档

路径：/dm8/arch
设置大小：128

2、 库备份

先执行checkpoint(100)；

备份名称：FULL_BACK
备份路径：/dm8/backup/FULL_BACK

数据库定时备份

3、新建作业

JOB1
JOB2

新建JOB1

call SP_CREATE_JOB(‘JOB1’,1,0,‘’,0,0,‘’,0,‘’);

call SP_JOB_CONFIG_START(‘JOB1’);

call SP_ADD_JOB_STEP(‘JOB1’, ‘JOB1’, 6, ‘00000000/dm8/backup’, 0, 0, 0, 0, NULL, 0);

call SP_ADD_JOB_SCHEDULE(‘JOB1’, ‘JOB1’, 1, 2, 1, 9, 0, ‘23:00:00’, NULL, ‘2022-11-28 01:41:01’, NULL, ‘’);

call SP_JOB_CONFIG_COMMIT(‘JOB1’);

新建JOB2

call SP_CREATE_JOB(‘JOB2’,1,0,‘’,0,0,‘’,0,‘’);

call SP_JOB_CONFIG_START(‘JOB2’);

call SP_ADD_JOB_STEP(‘JOB2’, ‘JOB2’, 6, ‘40000000/dm8/backup|/dm8/backup’, 0, 0, 0, 0, NULL, 0);

call SP_ADD_JOB_SCHEDULE(‘JOB2’, ‘job2’, 1, 2, 1, 118, 0, ‘23:00:00’, NULL, ‘2022-11-26 19:00:11’, NULL, ‘’);

call SP_JOB_CONFIG_COMMIT(‘JOB2’);