*******************************************************
* Description: Method of terminating RMAN hung session
* Date: 11:41 PM EST, 12/03/2017
*******************************************************

		 
<1> Got the session sid from RMAN log:



<2> Fetching session id via following SQL:
     |
     |__ SQL> select b.sid, b.serial#, a.spid, b.client_info from v$process a, v$session b where a.addr=b.paddr and client_info like 'rman%';
     |
     |
     |__ SQL> alter system kill session '239,46' immediate;
	 
	 

<3> Kill the session from system level:
     | 
     |__ o. "SBT" stands for "Serial Backup Tape". In RMAN associated context, you can config the backup locates on Disk or SBT. 
     |
     |
     |__ SQL> COLUMN EVENT FORMAT a10
              COLUMN SECONDS_IN_WAIT FORMAT 999
              COLUMN STATE FORMAT a20
              COLUMN CLIENT_INFO FORMAT a30
              
              SELECT p.SPID, s.EVENT, s.SECONDS_IN_WAIT AS SEC_WAIT, sw.STATE, CLIENT_INFO 
              FROM V$SESSION_WAIT sw, V$SESSION s, V$PROCESS p 
              WHERE sw.EVENT LIKE 'sbt%' OR sw.EVENT LIKE 'rman%' AND s.SID=sw.SID AND s.PADDR=p.ADDR;