1.查看RMAN分配的各个通道的进程号
select sid,spid,client_info from v$process p,v$session s
where p.addr=s.paddr and client_info like '%rman%';
由查询结果可以看出RMAN分配的两个通道的进程号为108874和108876 .
2.根据1中得到的进程号,终止RMAN备份
注:这里既要kill掉RMAN备份脚本的PID,也要kill掉RMAN中分配的各个通道的PID
$ ps -ef|grep beq
oracle 108870 108864 0 11:37 ? 00:00:01 oraclestudy (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 108873 108864 0 11:37 ? 00:00:00 oraclestudy (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 108874 108864 99 11:37 ? 05:37:17 oraclestudy (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 108876 108864 99 11:37 ? 05:37:02 oraclestudy (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 156818 152189 0 17:15 pts/0 00:00:00 grep --color=auto beq
执行如下命令kill进程:
# kill -9 108874
# kill -9 108876
再次查看,通道已被成功kill:
# ps -ef|grep beq
oracle 108870 108864 0 11:37 ? 00:00:01 oraclestudy (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
oracle 108873 108864 0 11:37 ? 00:00:01 oraclestudy (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
root 158946 158546 0 17:31 pts/2 00:00:00 grep --color=auto beq
【1】:补充内容见附录【1】
查看RMAN备份脚本的PID:
$ ps -ef|grep rman
oracle 108864 108846 0 11:37 ? 00:00:02 rman target / log /backup/rman_log/studyrman_.log append
oracle 155356 152189 0 17:07 pts/0 00:00:00 grep --color=auto rman
执行如下命令kill进程:
# kill -9 108864
再次查询,进程已被kill:
[# ps -ef|grep rman
root 159133 158546 0 17:32 pts/2 00:00:00 grep --color=auto rman
3.效果验证
再次执行如下语句,无结果输出。
select sid,spid,client_info from v$process p,v$session s
where p.addr=s.paddr and client_info like '%rman%';
附录:
【1】此时查看rman分配的各个通道的进程号结果如下
select sid,spid,client_info from v$process p,v$session s
where p.addr=s.paddr and client_info like '%rman%';
拓展阅读