检查磁盘空间

FS=`df -h|sed '1d'|awk 'sub("%","",$4) {if($4>80) print $5}'|xargs`
for i in $FS
do
echo "The $i filesystem percent more than 80%" >>$files
done

检查警告日志文件

cd $ORACLE_BASE/admin/$ORACLE_SID/bdump
if [ -f alert_$ORACLE_SID.log ]
then
touch alert_$ORACLE_SID.log
cat alert_work.log>>alert_$ORACLE_SID.hist
grep -i "ORA-" alert_work.log >alert.err
fi
if [ `cat alert.err|wc -l` -gt 0 ]
then
cat alert.err>>$files
fi
rm -rf alert.err
rm -rf alert_work.log

检查数据库状态

$ORACLE_HOME/bin/sqlplus -S /nolog </dev/null |grep -i "READ WRITE">/dev/null
conn / as sysdba
select log_mode,name,open_mode from v\$database;
quit
EOF

if [ $? = 0 ]
then
echo "The database is normal">>$files
else
echo "The database is not available!!!!">>$files
fi

检查表空间状态

$ORACLE_HOME/bin/sqlplus -S / as sysdba </dev/null
set pagesize 0
set feedback off
set term off
set termout off
set trimspool on;
set trimout on;
set linesize 100
col tablespace_name for a15;
col status for a10;
spool /u/oracle/tablespace_status.txt
select tablespace_name,status from dba_tablespaces;
spool off;
exit;
EOF
cat /u/oracle/tablespace_status.txt|awk '{if ($2 == "OFFLINE") {print $1" is OFFLINE"} else if ($2 == "RECOVER") {print $1" is RECOVER"} else if (($2 == "READ") && ($3 == "ONLY")) {print $1" is READ ONLY"}}'>>$files
rm -rf /u/oracle/tablespace_status.txt