Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We have a developer db server with 11g on Windows Server 2003 R2. I just noticed that the alert_dev11g.log file in the F:\Oracle11g\diag\rdbms\dev11g\dev11g\trace folder is nearly 4GB large.

I'd like to know if this is a way to delete the log file or dramatically reduce the size of it. I've tried renaming the file, but Windows says that the file is in use by another process.

So far, my research has ended up in many dead ends. Everything I can find on Oracle log files pertains to the redo logs. I found info on the MAX_DUMP_FILE_SIZE parameter, but it excludes the alert file.

share|improve this question

migrated from stackoverflow.com Dec 22 '11 at 8:12

This question came from our site for professional and enthusiast programmers.

    
Boot up Windows in safe mode and delete it. You can't modify files while they are being used. Or, boot into Linux and delete it from there. –  Blender Dec 21 '11 at 18:55
    
OK, but is there a way to manage the log from Oracle itself? –  PEBKAC Dec 21 '11 at 19:20

1 Answer 1

Oracle's usage pattern for this file is:

open file
write entry
close file

So I suspect you tried to delete/rename the file while it was being actively used.

share|improve this answer
    
I heard that is the case for linux based Oracle. Is it the same on Windows based Oracle? The file hasn't been modified in 2 years, but it still shows as being accessed by another process. The box was rebooted two days ago. –  PEBKAC Dec 22 '11 at 18:28
    
See this discussion on asktom.oracle.com: asktom.oracle.com/pls/apex/… –  Adam Musch Dec 22 '11 at 19:57

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.