we run a batch job every hour that takes all the unzipped archived redo logs and zips them, so that we keep compressing space. The other thing I used to do was on a daily basis, move the prior day's logs to another drive so that I was only storing one day's worth of archived logs at the archive log dest drive
--- "O'Neill, Sean" <[EMAIL PROTECTED]> wrote: > So yesterday the archive log dest disk filled up on one of our > prduction > systems causing the Oracle DB to halt as it's supposed to. Disk > space was > tight and there was a bit of data loading done. Anyhow I freed up > disk > space on relevant drive and proceeded to server console to press the > OK > button to allow archiving to restart. However, the console was > locked by a > PC Anywhere session which prevented me from getting to the console > window > with archive dest full message. Anyhow ended up having to bounce the > database. Apart from throttling the user who set the PC anywhere > lock on > the console and insisting it not be done again I'm wondering did I > have any > other options apart from a database bounce to overcome this problem?. > > Oracle 7.3.3, 8.0.5, 8.1.7 > NT4, W2K > ------------------------- > Seán O' Neill > Organon (Ireland) Ltd. > [subscribed: digest mode] > -------------------------------------------------------------------- > This message, including attached files, may contain confidential > information and is intended only for the use by the individual > and/or the entity to which it is addressed. Any unauthorized use, > dissemination of, or copying of the information contained herein is > not allowed and may lead to irreparable harm and damage for which > you may be held liable. If you receive this message in error or if > it is intended for someone else please notify the sender by > returning this e-mail immediately and delete the message. > -------------------------------------------------------------------- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: O'Neill, Sean > 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). __________________________________________________ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
