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

Thread: removing log files

  1. #1
    Join Date
    Mar 2001
    Posts
    65

    Thumbs down

    i started running ora 8.1.6 recently and put it in archivelog mode a week back
    the arch directory is growing by leaps and bounds .
    8 gb is what is currently under arch.

    i take regular full exports.no cold backups as it's 24x7
    how to get rid of older archives?
    can i simply rm them?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well even you are in archive mode you must take hot backups, once you have a hot backup set the archive logs generated before the hotbackup can be deleted.
    But it's always advisable keep one or two weeks logs

  3. #3
    Join Date
    Feb 2001
    Posts
    295
    If you have backups that are newer than archives, I don't see any problem in rm the archives. However, storing the archives in another media instead of simply removing them may be a good idea. You don't know if tomorrow your boss will ask you to recover the database X to day Y, hour Z.


    Adriano.



  4. #4
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330

    Cool removing log files

    hi
    best way to over come that type of situation is just move arch files(keeping last 2/one week files depending upon the growth rate and space availability) from that dir to some other directry where you find space to keep them(say some dump01 dir).keep it for 2weeks and delete them.That way we can have total 4 weeks of log files always.compress if you have space constrains.Also ensure you are monitoring daily and doing so....I am following the same principle and it is working....
    Thanks.
    Thanigai.

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