Hi , Cant we check the latest error of the alert log files by tail -f alert.log I think we can continously get the latest error . If I am wrong then do please correct me. Thanks On 11/15/06, Barbara Baker <barb.baker@xxxxxxxxx> wrote:
Anand: My favorite is still "chk_oerr" on Tim Gorman's web site (www.evdbt.com) It takes a bit of setup, but does everything! It keeps a file with the last line previously checked so it only looks at new entries. chk_oerr.sh (ASCII text file – 11Kb) UNIX Korn-shell script which is intended to called from the UNIX *cron *perhaps once per day or a couple times per week. It sends email to the configured email accounts (note the need for files named ".dbapage" and ".dbamail" in the "$HOME" directory of the owning UNIX account) when it detects newly-logged ORA- error messages in the "alert.log" file or in the ".trc" files in the BACKGROUND_DUMP_DEST or USER_DUMP_DEST directories. Also reports newly generated "core" files in the CORE_DUMP_DEST. HTH! Barb On 11/15/06, Anand <shastry17@xxxxxxxxx> wrote: > > * Hi all, > > > How do you check for alert log file for the latest error ?* > > *Linux command to remove files in the log direcotory,in such a way that > the last 15 days fills must exist but purge the remaining files? * > > *What if the alert log file has been deleted by some script? > > Thanks > Anand > * >