Database Maintenance

Find Oracle Archive Logs Older Than N Days with find -mtime Purpose Oracle databases in archivelog mode write a stream of .ARC (archived redo log) files to a destination directory. The directory fills up. When it fills up, the database hangs. The four find -mtime commands below let a DBA list, delete, compress, or move …

Delete the 500 Oldest Files in a Directory (Oracle DBA) Purpose Oracle's diagnostic destination (DIAGNOSTIC_DEST), audit file destination (AUDIT_FILE_DEST, also known as adump), and per-process trace directories collect thousands of small files over time. Inode counts, not bytes, are usually the limit that bites first …

Delete Archive Log Older Than 5 Days in Oracle RMAN Purpose The DELETE NOPROMPT ARCHIVELOG UNTIL TIME command removes old archive log files from your Oracle database to free up disk space and maintain storage efficiency. This RMAN (Recovery Manager) command automatically deletes archive logs that are older than a …

Oracle RMAN Crosscheck Backup Command - Verify Backup Availability Purpose The CROSSCHECK BACKUP command is an essential Oracle RMAN (Recovery Manager) tool that verifies whether backup files recorded in the RMAN repository still physically exist on storage media. This command synchronizes the logical records in your …

Oracle RMAN Unregister Database from Recovery Catalog Purpose Unregistering a database from an Oracle RMAN (Recovery Manager) recovery catalog removes all backup metadata and database information from the catalog repository. This process is essential when a database is decommissioned, no longer needs catalog-based …

How to Disable and Enable Oracle Archive Log Destinations Purpose The Oracle commands for disabling and enabling archive log destinations allow database administrators to control the availability of archive destinations without removing the configuration. These commands are commonly used in Oracle Data Guard …