Re: Archive log dest full

From: <Jared.Still_at_radisys.com>
Date: Tue, 08 Jan 2002 09:52:44 -0800
Message-ID: <F001.003E9D66.20020108091550@fatcity.com>

Sean,

A number of respondents have said that all you need to do is backup archive logs, delete them and get on with business.

Sorry folks, that might work on unix, but not in M$ Windoze, at least with the versions of Oracle 8+ that I've dealt with on Win32.

Once the archive log destination has filled up, Oracle Win32 does not know how to continue, even if you free up the space.

To fix the problem online, you must redirect the archive log destination:

alter system set log_archive_dest_1 = 'location=c: \oracle\oradata\ts10\archive2'

Oracle will then start working again. There may be other variations on this, but
I've had to use this once or twice.

You will then need to restart Oracle at a convenient time to reset the archlog
destination. No need to reboot.

Jared

                                                                                       
                             
                    "O'Neill,                                                          
                             
                    Sean"                To:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>        
                    <Sean.ONeill_at_o       cc:                                           
                             
                    rganon.ie>           Subject:     Archive log dest full            
                             
                    Sent by:                                                           
                             
                    root_at_fatcity.c                                                     
                             
                    om                                                                 
                             
                                                                                       
                             
                                                                                       
                             
                    01/08/02 03:50                                                     
                             
                    AM                                                                 
                             
                    Please respond                                                     
                             
                    to ORACLE-L

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:
INET: Jared.Still_at_radisys.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