oraclerac重启分析

《oraclerac重启分析》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、Oraclerac重启分析一.故障现象Oraclerac刚开始半个月两节点交替重启，目前2天就重启,并且重启的时候没有什么高负载二.环境介绍两台oraclelinux64位系统，10.2.0.564位系统，存储为DELLps6000[oracle@dbasc1~]$oifcfggetifeth030.30.0.0globalpubliceth1192.168.0.0globalcluster_interconnecteth210.10.0.0globalcluster_interconnecteth410.10.0.0globalcluster_interconnectSQL>select*

2、fromGV$CONFIGURED_INTERCONNECTS;INST_IDNAMEIP_ADDRESSIS_PUBLICSOURCE---------------------------------------------------------------------------------2eth1192.168.0.2NOOracleClusterRepository2eth210.10.10.102NOOracleClusterRepository2eth410.10.10.103NOOracleClusterRepository2eth030.30.30.20YESOracle

3、ClusterRepository1eth1192.168.0.1NOOracleClusterRepository1eth210.10.10.100NOOracleClusterRepository1eth410.10.10.101NOOracleClusterRepository1eth030.30.30.10YESOracleClusterRepository8rowsselectedSQL>selectINST_ID,PUB_KSXPIA,PICKED_KSXPIA,NAME_KSXPIA,IP_KSXPIA2fromx$ksxpia;INST_IDPUB_KSXPIAPICKED_

4、KSXPIANAME_KSXPIAIP_KSXPIA--------------------------------------------------------------------------------------1NOCReth1192.168.0.11NOCReth210.10.10.1001NOCReth410.10.10.1011YOCReth030.30.30.10SQL>oradebugsetmypidSQL>oradebugipcTrace如下;/u01/app/oracle/admin/asc/udump/asc1_ora_5396.trcOracleDatabas

5、e10gEnterpriseEditionRelease10.2.0.5.0-64bitProductionWiththePartitioning,RealApplicationClusters,OLAP,DataMiningandRealApplicationTestingoptionsORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1Systemname:LinuxNodename:dbasc1Release:2.6.18-194.el5xenVersion:#1SMPMonMar2922:22:00EDT2010Machine:x86_64I

6、nstancename:asc1Redothreadmountedbythisinstance:1Oracleprocessnumber:46Unixprocesspid:5396,image:oracle@dbasc1(TNSV1-V3)***2011-12-0211:10:49.327***ACTIONNAME:()2011-12-0211:10:49.327***MODULENAME:(sqlplus@dbasc1(TNSV1-V3))2011-12-0211:10:49.327***SERVICENAME:(SYS$USERS)2011-12-0211:10:49.327***SES

7、SIONID:(3244.1653)2011-12-0211:10:49.327Dumpofunix-genericskgmcontextareaflags000000e7realmflags0000000fmapsize00000800protectsize00001000lcmsize00001000seglen00008000largestsize0000040000000000smallestsize