RE: What happens if you lose the alert log?

From: Kevin Lange <kgel_at_ppoone.com>
Date: Thu, 13 Sep 2001 11:15:41 -0700
Message-ID: <F001.0038DA76.20010913111456@fatcity.com>

!! Please do not post Off Topic to this List !!

Alert logs can be destroyed at any time. If it is not there, oracle recreates it when it needs to log to it.

-----Original Message-----
Sent: Thursday, September 13, 2001 9:50 AM To: Multiple recipients of list ORACLE-L

!! Please do not post Off Topic to this List !!

Hi,

I had a situation yesterday where a rogue process wrote millions of error messages into the alert log. I was able to get rid of the process, then delete the error messages out. But it would have been quicker to just blow it away and create a new, empty one. I was concerned as to the effect that would have on Oracle. Would it bring Oracle down? What is the best way to handle this?

Bill Carle
AT&T
Database Administrator
816-995-3922
wcarle_at_att.com

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Carle, William T (Bill), NLCIO
INET: wcarle_at_att.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: Kevin Lange
INET: kgel_at_ppoone.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------