• 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.
0
la_colibri
Asked:
la_colibri
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.
0
 
Devinder Singh VirdiLead Oracle DBA TeamCommented:
Take Hot/Cold backups of every tablespace, then delete your unwanted archive log files to free some space
0
 
dbmullenCommented:
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)
0
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