AIX5.3下两节点RAC环境,数据库版本为10.2.0.4。实例2主机突然异常重启,按照常理来说,实例1需要进行集群重构接管实例2上的相关资源然后正常对外访问,这次问题就出现在实例2主机挂掉以后,实例1访问异常缓慢,而且使用sqlplus连接数据库的时候报错:NFS server lndb02 not responding still trying
两个节点的归档日志是采用NFS方式互相挂载到节点主机上的,实例2主机挂掉以后相应的归档目录自然也就无法访问,难道说因为NFS无法访问还能导致实例1的数据库也出现问题?冷静的想一想,这个不太可能。于是百度了一下,也找到了解决方法:
oracle@lndb01$[/oracle/admin/orcl/bdump]sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Sun Sep 22 10:06:48 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
NFS server lndb02 not responding still trying
Disconnected
oracle@lndb01$[/home/oracle]
oracle@lndb01$[/home/oracle]
oracle@lndb01$[/home/oracle]crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....01.lsnr application ONLINE ONLINE lndb01
ora.lndb01.gsd application ONLINE ONLINE lndb01
ora.lndb01.ons application ONLINE ONLINE lndb01
ora.lndb01.vip application ONLINE ONLINE lndb01
ora....02.lsnr application ONLINE OFFLINE
ora.lndb02.gsd application ONLINE OFFLINE
ora.lndb02.ons application ONLINE OFFLINE
ora.lndb02.vip application ONLINE ONLINE lndb01
ora.orcl.db application ONLINE ONLINE lndb01
ora....l1.inst application ONLINE ONLINE lndb01
ora....l2.inst application ONLINE OFFLINE
oracle@lndb01$[/home/oracle]
oracle@lndb01$[/oracle]
oracle@lndb01$[/oracle]export HOME=/oracle/app/oracle
oracle@lndb01$[/oracle]sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Sun Sep 22 09:58:17 2013
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn / as sysdba
NFS server lndb02 not responding still trying
NFS server lndb02 ok
Connected.
SQL>
SQL>
SQL>
SQL> desc v$log;
Name Null? Type
----------------------------------------- -------- ----------------------------
GROUP# NUMBER
THREAD# NUMBER
SEQUENCE# NUMBER
BYTES NUMBER
MEMBERS NUMBER
ARCHIVED VARCHAR2(3)
STATUS VARCHAR2(16)
FIRST_CHANGE# NUMBER
FIRST_TIME DATE
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26753337/viewspace-772991/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26753337/viewspace-772991/