查看 RMAN 分配的各个通道的进程号

select s.sid, s.serial#, p.spid, s.client_info    from v$process p, v$session s

where p.addr = s.paddr    and s.program   like   '%rman%'   ;  

SID    SERIAL# SPID                     CLIENT_INFO

---------- ---------- ------------------------ ----------------------------------------------------------------

        89      64899 5157

       107      49576 5170

        96      39108 5172                     rman channel=ORA_DISK_1

根据第上面步骤中得到的进程号，终止 RMAN 备份

注：这里既要 kill  掉 RMAN 备份脚本的 PID ，也要 kill  掉 RMAN 中分配的各个通道的 PID

[root@asmdb ~]# ps -ef | grep beq

oracle    1918     1  0 Jul10 ?        00:00:09 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle   15790     1  0 08:53 ?        00:00:00 oracle+ASM (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle   15892 15885  1 08:57 ?        00:00:00 oracleasmdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle   15897 15885  1 08:57 ?        00:00:00 oracleasmdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle   15898 15885  1 08:57 ?        00:00:00 oracleasmdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle   15899 15885  2 08:57 ?        00:00:00 oracleasmdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle   15900 15885  2 08:57 ?        00:00:00 oracleasmdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

oracle   15901 15885  5 08:57 ?        00:00:00 oracleasmdb (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

root     15903 15823  0 08:57 pts/3    00:00:00 grep beq

[root@asmdb ~]# kill -9 15898

[root@asmdb ~]# kill -9 15899

[root@asmdb ~]# kill -9 15900

[root@asmdb ~]# kill -9 15901

[root@asmdb ~]# ps -ef | grep rman

oracle   15885 15740  1 08:57 pts/2    00:00:02 rman target /

root     15926 15823  0 09:01 pts/3    00:00:00 grep rman

[root@asmdb ~]# kill -9  15885