ANBOB™

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

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%';

打赏

微信扫一扫，打赏作者吧～