From dgoulet@vicr.com Thu, 13 Sep 2001 09:54:47 -0700 From: dgoulet@vicr.com Date: Thu, 13 Sep 2001 09:54:47 -0700 Subject: Re:What happens if you lose the alert log? Message-ID: MIME-Version: 1.0 Content-Type: text/plain !! Please do not post Off Topic to this List !! If you delete the alert log and Oracle needs to make an entry thereafter the file will re-appear all by itself. Dick Goulet ____________________Reply Separator____________________ Author: "Carle; William T (Bill); NLCIO" Date: 9/13/2001 6:50 AM !! 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@att.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO INET: wcarle@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@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: dgoulet@vicr.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@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).