oracle自动化巡检脚本

《oracle自动化巡检脚本》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、#!/bin/bash##NAME#report_oracle_inspection.sh2013-12-18##DESCRIPTION#collectingtheDBinfo##NOTES#shreport_oracle_inspection.sh##MODIFIED(yyyy-mm-dd)#zhangheli2010-08-11初步改成用shell执行#zhangheli2011-07-02增加temp表空间情况查询echo'InstanceHealthData'echo'=============================================

2、==='echo'Thecurrentdatabaseis$ORACLE_SID'echo'Thecurrentrunningprocessesfor$ORACLE_SIDare'echo'================================================'ps-ef

3、grep$ORACLE_SIDsqlplus-S/nolog<

4、===================================='fromdual;setlinesize1000setpagesize1000setheadingonselect*fromv$instance;setheadingoffselect'01:databasecreateddateandarchivetype'fromdual;select'================================================'fromdual;setheadingonSelectCreated,Log_Mode,Log_ModeF

5、romV$Database;setheadingoffselect'1.ulimitoracle'fromdual;select'================================================'fromdual;!ulimit-asetheadingoffselect'3.installedproductionoption'fromdual;select'================================================'fromdual;setlinesize1000setpagesize1000s

6、etheadingonselect*fromv$option;setheadingoffselect'4.usedproductionoption'fromdual;select'================================================'fromdual;setlinesize1000setpagesize1000colCOMP_NAMEfora40setheadingonselectCOMP_ID,COMP_NAME,VERSION,STATUSfromdba_registry;setheadingoffselect'5.

7、spfile'fromdual;select'================================================'fromdual;showparameterspfilesetheadingoffselect'6.notdefaultparameter'fromdual;select'================================================'fromdual;colnamefora40colvaluefora40setheadingonselectname,valuefromv$paramete

8、rwhereisdefault='FALSE';setheadingoffselect'7.controlfile'fromdual;select'================================================'fromdual;showparametercontrol_filessetheadingoffselect'8.backupcontrolfile'fromdual;select'================================================'fromdual;alterdatabas