| 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
As a first step you can compress all archived logs first!!! Then you can do what ever u want with out bouncing database..
>From: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Archive log dest full
>Date: Tue, 08 Jan 2002 04:15:19 -0800
>
>Backup the archivelogs on a schedule and delete them from the archivelog
>destination. Rman has a command to do this, if you use rman.
>
>HTH,
>Ruth
>----- Original Message -----
>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>Sent: Tuesday, January 08, 2002 6:50 AM
>
>
>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).
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
>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).
Raghu Kota
OCP DBA.
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: raghukota_at_hotmail.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 - 09:22:25 CST
 |
 |