How to clean up a full Oracle log file?

2 years ago
Isabella Edwards
2 minutes

The primary types of log files in Oracle databases are archived log files and online redo log files. It is important to promptly clear log files once they are full to free up space. The following are the steps for cleaning Oracle log files.

  1. Clean up and archive log files.
  2. Connect to the database using SQL*Plus.
  3. Retrieve the current archived log files and their paths: SELECT * FROM V$ARCHIVED_LOG;
  4. Delete old archived log files using RMAN or operating system commands. On UNIX/Linux systems, you can use a command like the following to delete expired archived log files: rm -rf /path/to/archive/log
  5. To verify that the cleanup is complete using SQL*Plus: SELECT COUNT(*) FROM V$ARCHIVED_LOG;
  6. Clean up and redo online log files.
  7. Retrieve the current online redo log group and its members: SELECT * FROM V$LOG;
  8. Switch to the next online redo log group: ALTER SYSTEM SWITCH LOGFILE;
  9. Remove the old online redo log group that is no longer in use: ALTER DATABASE DROP LOGFILE GROUP n;
  10. Check the completion of cleaning in SQL*Plus by running: SELECT * FROM V$LOG;

It is important to be cautious when cleaning up Oracle log files to avoid any impact on the normal operation of the database. It is recommended to backup the database before cleaning to prevent any unexpected issues.

bannerAds