Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Need script that monitors for archive directory filling up
Cherie,
Why not have a cron that will "find" the archive logs with a date > 1 day =
ond and "exec" a move to a spare disk or after a successfull backup of the =
archive logs "find and rm" the files. Does your disk fill up in less than =
1 day?
If so it would be in your best interest to geta larger volume for archives =
or use multiple archive areas.
I will look in my cd's to see if I saved the commands from my time as a =
SA for Unix.
ROR m=AA=BF=AAm
>>> Cherie_Machler_at_gelco.com 12/13/00 02:11PM >>>
I've been bit one time too many by the archive
directory filling up in unix.
I am looking for a korn shell script that will log into the database and find out what mount point the archives log files are being stored on. Then I'd like the script to do something like a df -k and see if the mount point has crossed a threshold for percentage full (something like 85% full). If that mount point is more than 85% full, I'd like the script to send me an email.
Anybody have such a script they'd be willing to send me? I think I can code the SQL part but I'm not that great with the unix part.
Eternal gratitude in advance,
Cherie Machler
Gelco Information Network
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20
--=20
Author:=20
INET: Cherie_Machler_at_gelco.com=20
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Dec 13 2000 - 15:36:12 CST
![]() |
![]() |