Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rename alert log

RE: Rename alert log

From: Jesse, Rich <>
Date: Tue, 10 Jul 2001 10:59:34 -0700
Message-ID: <> Oracle 7.3.4,, 7.3.5, 8.0.5, 8.0.6, 8.1.6, and 8.1.7 on HP/UX 10.20/11.0, a rename of the alert log causes a new one to be created with the next message. My "AlertLogChecker" renames the alert log if it finds an error in there. As I'm attempting to size partitions for a non-partitioned table, I can tell you the rename of the alert log works very well (I've got 20+ renamed logs in my test DB's bdump dir)! :)

OTOH, most, if not all versions of Oracle on OpenVMS *will* keep open the alert log (and the udump trace/log files) like you describe. Just the nature of I/O on OpenVMS, probably due to it's superior file handling and lack of OpenVMS experience on Oracle's OpenVMS porting (look at the DCL they've created). :D

Rich Jesse                          System/Database Administrator, OpenVMS
bigot             Quad/Tech International, Sussex, WI USA

-----Original Message-----
Sent: Tuesday, July 10, 2001 12:27
To: Multiple recipients of list ORACLE-L

depends on the version of the database you are running.. it used to be that yes, you could just rename it and Oracle would open a new one of the original name when it needed to write to it.

In 8.? and above, you can no longer just rename it, Oracle now maintains an open file pointer to it, similar to the way it handles the listener log file. So you will need to do the same sort of tricks to the alert log as you

have to do to the listener log (make a copy then copy /dev/null to the original)

Please see the official ORACLE-L FAQ:

Author: Jesse, Rich

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: (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 Tue Jul 10 2001 - 12:59:34 CDT

Original text of this message