• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1083
  • Last Modified:

Can I compress archive logs to reduce file system space?

Can I compress archive logs to reduce file system space? It is reaching almost full capacity and moving files out the the mount point is not enough to keep it under control.
1 Solution
johnsoneSenior Oracle DBACommented:
There is no harm in compressing them.

However if you use RMAN for backup, it will not be able to find tha archive logs if they are compressed.
Devinder Singh VirdiLead Oracle DBA TeamCommented:
Take Hot/Cold backups of every tablespace, then delete your unwanted archive log files to free some space
yes, once oracle is done writing the file, it's done with it unless you need them for recovery.
so, if you wanted to cause more work, you could even rename them...  i wouldn't but it's just to make a point.

really, you should ask, why is my database creating so many "archive-logs"?
are there really that many insert/update/deletes being done?
if yes....  consider several options
         1)  write them off the "mount-point" faster  (we do it every 15 minutes)
         2)  make the "mount-point" bigger (our standard is 50gb)
         3)   compress like you said
         4)   make the redo-log-files bigger  (it will switch less often)
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now