This content has been marked as final. Show 8 replies
Try using this : ( my bad, this is for Oracle 11. But you should really upgrade! )
1.2MB is tiny.
For Oracle 10 try using a text editor like Editpad or Textpad. I would just rename the alert log every few months.
Edited by: mseberg on Apr 1, 2013 9:25 AM
For this, since you are on windows, have some more advanced Text Editor which can support some big files.
Other than that, if you dont want your alert log to be that big, or if you want to some specific entries in the file, just move the old file or rename it before you start your activity that you want to monitor. Database server will create a new file for you and that will be truncated logically for you.
I have an Oracle 10g installed on Windows 2008 r2. I want to check the alert file for investigating something. But the alert log file itself is about 1.2MB, it's very hard to open with neither Wordpad nor Notepad. if i don't care the historical information, may I just open the alert log file and manually delete everything inside and save it, and do this weekly? Or you have any other good suggestion?1.2MB is small size.while compare to production environment.
the file located at:
take a backup(if needed) of alert.log file then recreate it.
Girish Sharma wrote:Don't even need the second command. Just rename the file. Period. The next time Oracle needs to write to the alert log, it will create a new one.
You need to do anything :
Just issue these two commands at command prompt and you done :
c:\>ren e:\oracle\database\product\10.2.0\admin\orcl\bdump\alert_orcl.log old_alert_orcl.log
c:\>copy nul e:\oracle\database\product\10.2.0\admin\orcl\bdump\alert_orcl.log > nul