RE: [SOLVED] missing alert.log mystery (it's not what you think)

I also for over 10 years rename once/week alert log. No issues, I don't zip but only keep X weeks as part of same renaming script.

Joel Patterson
Database Administrator
904 727-2546

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfgang Breitling Sent: Monday, May 16, 2011 7:44 PM
To: sacrophyte_at_gmail.com
Cc: ORACLE-L
Subject: Re: [SOLVED] missing alert.log mystery (it's not what you think)

I have for years renamed the alert log on a weekly basis, and eventually gzipped it, in order to keep it reasonably sized. Oracle just starts a new alert log. Granted, I haven't done a direct bzip on it but that should be no different - except maybe, if the bzip takes a while and oracle tries to write to it while it is open by bzip. I haven't verified on 11.1.0.7 but on 11.2.0.2 that rename still works and Oracle creates a new alert log with the original name ( alert_instance.log ) so I am pretty confident it does also work for 11.1.0.7. In contrast to. e.g. the listener log, which you must not rename. There I do a cp to a new file followed by cp /dev/null > listener.log.

On 2011-05-16, at 1:50 PM, Charles Schultz wrote:

> On May 6th, the original alert_TEMDEV.log was bzipped and removed by a cron job. Usually we check to see if it is open by another process (ie, fuser), but somehow the stars must have been aligned or something. Anyway, we had an orphaned inode.
>

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l