Tuesday, February 27, 2018

RMAN Backup Job Session Kill

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%';

SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK,
ROUND (SOFAR/TOTALWORK*100, 2) "% COMPLETE"
FROM V$SESSION_LONGOPS
WHERE OPNAME LIKE 'RMAN%' AND OPNAME NOT LIKE '%aggregate%'
AND TOTALWORK! = 0 AND SOFAR <> TOTALWORK;

alter system kill session 'sid,serial#' immediate;

alter system kill session '1918,58173' immediate;
alter system kill session '3803,34441' immediate;
alter system kill session '6603,32737' immediate;
alter system kill session '29,50741' immediate;

No comments:

Post a Comment