注册

定时备份作业报错Broken pipe

JHSONN 2023/12/04 1047 4

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【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';

有什么方法可以查到定时备份作业期间,其他的备份语句吗?

回答 0
暂无回答
扫一扫
联系客服