oracle自動化巡檢腳本

《oracle自動化巡檢腳本》由會員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在教育資源-天天文庫。

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執(zhí)行#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