RE: Alert log

Yes. Oracle will create the alert file automatically when next time it needs to write some info.

<<<From Oracle Doc.

Each database also has an ALERT file. The ALERT file of a database is a chronological log of messages and errors, including
* all internal errors (ORA-600), block corruption errors (ORA-1578), and
deadlock errors (ORA-60) that occur
* administrative operations, such as the SQL statements CREATE/ALTER/DROP
DATABASE/TABLESPACE/ROLLBACK SEGMENT and the Oracle Enterprise Manager or SQL*Plus statements STARTUP, SHUTDOWN, ARCHIVE LOG, and RECOVER
* several messages and errors relating to the functions of shared server and
dispatcher processes
* errors during the automatic refresh of a snapshot
Oracle uses the ALERT file to keep a record of these events as an alternative to displaying the information on an operator's console. (Many systems also display this information on the console.) If an administrative operation is successful, a message is written in the ALERT file as "completed" along with a timestamp. >>>

teki01_at_mediaone.net

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of achoto_at_american.edu
Sent: Tuesday, August 22, 2000 5:12 PM
To: Multiple recipients of list ORACLE-L Subject: Alert log

If I rename the alert log, will Oracle create a new one if it doesn' find it? I think our alert log has grown too large.

Thanks

Ana E. Choto
Systems Programmer
American University
Office of Information Technology
Phone (202) 885-2275
Fax (202) 885-2224

--
Author:
  INET: achoto_at_american.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).