DM添加备份任务

先创建代理-代理环境-系统过程

建个全备作业

 

作业

 

 

需要提前建个备份目录

 

 

 

 

 DDL语句

call SP_CREATE_JOB('full_bak',1,0,'',0,0,'',0,'');

call SP_JOB_CONFIG_START('full_bak');

call SP_ADD_JOB_STEP('full_bak', 'full_bak01', 6, '00000000/home/dmdba/data/bak', 1, 1, 0, 0, NULL, 0);

call SP_ADD_JOB_SCHEDULE('full_bak', 'full_bak02', 1, 2, 1, 1, 0, '01:00:00', NULL, '2023-07-21 16:21:33', NULL, '');

call SP_JOB_CONFIG_COMMIT('full_bak');

删除备份

与全备不同是这里是sql脚本

 

 SF_BAKSET_BACKUP_DIR_ADD('DISK','/home/dmdba/data/bak');
SP_DB_BAKSET_REMOVE_BATCH(NULL,SYSDATE-30);

 保留30天，目录需要保留

频率需要是每天

DDL语句

call SP_CREATE_JOB('delete_bak',1,0,'',0,0,'',0,'');

call SP_JOB_CONFIG_START('delete_bak');

call SP_ADD_JOB_STEP('delete_bak', 'delete_bak01', 0, 'SF_BAKSET_BACKUP_DIR_ADD(''DISK'',''/home/dmdba/data/bak'');
SP_DB_BAKSET_REMOVE_BATCH(NULL,SYSDATE-30);', 1, 1, 0, 0, NULL, 0);

call SP_ADD_JOB_SCHEDULE('delete_bak', 'delete_02', 1, 1, 1, 0, 0, '02:00:00', NULL, '2023-07-21 16:28:42', NULL, '');

call SP_JOB_CONFIG_COMMIT('delete_bak');