Re: Monitoring Archived Logs

Lindsay,

Here are some points to ponder to help you develop a strategy for maintaining archive logs.

If you use 3rd party backup software, does it make provision for maintaining archive logs? This will influence your decisions.

Do you have a SLA? ( service level agreement ) If so, this will help you determine how many archive logs you need to keep online to ensure speedy recoveries should they be needed.

Never delete archive logs that may be needed for a future recovery and have not yet been backed up on tape ( or media of your choice )

Using other peoples scripts is fine, as long as you understand how they work and what actions they will take under various circumstances such as the archive log disk area filling up.

Don't trust the recoverability of your databases to scripts or software that you don't understand or are unsure of. Test *everything*.

The point of the exercise is to help you understand what your requirements really are, then put together the tools that make it happen.

When you can answer all of this, there are a number of script around that you can use or modify for your own use.

Jared

On Wednesday 18 April 2001 14:26, Lindsay Stoddard wrote:
> Hi,
>
> Does anyone have a monitoring script and/or strategy for maintaining
> current archived redo log files and deleting old ones?
>
> Thanks,
>
> Lindsay
> ACS Governement Services

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.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).