RE: Need script that monitors for archive directory filling up

From: Sais, Gene <gsais_at_qode.com>
Date: Thu, 14 Dec 2000 11:08:55 -0500
Message-Id: <10710.124576@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01C065E8.2A083D58
Content-Type: text/plain;

charset="iso-8859-1"

Cherie - In a previous job, I ran a cron job that compressed new archives every 30 mins. Compression can give you ~8:1 space gain. The major disadvantage is you have to uncompress before using them to recover a db.

Gene Sais

-----Original Message-----
From: Cherie_Machler_at_gelco.com [mailto:Cherie_Machler_at_gelco.com] Sent: Thursday, December 14, 2000 9:46 AM To: Multiple recipients of list ORACLE-L Subject: Re: Need script that monitors for archive directory filling up

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

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

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

------_=_NextPart_001_01C065E8.2A083D58
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Need script that monitors for archive directory filling =
up</TITLE>
</HEAD>
<BODY>

Cherie - In a previous job, I ran a cron job that =
compressed new archives every 30 mins.  Compression can give you = ~8:1 space gain.  The major disadvantage is you have to uncompress = before using them to recover a db.

Gene Sais


-----Original Message-----
 From: Cherie_Machler_at_gelco.com [<A =
HREF=3D"mailto:Cherie_Machler_at_gelco.com">mailto:Cherie_Machler_at_gelco.com=
</A>]
 Sent: Thursday, December 14, 2000 9:46 AM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: Need script that monitors for archive =
directory filling up

 

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)

 
 
 

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 Received on Thu Dec 14 2000 - 10:08:55 CST