it's just a shell script that does a cd, then gzip *.archive run in cron... --- Prakriteswar Santikary <[EMAIL PROTECTED]> wrote: > Rachel, > > do you have a script for this ? I would appreciate if you could send > me that > script. > > regards > Santi > > -----Original Message----- > Sent: Tuesday, January 08, 2002 5:55 AM > To: Multiple recipients of list ORACLE-L > > > 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). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Prakriteswar Santikary > 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).