kill rman shell script

cat /etc/oratab|grep '/opt/oracle/product'|grep -v '*'|grep -v '#'|grep -v DG|grep -v agent|awk -F: ' { print $1 }'|while read line
do
. oraenv<<EOF
$line
EOF
echo "**************************************************"
sqlplus -s '/as sysdba'<<!
select 'alter system kill session '''||s.sid||','||s.serial#||''' immediate;'FROM v\$process a, v\$session s where a.addr=s.paddr and client_info like 'rman%';
!
echo "**************************************************"
done


++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

manual :-


select 'alter system kill session '''||s.sid||','||s.serial#||''' immediate;'FROM v$session s, v$process p WHERE s.paddr = p.addr and s.program like '%rman';

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

select 'alter system kill session '''||s.sid||','||s.serial#||''' immediate;'FROM v$process a, v$session s where a.addr=s.paddr and client_info like 'rman%';


select b.sid, b.serial#, a.spid, b.client_info, b.program, b.logon_time  from v$process a, v$session b where a.addr=b.paddr and client_info like 'rman%';

Comments

Popular posts from this blog

finding fragmentation at table level and tablespace level in Oracle and steps to remove them

Oracle Custom Procedure for defragmentation Partition tables and their associated index and move non partitioned table

Installing DBMS_JAVA package in Oracle and calling UTL_DBWS web services through Oracle database