Re: What happens if you lose the alert log?

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

There is no problem with this. Oracle will just create a new one on the next write. I have a script that moves the alert.log to a backup file every Sunday.

"Carle, William T (Bill), NLCIO" wrote:

> !! 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).

--
Scott Canaan (srcdco_at_rit.edu)
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it"
- Tom Lehrer


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Scott Canaan
  INET: srcdco_at_ritvax.isc.rit.edu

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).