Managing Disk Space in Oracle DB drives

Overview

The article details a critical issue involving an alert on Oracle DB1 due to excessive disk space usage.

Solution

It was discovered that the /u01 partition on Oracle DB1 was occupied by more than 70% disk space.

It was observed that CSV backup files from the Voltdb server to Oracle server were occupying substantial space. The files were found to be uncompressed, leading to high disk usage.

A regular file-zipping process needs to be available. To prevent future space issues, a cron job should be added to automatically zip files older than two days and remove backup files older than ten days.

Any issues dealing with DB partitions should be discussed/elevated to the DB team. After consulting with the DBA, the team decided to zip files that were more than two days old.

Summary

Any issues dealing with DB partitions should be discussed/elevated to the DB team. To prevent future space issues, a cron job should be added to automatically zip files older than two days and remove backup files older than ten days.