| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Archive log dest full
thanks Rachael.
-----Original Message-----
Sent: Tuesday, January 08, 2002 12:01 PM
To: Multiple recipients of list ORACLE-L
it's just a shell script that does a cd, then gzip *.archive
run in cron...
--- Prakriteswar Santikary <prakriteswar.santikary_at_pointinfo.com>
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" <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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Prakriteswar Santikary
> INET: prakriteswar.santikary_at_pointinfo.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).
-- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prakriteswar Santikary INET: prakriteswar.santikary_at_pointinfo.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 - 14:43:31 CST
 |
 |