Check RMAN job progress
The below query can be used to identify the progress of any rman job. Either backup or restore.
alter session set nls_date_format='DD-MON-YYYY HH24:MI:SS';
set line 200;
set pages 500;
set long 5000;
select sl.sid, sl.opname,
to_char(100*(sofar/totalwork), '990.9')||'%' pct_done,
sysdate+(TIME_REMAINING/60/60/24) done_by
from v$session_longops sl, v$session s
where sl.sid = s.sid
and sl.serial# = s.serial#
and sl.sid in (select sid from v$session where module like 'backup%' or module like 'restore%' or module like 'rman%')
and sofar != totalwork
and totalwork > 0
/
No comments:
Post a Comment
If you have any queries/ any suggestion please do comment and let me know.