can i delete log file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: can i delete log file

  1. #1
    Join Date
    Jul 2002
    Posts
    42
    Hi,
    In my oracle web server, there is a log file under the log directory about 79MB (logger.err) file. Can I delete this system created file or how to reduce the size of this file.

    os- WINDOWS NT 4.0
    OWS oracle web server 4.0.8
    Oracle

  2. #2
    Join Date
    Aug 2002
    Posts
    1

    Exclamation U can delete the log file

    hi venki,

    you can drop yr log files under some criteria:
    1)you should find out whether it is system created or you
    have created for yr own database creation.
    2)for both the cases you cannot delete yr log files
    because of initial bg process(lgwr)log writer
    3)after the creation of database ,whatever log files that you have created can be dropped or size can be changed

    minimum of two log files you need for ur database.




    Heyyyy Venki,

    If your database have more than two log files then you can delete it.If your file contains any member(group) files then delete the members first and then delete the logger.err file.

    Syntax for deleting the files:

    Alter database
    drop logfile 'c:\oracle\oradata\dir123\logger.err';

    To delete its members

    Alter database
    drop logfile member
    'c:\oracle\oradata\dir123\.log';

    This deletion is database level only.After deleting in database level you have to delete the files in physical level(or) OS level

    ie delete the from c:\...\...\...\xxxx.err

    then only it will be permanantly removed.



    howzit





  3. #3
    Join Date
    Jul 2002
    Posts
    42
    thanks lot balaji
    Oracle

  4. #4
    Join Date
    Jul 2002
    Posts
    42
    balaji,
    what will happen if i delete the physical file and created a dump file with same name.?
    Oracle

  5. #5
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,591
    Originally posted by venkateskg
    balaji,
    what will happen if i delete the physical file and created a dump file with same name.?
    How do you relate these 2 activities??
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  6. #6
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Have you had a look what is inside the error logfile.

    It is most probably a dump of an error lgwr produced.
    Have you cheked your alert log for any issues ?

    I don't know why you are being told to drop your logfiles, logger.err is NOT a logfile (unless you created it with that name, which I doubt very much).

    You need to establish what the reason was for that logger.err file being created and decide whether it is something you need to investigate.

    If you decide that there is no issue, by all means delete the error file produced. If you are not sure, I suggest you log a TAR with oracle.

    There is no need to go dropping and recreating your logfiles unnecessarily. It's like saying :
    'ooooh I got an error 0600, I know I'll recreate my database.'




    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

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