2020年dm8定时自动备份与删除备份

1 环境介绍

• dm8.1-1-126-2020.09.04-126608-SEC
• dm8.1-1-144-2020.10.27-SEC
• cpu arm

2 sql 创建作业

--配置归档
ALTER DATABASE MOUNT;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE ADD ARCHIVELOG 'DEST=/opt/dmdba/dmdata/dmarch,TYPE=LOCAL,FILE_SIZE=2048,SPACE_LIMIT=204800';
ALTER DATABASE OPEN;--手动备份测试
CHECKPOINT(100);
BACKUP DATABASE COMPRESSED;--开启代理环境
SP_INIT_JOB_SYS(1);--每天22点全量备份数据库
call SP_CREATE_JOB('BAK_FULL',1,0,'',0,0,'',0,'');
call SP_JOB_CONFIG_START('BAK_FULL');
call SP_ADD_JOB_STEP('BAK_FULL', 'BAK_FULL', 5, '01000', 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE('BAK_FULL', 'BAK_FULL', 1, 1, 1, 0, 0, '22:17:56', NULL, '2023-12-15 17:17:56', NULL, '');
call SP_JOB_CONFIG_COMMIT('BAK_FULL');--删除16天前的备份文件
call SP_CREATE_JOB('BAK_DEL',1,0,'',0,0,'',0,'');
call SP_JOB_CONFIG_START('BAK_DEL');
call SP_ADD_JOB_STEP('BAK_DEL', 'BAK_DEL', 0, 'CALL SP_DB_BAKSET_REMOVE_BATCH(''DISK'', NOW()-16);', 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE('BAK_DEL', 'BAK_DEL', 1, 1, 1, 0, 0, '02:20:39', NULL, '2023-12-15 17:20:39', NULL, '');
call SP_JOB_CONFIG_COMMIT('BAK_DEL');