为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
2023-12-04 09:52:49.045 [INFO] dmap_br P0000909288 T0000000000000909288 dmap_br V8
2023-12-04 09:52:49.049 [INFO] dmap_br P0000909288 T0000000000000909288 dmap_br 909288 start with command ./dmap_br 57
2023-12-04 09:52:49.049 [INFO] dmap_br P0000909288 T0000000000000909288 dmap_br open socket 57
2023-12-04 10:22:49.206 [ERROR] dmap_br P0000909288 T0000000000000909288 comm_msg_send failed, errno = 32, desc = Broken pipe
2023-12-04 10:22:49.208 [INFO] dmap_br P0000909288 T0000000000000909288 dmap_br exit successfully
执行热备份
backup database full backupset '/dmdata/dmbak/bakfull_1204';
进行备份校验可返回 1
但是执行定时作业全量备份就失败,定时作业bakfull如下:
call SP_CREATE_JOB('bakfull',1,0,'',0,0,'',0,'');
call SP_JOB_CONFIG_START('bakfull');
call SP_ADD_JOB_STEP('bakfull', 'bak01', 6, '01000000/dmdata/dmbak', 0, 0, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE('bakfull', 'std1', 1, 2, 1, 64, 0, '23:00:00', NULL, '2022-04-01 16:24:06', NULL, '');
call SP_ADD_JOB_SCHEDULE('bakfull', 'once1', 1, 0, 0, 0, 0, NULL, NULL, sysdate+1/1440, NULL, '');
call SP_JOB_CONFIG_COMMIT('bakfull');
这是哪里的问题? 二次执行热备份报错锁超时,用以下语句没发现其他的备份语句
SELECT t1.sql_text, t1.state, t1.trx_id,t1.sess_id,*
FROM v$sessions t1, v$trx t2
WHERE t1.trx_id = t2.id AND t1.state = 'IDLE' AND t2.status = 'ACTIVE';
有什么方法可以查到定时备份作业期间,其他的备份语句吗?
call SP_CREATE_JOB('JOB_FULL_BAK_TIMELY',1,0,'',0,0,'',0,'');
call SP_JOB_CONFIG_START('JOB_FULL_BAK_TIMELY');
call SP_ADD_JOB_STEP('JOB_FULL_BAK_TIMELY', 'JOB_FULL_BAK_TIMELY', 6, '01000000/dmdata/dmbak', 1, 2, 0, 0, NULL, 0);
call SP_ADD_JOB_SCHEDULE('JOB_FULL_BAK_TIMELY', 'JOB_FULL_BAK_TIMELY', 1, 2, 1, 64, 0, '00:06:08', NULL, '2020-07-07 12:06:08', NULL, '');
call SP_JOB_CONFIG_COMMIT('JOB_FULL_BAK_TIMELY');
这个不用