Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Oracle: remove large alert / trace files

    • Article Type: General
    • Product: Aleph
    • Product Version: 21

    Problem Symptoms:
    The following Oracle directories are very large
    - /exlibris/app/oracle/diag/rdbms/aleph21/aleph21/alert/ (38 GB, XML-Dateien)
    - /exlibris/app/oracle/diag/rdbms/aleph21/aleph21/trace/ (9,7 GB, trc, trm, log-Dateien)

    1. Is it possible to delete files from these directories?
    2.Can we configure the directories in a way that there is a maximum limit?

    Cause:


    Resolution:
    Oracle's writes messages and errors when applicable on daily database operations to the alert.log and points to trace files and dump files for more details.

    Q: Can the Oracle logs in these directories be deleted?
    A: It is possible to delete or rename the alert.log. It is advised to keep certain information for debugging / investigation purposes.
    You can automate the deletion of the logs by running script every period of time (daily / weekly / monthly) keeping only the latest (day / week / month) files/Information.
    Oracle recreates a new alert.log when it is not found (deleted or renamed).
    Also, it is safe move / rename trace file

    Q: Is it possible to restrict the directories to a specific size?
    A: MAX_DUMP_FILE_SIZE specifies the maximum size of trace files. You can change this limit.
    to see the current size:
    SQL> show parameter max_dump_file_size

    to change the current size:
    SQL> alter system set max_dump_file_size='200m';

    The size of the alert log is unlimited and can be deleted / renamed periodically.

    Category: System Management (500)


    • Article last edited: 10/8/2013