Hmmm...in 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
[EMAIL PROTECTED] 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: http://www.orafaq.com
--
Author: Jesse, Rich
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).