Can I compress archive logs to reduce file system space?

Posted on 2008-11-03
Last Modified: 2013-12-19
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.
Question by:la_colibri
    LVL 34

    Expert Comment

    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.
    LVL 15

    Expert Comment

    by:Devinder Singh Virdi
    Take Hot/Cold backups of every tablespace, then delete your unwanted archive log files to free some space
    LVL 10

    Accepted Solution

    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)

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now