在前面一篇文章中,描述了对当前问题的分析,并简单分析了数据库中未完成的JOB,下面看看导致RMAN无法登陆的原因是否与JOB未完成的原因一致:
bash-3.00$ rman target /
恢复管理器: Release10.2.0.3.0 - Production on星期二5月26 15:30:17 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
在RMAN连接被挂起的时候,看看数据库中的会话在等待什么:
SQL> SELECT PROGRAM, A.SID, LMODE, REQUEST, CTIME, BLOCK
2 FROM V$SESSION A, V$LOCK B
3 WHERE A.SID = B.SID
4 AND A.USERNAME IS NOT NULL;
PROGRAM SID LMODE REQUEST CTIME BLOCK
------------------------------ ---------- ---------- ---------- ---------- ----------
oracle@ahrac1 (J010) 118 3 0 228786 2
oracle@ahrac1 (J010) 118 6 0 228789 2
oracle@ahrac1 (J006) 102 6 0 225186 2
rman@ahrac1 (TNS V1-V3) 52 5 0 171 1
rman@ahrac1 (TNS V1-V3) 52 4 0 171 0
oracle@ahrac1 (J005) 289 3 0 225183 2
oracle@ahrac1 (J005) 289 6 0 225189 2
oracle@ahrac1 (J006) 102 3 0 225165 2
oracle@ahrac1 (J010) 118 3 0 228786 2
oracle@ahrac1 (J010) 118 6 0 228786 2
oracle@ahrac1 (J005) 289 6 0 225183 2
已选择11行。
SQL> SELECT SID, EVENT, P1TEXT, P1, P2TEXT, P2, SECONDS_IN_WAIT
2 FROM V$SESSION
3 WHERE PROGRAM LIKE 'rman%';
SID EVENT P1TEXT P1 P2TEXT P2 SECONDS_IN_WAIT
---------- ---------------------------- ---------- ---------- -------- --- ---------------
52 control file parallel write files 3 block# 813 286
225 SQL*Net message from client driver id 1650815232 #bytes 1 287
查看本栏目更多精彩内容:http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/