DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Alert log file size

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    Alert log file size

    folks

    oracle 8.1.7 in linux

    My alert log file is approx 25mb is there a way to trim it.

    I want to delete the log file. will it generate the fresh alert log file after i delete.

    I want to have free space in linux file system

    Gajanan

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    If you don't need it just blow it away and a new one will be created when Oracle decides he needs to create an entry. The easiest way to give yourself comfort in this is, to go and delete the alert log, then issue a log file switch. Oracle will create a new alert log for you.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Apr 2003
    Posts
    353
    In the same way listener.log
    also will grow.
    make a copy of that (open that file in wordpad --use save as)
    and delete the contents of the original file and save that.

  4. #4
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Try this:

    cp alert.log alert_old.log
    cat /dev/null >alert.log

    It is upto you whether to delete alert_old.log or not.

    Tamil

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width