stop rman job by kill rman session

CAUSE: you might want to kill rman job because performance is bad or job is hunging or something else.

1. find rman session as well as sid and serial#

select s.sid ,s.serial#, spid, s.status, s.event, s.program
from v$session s, V$process p
where s.program like '%rman%' and wait_class='System I/O'
and s.paddr = p.addr;


2. kill the session

alter system kill session 'sid,serial#'


3. kill the process on os level if killed session didn't disappear from v$session view.

kill -9 spid


reference:
http://furqansindhu.wordpress.com/2012/02/28/kill-rman-session/