RE: What happens if you lose the alert log?

You can rename or delete the <SIS>Alrt.log on the fly. I do this on all my
databases which is versions 7.3.4, 8.0.5, and 8.1.7. The next time that
Oracle has to write to the log it will just create another log.

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?

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

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 Thu Sep 13 2001 - 10:50:48 CDT