Monitor progress of currently running RMAN backup

 Monitor progress of currently running RMAN backup

select SID,username, opname,to_char(START_TIME,'dd mm yyyy hh:mm:ss'),TOTALWORK, sofar, (sofar/totalwork) * 100 done,TIME_REMAINING/3600/24,
to_char(sysdate + TIME_REMAINING/3600/24,'dd mm yyyy hh:mm:ss') end_at
from v$session_longops
where totalwork > sofar
AND opname NOT LIKE '%aggregate%'
AND opname like 'RMAN%'

To check whether the backup has been completed or not?

SELECT end_time, status, session_key, session_recid, session_stamp,command_id, start_time, time_taken_display, input_type,

output_device_type, input_bytes_display, output_bytes_display,

output_bytes_per_sec_display

FROM v$rman_backup_job_details WHERE end_time = (select max(end_time) from v$rman_backup_job_details)  

To stop/kill the Rman Backup

Find out the sid, serial# from the below query

SELECT p.SPID, s.sid, s.serial#, sw.EVENT, sw.SECONDS_IN_WAIT AS SEC_WAIT, sw.STATE, CLIENT_INFO

FROM V$SESSION_WAIT sw, V$SESSION s, V$PROCESS p

WHERE s.client_info LIKE 'rman%'

AND s.SID=sw.SID

AND s.PADDR=p.ADDR;

once we find the sid and serial#, issue the command on sql prompt

alter system kill session 'sid,serail#'