From the below query, you can check how much RMAN backup completed in %.
set echo on timing on
set lines 200
col username format a10
col OPNAME format a35
col SOFAR format 999,999,999
col TOTALWORK format 999,999,999
col 'Work Done %' format 999.99
col Start_time format a20
select SID,username,OPNAME,SOFAR,TOTALWORK,SOFAR/TOTALWORK*100 "Work Done %",
to_char(START_TIME,'DD-MON-YY hh24:mi:ss') "Start_time",
to_char(sysdate + TIME_REMAINING/3600/24,'DD-MON-YY hh24:mi:ss') "End_at"
from v$session_longops
where sofar!=TOTALWORK and totalwork!=0
and OPNAME like 'RMAN%';
set lines 200
col username format a10
col OPNAME format a35
col SOFAR format 999,999,999
col TOTALWORK format 999,999,999
col 'Work Done %' format 999.99
col Start_time format a20
select SID,username,OPNAME,SOFAR,TOTALWORK,SOFAR/TOTALWORK*100 "Work Done %",
to_char(START_TIME,'DD-MON-YY hh24:mi:ss') "Start_time",
to_char(sysdate + TIME_REMAINING/3600/24,'DD-MON-YY hh24:mi:ss') "End_at"
from v$session_longops
where sofar!=TOTALWORK and totalwork!=0
and OPNAME like 'RMAN%';
No comments:
Post a Comment