问题描述
1) “RMAN备份和恢复I/O” 的event_name的含义是什么，即将数据从磁盘获取到PGA？
2) 如何解释大量的 “RMAN备份和恢复I/O” 和 “TIME_WAITED”，I/O值间歇性为零？
3) 为什么会有一个非零值 “time_wasted”，而其他相应的I/O值都为零？
4) 为什么 “MML写入备份件” 事件也将具有非零的 “RD_IO _ *” 与 “WR_IO _ *” 的零值？
2) 如何解释大量的 “RMAN备份和恢复I/O” 和 “TIME_WAITED”，I/O值间歇性为零？
3) 为什么会有一个非零值 “time_wasted”，而其他相应的I/O值都为零？
4) 为什么 “MML写入备份件” 事件也将具有非零的 “RD_IO _ *” 与 “WR_IO _ *” 的零值？
SAMPLE_TIME EVENT RD_IO_REQ WR_IO_REQ RD_IO_BYTES WR_IO_BYTES TIME_WAITED ---------------------------- ----------------------------------- --------- --------- ------------- ------------- ----------- 16-JUN-21 04.28.45.270 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.28.46.271 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.28.47.272 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.28.48.272 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.28.49.273 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.28.50.274 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.28.51.274 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.28.52.275 AM RMAN backup & recovery I/O 0 0 0 0 28100012 16-JUN-21 04.28.53.275 AM Backup: MML write backup piece 32 0 16777216 0 2211 16-JUN-21 04.28.54.276 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.28.55.276 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.28.56.277 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.28.57.277 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.28.58.278 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.28.59.279 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.00.279 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.01.280 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.02.281 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.03.281 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.04.282 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.05.282 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.06.283 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.07.284 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.08.284 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.09.285 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.10.285 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.11.286 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.12.286 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.13.287 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.14.287 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.15.288 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.16.289 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.17.290 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.18.290 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.19.291 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.20.291 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.21.292 AM RMAN backup & recovery I/O 0 0 0 0 28011851 16-JUN-21 04.29.22.292 AM RMAN backup & recovery I/O 32 0 16777216 0 0 16-JUN-21 04.29.23.293 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.24.293 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.25.294 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.26.295 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.27.295 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.28.296 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.29.296 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.30.297 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.31.308 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.32.308 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.33.309 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.34.310 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.35.310 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.36.311 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.37.311 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.38.312 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.39.312 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.40.313 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.41.314 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.42.314 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.43.315 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.44.315 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.45.316 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.46.317 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.47.318 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.48.318 AM RMAN backup & recovery I/O 0 0 0 0 27666316 16-JUN-21 04.29.49.319 AM Backup: MML write backup piece 16 0 8388608 0 8319 16-JUN-21 04.29.50.320 AM RMAN backup & recovery I/O 16 0 8388608 0 0 16-JUN-21 04.29.51.320 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.52.321 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.53.321 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.54.322 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.55.322 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.56.323 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.57.324 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.58.324 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.29.59.325 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.00.325 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.01.327 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.02.327 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.03.328 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.04.328 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.05.329 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.06.329 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.07.330 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.08.331 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.09.331 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.10.332 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.11.332 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.12.333 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.13.333 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.14.334 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.15.334 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.16.336 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.17.336 AM RMAN backup & recovery I/O 0 0 0 0 27968485 16-JUN-21 04.30.18.337 AM RMAN backup & recovery I/O 32 0 16777216 0 0 16-JUN-21 04.30.19.337 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.20.338 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.21.339 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.22.339 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.23.340 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.24.340 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.25.341 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.26.341 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.27.342 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.28.343 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.29.343 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.30.344 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.31.355 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.32.355 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.33.356 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.34.356 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.35.357 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.36.358 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.37.358 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.38.359 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.39.359 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.40.360 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.41.360 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.42.361 AM RMAN backup & recovery I/O 0 0 0 0 25492225 16-JUN-21 04.30.43.361 AM Backup: MML write backup piece 16 0 8388608 0 6384 16-JUN-21 04.30.44.362 AM RMAN backup & recovery I/O 16 0 8388608 0 0 16-JUN-21 04.30.45.363 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.46.364 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.47.364 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.48.365 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.49.365 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.50.366 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.51.367 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.52.367 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.53.368 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.54.368 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.55.369 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.56.369 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.57.370 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.58.370 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.30.59.371 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.00.372 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.01.373 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.02.373 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.03.374 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.04.374 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.05.375 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.06.376 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.07.376 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.08.377 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.09.377 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.10.378 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.11.378 AM RMAN backup & recovery I/O 0 0 0 0 27961726 16-JUN-21 04.31.12.379 AM RMAN backup & recovery I/O 32 0 16777216 0 0 16-JUN-21 04.31.13.379 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.14.380 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.15.381 AM RMAN backup & recovery I/O 0 0 0 0 0 16-JUN-21 04.31.16.382 AM RMAN backup & recovery I/O 0 0 0 0 0
专家解答
这不是RMAN的事情，而是活跃的会话历史的事情。
可以说我上午9点离开家开车去商店，这要花我 (大约) 13分钟。如果我这样做:
上午9:01，时间 = 1分钟
上午9:02，花费时间 = 2分钟
上午9:03，时间 = 3分钟
上午9:04，花费时间 = 4分钟
....
上午9:13，花费时间 = 13分钟到达
然后，如果我把时间加起来，看起来总时间是98分钟…… 显然不是。所以我们这样记录:
上午9:01，时间 = 0分钟 (运输中)
上午9:02，时间 = 0分钟 (运输中)
上午9:03，时间 = 0分钟 (运输中)
上午9:04，时间 = 0分钟 (运输中)
....
上午9:13，花费时间 = 13分钟到达
这是你在活动会话历史中看到的。仍在进行中的事件记录0。
“RMAN备份和恢复I/O” 是与RMAN对磁盘进行I/O (读取或写入) 有关的任何内容。
就RD与WR而言，备份可能涉及写入 * 和 * 读取，具体取决于备份的类型和/或正在执行的RMAN操作。
其中一些等待看起来很长时间...
可以说我上午9点离开家开车去商店，这要花我 (大约) 13分钟。如果我这样做:
上午9:01，时间 = 1分钟
上午9:02，花费时间 = 2分钟
上午9:03，时间 = 3分钟
上午9:04，花费时间 = 4分钟
....
上午9:13，花费时间 = 13分钟到达
然后，如果我把时间加起来，看起来总时间是98分钟…… 显然不是。所以我们这样记录:
上午9:01，时间 = 0分钟 (运输中)
上午9:02，时间 = 0分钟 (运输中)
上午9:03，时间 = 0分钟 (运输中)
上午9:04，时间 = 0分钟 (运输中)
....
上午9:13，花费时间 = 13分钟到达
这是你在活动会话历史中看到的。仍在进行中的事件记录0。
“RMAN备份和恢复I/O” 是与RMAN对磁盘进行I/O (读取或写入) 有关的任何内容。
就RD与WR而言，备份可能涉及写入 * 和 * 读取，具体取决于备份的类型和/或正在执行的RMAN操作。
其中一些等待看起来很长时间...
文章转载自ASKTOM，如果涉嫌侵权，请发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
