December 31, 2024

How to check RMAN progress?

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.

Recent Post

Oracle Memory usage Queries

Some Important Oracle database Memory management queries. SGA usage by Oracle Instance: select  round(sum(bytes)/1024/1024,2)||' MB'...