******************************************************* * 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;
Your Comments