Re: Need script that monitors for archive directory filling up

From: <Cherie_Machler_at_gelco.com>
Date: Thu, 14 Dec 2000 08:45:35 -0600
Message-Id: <10710.124567@fatcity.com>

--0__=jKksV8LObVyy2uzQYz2Pxx1zgzQ7mqdzRpbzGZChpKpjdj2C2ZFMLQep
Content-type: text/plain; charset=us-ascii Content-Disposition: inline

We are using RMAN to backup the archives at least once a day and sometimes as often as hourly depending on activity on each database.

We do have quite a bit of disk space but it often fills up when there is periodic heavy utilization or really large jobs that are creating a lot of archive logs.

I can't move the archive log files because they have to be in position in order to run the archive cleanup script from rman.

I'd be interested to know if there is a way to have more than one archive directory location within rman.

Cherie
---------------------- Forwarded by Cherie Machler/GELCO on 12/14/2000 09:24 AM

"Ron Rogers" <RROGERS_at_galottery.org> on 12/13/2000 03:42:25 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Cherie Machler/GELCO)

Subject: 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
--0__=jKksV8LObVyy2uzQYz2Pxx1zgzQ7mqdzRpbzGZChpKpjdj2C2ZFMLQep

Content-type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

=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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Cherie_Machler_at_gelco.com

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).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ron Rogers
INET: RROGERS_at_galottery.org

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