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.
la_colibriAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.