Oracle小型机日常巡检

Oracle小型机日常巡检企业的业务数据库系统是IT运维的重中之重，为使数据库长期稳定的运行，需要相关人员对数据库进行每日巡检和记录，下面对数据库日常巡检工作做一个全面详细的计划：一、小型机日常巡检：1.检查小型机硬件健康状态1.1显示内核启用的是32位还是64位#bootinfo-K641.2显示硬件32位还是64位：#bootinfo-y641.3显示以KB为单位的实际内存：#bootinfo-r325058561.4显示系统上的硬盘数量#lspvhdisk000c7c505bc0669c5rootvgactivehdisk100c7c50592cdd77arootvgactivehdisk200cb9934c0a92e73datavgactivehdisk300c7c505ce5e6688datavgactive1.5查看硬盘hdisk1的详细信息：#lspvhdisk1PHYSICALVOLUME:hdisk1VOLUMEGROUP:rootvgPVIDENTIFIER:00c7c50592cdd77aVGIDENTIFIER00c7c50500004c0000000129bc06773fPVSTATE:activeSTALEPARTITIONS:0ALLOCATABLE:yesPPSIZE:512megabyte(s)LOGICALVOLUMES:14TOTALPPs:558(285696megabytes)VGDESCRIPTORS:2FREEPPs:224(114688megabytes)HOTSPARE:noUSEDPPs:334(171008megabytes)MAXREQUEST:1megabyteFREEDISTRIBUTION:01..00..00..111..112USEDDISTRIBUTION:111..112..111..00..00MIRRORPOOL:None#smittyfs#smittylvm1.6查看处理器数量：#lscfg|grepproc+proc0Processor+proc2Processor+proc4Processor+proc6Processor1.7查看一个CPU的详细信息：#lsattr-Elproc0frequency4204000000ProcessorSpeedFalsesmt_enabledtrueProcessorSMTenabledFalsesmt_threads2ProcessorSMTthreadsFalsestateenableProcessorstateFalsetypePowerPC_POWER6ProcessortypeFalse#1.8查看系统硬件资源列表：#lscfg1.9查看芯片类型：#uname-ppowerpc1.10查看操作系统版本号：oslevel1.11显示系统名称：#uname-sAIX1.12显示节点名称：#uname-nDL-DB-021.13显示uname的很多信息（系统名称、节点名称、版本、计算机ID）：#uname-aAIXDL-DB-021600C7C5054C001.14显示系统型号：#uname-MIBM,8204-E8A1.15显示操作系统版本：#uname-v61.16显示运行系统的硬件的计算机ID编号：#uname-m00C7C5054C001.17显示系统ID编号：#uname-uIBM,02067C5051.18显示AIX的主要版本、次要版本和维护级：#oslevel-r6100-04#lslpp-hbos.rteFilesetLevelActionStatusDateTime----------------------------------------------------------------------------Path:/usr/lib/objreposbos.rte6.1.4.0COMMITCOMPLETE07/10/1019:07:31Path:/etc/objreposbos.rte6.1.4.0COMMITCOMPLETE07/10/1019:07:31#1.19查看磁盘使用情况（参数k表示以k为单位，m表示以M为单位）：#df-kFilesystem1024-blocksFree%UsedIused%IusedMountedon/dev/hd4524288050395124%142712%//dev/hd211534336538268854%524715%/usr/dev/hd9var5242880454472014%74871%/var/dev/hd310485760103979561%40021%/tmp/dev/fwdump104857610469321%131%/var/adm/ras/platform/dev/hd1524288052417081%81%/home/dev/hd11admin5242885238481%51%/admin/proc-----/proc/dev/hd10opt10485760569685646%107131%/opt/dev/livedump5242885238801%41%/var/adm/ras/livedump/dev/oradmpbak10485760448802858%280423%/orainstbak1/dev/oraclebak62914560960524885%331%/oradatabak1/dev/oradata36700160032101696813%331%/oradata/dev/orainst209715201494351229%287071%/orainst1.20查看文件大小#du-stmp166552tmp2.检查系统报错信息2.1显示简短报错信息#errpt|moreTIMESTAMP:MMDDHHMMYY(月日时分年）T（类型）:P永久;T临时;U未知（永久性的错误应引起重视）C（分类）:H硬件;S软件;O用户;U未知2.2列出所有硬件出错信息：#errpt-dH2.3列出所有软件出错信息：#errpt-dS2.4查看具体某个ID的报错信息：#errpt-ajD666A8C7aaa.txtD666A8C7是简短报错信息中的ID号。2.53．控制面板上的LED代码.一般为8位代码，通常系统故障灯会同时亮起。某些机型还会同时显示故障设备位置代码。.4位代码，通常是Exxx。.3位代码，通常为0yyy，只看后3位。.8位和4位代码可查看系统服务手册(ServiceGuide)。3位代码可查看系统诊断手册(DiagnosticInformationforMultipleBusSystem)。.闪动的888,系统崩溃，硬件或软件原因造成。按reset键会显示更多内容。888-102一般为软件故障（888-102-207例外）系统会产生一个dump。888-102-xxx-0C9系统正在做dump,请等待。888-102-xxx-0C0系统dump完成，可关电重启。888-103或105硬件故障，一般有SRN代码及位置代码。2.6SMS(SystemManagementService)故障记录当主控台出现键盘图标后(LED显示E1F1时)按1键。进入SMS菜单选择Utilities选择ErrorLog,抄下8位故障代码（在SMS中还可以更改系统启动顺序表3.查看操作系统日志errpt-a|head-1504.查看相关用户mail#mail#su-oracle$mail31esaadminSunJan903:0115/735ElectronicServiceAgentnot?会出现所有邮件的列表，这时在“？”后面按数字表示要查看那一封邮件。按“h”表示查看邮件列表。5.检查CPU利用率#sar15AIXDL-DB-021600C7C5054C0010/29/13Systemconfiguration:lcpu=8mode=Capped15:10:57%usr%sys%wio%idlephysc15:10:581610834.1015:10:594420543.9515:11:001110883.9715:11:01100994.0015:11:022420754.00Average1910804.00#%usr＋%sys80%的时候CPU将是瓶颈5.2#topas6.检查内存利用率#vmstatSystemconfiguration:lcpu=8mem=31744MBkthrmemorypagefaultscpu---------------------------------------------------------------rbavmfrerepipofrsrcyinsycsussyidwa12621127529987000130261082373055820970##vmstat-v8126464memorypages7873088lruablepages15376freepages2memorypools691381pinnedpages80.0maxpinpercentage3.0minpermpercentage90.0maxpermpercentage22.8numpermpercentage1801544filepages0.0compressedpercentage0compressedpages22.8numclientpercentage90.0maxclientpercentage1801544clientpages0remotepageoutsscheduled0pendingdiskI/Osblockedwithnopbuf0pagingspaceI/Osblockedwithnopsbuf2484filesystemI/Osblockedwithnofsbuf754clientfilesystemI/Osblockedwithnofsbuf2483337externalpagerfilesystemI/Osblockedwithnofsbuf#6.2#svmonsizeinusefreepinvirtualmmodememory81264648041605848596882306156257Dedpgspace1258291219307workpersclntotherpin44659302773238864inuse615625701885348PageSizePoolSizeinusepgsppinvirtuals4KB-7408421193073278145523073m64KB-3957402252639574##svmon-Gsizeinusefreepinvirtualmmodememory81264648056058704066894506185976Dedpgspace1258291219692workpersclntotherpin44781302773238864inuse618597601870082PageSizePoolSizeinusepgsppinvirtuals4KB-7420874196923278185550792m64KB-3969902260239699#7.检查虚拟内存利用率#lsps-aPageSpacePhysicalVolumeVolumeGroupSize%UsedActiveAutoTypeChksumhd6hdisk0rootvg49152MB1yesyeslv0#8.检查系统磁盘空间利用率#df-kFilesystem1024-blocksFree%UsedIused%IusedMountedon/dev/hd4524288050392124%142722%//dev/hd211534336538237654%524715%/usr/dev/hd9var5242880455342814%74871