RMAN 查询备份进度

SELECT device_type "Device",
TYPE,
filename,
TO_CHAR (open_time, 'yyyy-mm-dd hh24:mi:ss') open,
TO_CHAR (close_time, 'yyyy-mm-dd hh24:mi:ss') close,
elapsed_time et,
effective_bytes_per_second EPS
FROM v$backup_async_io
WHERE close_time > SYSDATE - 10
ORDER BY close_time DESC;

观察 type 列为 'aggregate' 的 EPS 列值
如果 EPS 列的值远小于备份硬件读写速率值
就应当查找备份进程中的问题