杀死挂起的 RMAN 会话

￡神魔★判官ぃ 2023-10-01 08:02 10阅读 0赞

有时您可能需要终止挂起且没有响应的 RMAN 会话。为此，您有两个选择。第一个选项是使用 alter system kill session 命令。您需要从 v$process 和 v$sessions 视图中获取 sid 和 serial\# 值。请参阅以下示例：

1. 连接到 RMAN 并运行备份数据库命令：

RMAN> backup database;

2. 使用以下查询获取已连接 RMAN 会话的 sid 和 serial\# 值：

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

SID SERIAL\# SPID CLIENT\_INFO  
\---------- ---------- ------------ ---------------------------------  
141 22 976 rman channel=ORA\_DISK\_1

3. 使用 alter system kill session 命令终止正在运行的备份会话：

SQL>  
alter  
system kill session '141,22' immediate;  
system altered.  
SQL>

终止会话后，您会在 RMAN 输出中收到以下消息：

input datafile fno=00004  
name=C:\\ORACLE\\PRODUCT\\10.2.0\\ORADATA\\TEST\\USERS01.DBF  
channel ORA\_DISK\_1: starting piece 1 at 20-JUL-10  
RMAN-03009: failure of backup command on ORA\_DISK\_1 channel at 07/20/2010  
18:47:39  
ORA-00028: your session has been killed  
ORA-00028: your session has been killed  
continuing other job steps, job failed will not be re-run  
RMAN-00571: ===========================================================  
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============  
RMAN-00571: ===========================================================  
RMAN-03009: failure of backup command on ORA\_DISK\_1 channel at 07/20/2010  
18:47:39  
ORA-00028: your session has been killed  
ORA-00028: your session has been killed  
RMAN>  
  
您也可以直接从 OS 中杀死 RMAN 会话。请参阅以下示例。在这里，您备份数据库并从操作系统获取 RMAN 进程的进程 ID，然后使用 kill -9 命令将其杀死：

RMAN> backup database plus archivelog;  
\[oracle@locahost ~\]$ ps -ef | grep rman  
oracle 4669 4513 3 01:28 pts/1 00:00:00 rman target /  
oracle 4712 4689 0 01:28 pts/2 00:00:00 grep rman  
\[oracle@locahost ~\]$ kill -9 4669  
\[oracle@locahost ~\]$

终止会话后，您会从 RMAN 获得以下输出：

input datafile fno=00004  
name=/u01/oracle/product/10.2.0/db\_1/oradata/db3/users01.dbf  
channel ORA\_DISK\_1: starting piece 1 at 19-JUL-10  
Killed