目录
1、如何开启归档
alter database mount; alter database add archivelog 'dest=\dm8\dmbak ,TYPE=local,FILE_SIZE=1024,SPACE_LIMIT=102400'; alter database archivelog; alter database open; |
2、定时备份任务开启
2.1 全量备份定时任务
--全量备份(每周六 23 点全备):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/dmdata/dmbak', 0, 0, 0, 0, NULL, 0); call SP_ADD_JOB_SCHEDULE('bakfull', 'std1', 1, 2, 1, 64, 0, '23:00:00', NULL, '2021-12-01 15:52:22', NULL, ''); call SP_JOB_CONFIG_COMMIT('bakfull'); |
2.2 增量备份定时任务
--增量备份(每周除周六外每天 23 点增量备份): call SP_CREATE_JOB('bakincr',1,0,'',0,0,'',0,''); call SP_JOB_CONFIG_START('bakincr'); call SP_ADD_JOB_STEP('bakincr', 'bak2', 6, '41010000/dmdata/dmbak', 0, 0, 0, 0, NULL, 0); call SP_ADD_JOB_SCHEDULE('bakincr', 'std2', 1, 2, 1, 63, 0, '23:00:00', NULL, '2021-12-01 15:56:30', NULL, ''); call SP_JOB_CONFIG_COMMIT('bakincr'); |