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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
