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" <Sean.ONeill_at_organon.ie> 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: Sean.ONeill_at_organon.ie
>
> 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).
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: wisernet100_at_yahoo.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).
Received on Tue Jan 08 2002 - 08:41:04 CST
