| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Rename alert log
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 Rich.Jesse_at_qtiworld.com 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: Rich.Jesse_at_qtiworld.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). Received on Tue Jul 10 2001 - 12:59:34 CDT
 |
 |