Shell Programming and Scripting

Hi all.
I am not a DBA. But I do have responsibility for making sure the archive logs dont fill up and cause the database. This happend the other day while I was absent (sick) and I got a good ticking off for it.

Needless to say I dont want this happen!

Could anyone lend a hand to a complete novice here and explain how I could run a script that would alert me and my boss by email if the archive logs got to over 90% ???

We are running Oracle 9 on AIX Version 5.2.

Many thanks in advance.

Are you referring to a specific file, directory, or mounted filesystem?

The basic process would be:
create a script that cron will run every xx minutes/hours/etc...

The script will:
look at the file/directory/filesystem
detemine the math of 'how full'
if 'how full' > 90, send an email

directory : oradbi1/oracle/logs

Code:

du -k oradbi1/oracle/logs

That will tell you how many k are allocated/used. Is there a hard number you want this tracked against? (For example, the above command may return 543560 meaning 543M used; but maybe you do not want to exceed 600M.)

OK thanks for the reply.
Actually there is just this directory that I need to monitor - /archlogs.
Here is a copy of what I see when I do df -m:


/dev/lv02 8064.00 7810.80 4% 17 1% /archlogs


So the size is 8064M. So once it hits around 7257M I would like an email fired to me and my boss.

The following is a script that would use what you just told me; remember to delete the # comments from the df command line and the mailx command line.

Code:

> cat check_size 
#! /bin/bash
# check amount of space in use

#df -m >tmp_log_anal

curr_spc=$(cat tmp_log_anal | tr -s " " | cut -d" " -f3 | cut -d"." -f1)
echo $curr_spc

#send messages if above threshold

if [ $curr_spc -ge 7257 ]
   then
   echo "Threshold exceeded"
#   mailx -s "log file nearly full" abc@123.com 
fi

explaining this:

Code:

curr_spc=$(cat tmp_log_anal | tr -s " " | cut -d" " -f3 | cut -d"." -f1)

gets rid of extra space characters
using space char as delimiter, takes the 3rd field
now using period as delimiter, takes the 1st field (tricky way to get a whole number from a decimal)

Thanks!
Im nots ure about one thing though - tmp_log_anal
I dont see any inclusion of the /archlogs directory contents.