首页 » ORACLE 9i-23ai » Scripts: How to Check RMAN Restore Progress in Oracle Database

Scripts: How to Check RMAN Restore Progress in Oracle Database

  • 2021/12/14
  • ORACLE 9i-23ai
  • 200 views
  • Scripts: How to Check RMAN Restore Progress in Oracle Database已关闭评论

下面是要在目标数据库或数据库辅助上执行的查询，以估计恢复的时间和完成的百分比。

column FILENAME format a70
select sid,serial,filename,status,bytes/total_bytes*100 "Completed",EFFECTIVE_BYTES_PER_SECOND/1024/1024 "MB/S" from
V$BACKUP_ASYNC_IO where type = 'OUTPUT' and bytes<>0 order by status;

--or 

col OPNAME for a30
select OPNAME,SOFAR/TOTALWORK*100 PCT, trunc(TIME_REMAINING/60) MIN_RESTANTES,
trunc(ELAPSED_SECONDS/60) MIN_ATEAGORA
from v$session_longops where TOTALWORK>0 and OPNAME like '%RMAN%';
打赏

对不起，这篇文章暂时关闭评论。

上一篇：

下一篇：