达梦数据库开启归档、创建定时备份任务

开启归档

alter database mount;

alter database add archivelog 'dest=/data/dm8/dmdba/dmdata/DAMENG/arch ,TYPE=local,FILE_SIZE=2048,SPACE_LIMIT=102400';

alter database archivelog;

alter database open;

创建作业环境

SP_INIT_JOB_SYS(1);

全量备份（每周六凌晨1点）

call SP_CREATE_JOB('bakfull',1,0,'',0,0,'',0,'定时全量备份');
call SP_JOB_CONFIG_START('bakfull');
call SP_ADD_JOB_STEP('bakfull', 'bak1', 6, '01020000/data/dm8/dmdba/dmdata/DAMENG/bak', 0, 0, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE('bakfull', 'std1', 1, 2, 1, 64, 0, '1:00:00', NULL, '2023-10-31 9:37:22', NULL, '');
call SP_JOB_CONFIG_COMMIT('bakfull');

增量备份（除每周六，每天凌晨1点）

call SP_CREATE_JOB('JOB_INCREMENT_BAK_TIMELY',1,0,'',0,0,'',0,'定时增量备份');
call SP_JOB_CONFIG_START('JOB_INCREMENT_BAK_TIMELY');
call SP_ADD_JOB_STEP('JOB_INCREMENT_BAK_TIMELY', 'STEP_INCREMENT_BAK', 6, '11000000/data/dm8/dmdba/dmdata/DAMENG/bak|/data/dm8/dmdba/dmdata/DAMENG/bak', 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE('JOB_INCREMENT_BAK_TIMELY', 'SCHEDULE_INCREMENT_BAK', 1, 2, 1, 63, 0, '1:00:00', NULL, '2023-10-31 9:37:22', NULL, '');
call SP_JOB_CONFIG_COMMIT('JOB_INCREMENT_BAK_TIMELY');

定时删除备份（每天 1：30 删除 15 天前备份）

call SP_CREATE_JOB('delbak',1,0,'',0,0,'',0,'');
call SP_JOB_CONFIG_START('delbak');
call SP_ADD_JOB_STEP('delbak','bak1',0, 'SF_BAKSET_BACKUP_DIR_ADD(''DISK'',''/data/dm8/dmdba/dmdata/DAMENG/bak'');
call sp_db_bakset_remove_batch(''DISK'',now()-15);', 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE('delbak', 'del01', 1, 1, 1, 0, 0, '1:30:00', NULL, '2023-10-31 9:37:27', NULL, '');
call SP_JOB_CONFIG_COMMIT('delbak');