• 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