I did not understand this note. Does it mean that I can copy current
alert.log to alert.log.old and then mv nullfile alert.log and original
oracle using original file descriptor will write to new empty alert.log?
Alex Hillman
-----Original Message-----
[mailto:[EMAIL PROTECTED]]
Sent: Sunday, May 27, 2001 9:10 PM
To: Multiple recipients of list ORACLE-L
Hi,
For information.
At various times there has been a lot of discussion about deleting the
alert.log.
Looking through Metalink I found the following note which describes the
behaviour change between 7.3.4 and 805 and above.
Hope it is of help.
Regards,
Bruce
Doc ID: Note:122401.1
Type: BULLETIN
Status: PUBLISHED
Content Type: TEXT/PLAIN
Creation Date: 18-OCT-2000
Last Revision Date: 14-MAY-2001
Problem Description
-------------------
The Oracle background processes has an open file descriptor on the
alert.log.
When the database is up and running it continually holds this file
descriptor
open. This was not the case in 7.3.4, but is true for 8.0.5 to 8.1.7.
This poses the question: What if the database is up and the alert.log
gets too large. Do I have to shutdown the database to release the open
file descriptor on the alert.log, then deal with the large alert.log?
Solution Description
--------------------
You are able to copy the alert.log while the database is up and running.
1) Create an empty file:
(example: touch nullfile.log)
2) Replace the old alert.log with the new empty file:
(example: mv nullfile.log alert<sid>.log)
The running database experiences no affects when doing this.
Explanation
-----------
Having the continual open file descriptor on the alert.log is intended
behaviour for the database.
References
----------
[BUG:1388186] OPEN FILE DESCRIPTORS HELD BY ORACLE BACKGROUND PROCESSES
ON ALERT.LOG FILE
Additional Search Words
-----------------------
delete alert
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hillman, Alex
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).
