Storage Management
Find Oracle Archive Logs Older Than N Days with find -mtime
May 3, 2026 / · 5 min read · Oracle Database Archive Logs Unix Commands Database Maintenance Oracle DBA Storage Management Archived Redo Logs find ·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 …
Read MoreDelete the 500 Oldest Files in a Directory (Oracle DBA)
Apr 29, 2026 / · 5 min read · Oracle Database Unix Commands Oracle DBA Trace Files Audit Files Database Maintenance Storage Management Diagnostic Dest ·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 …
Read MoreOracle RMAN Delete Obsolete Backups with Maintenance Channel
Feb 17, 2026 / · 6 min read · Oracle RMAN Database Backup Backup Retention Storage Management Oracle DBA Recovery Manager Database Administration ·Oracle RMAN Delete Obsolete Backups with Maintenance Channel Purpose The Oracle RMAN (Recovery Manager) commands shown in this script help database administrators manage backup storage by automatically removing old, unnecessary backup files. These commands allocate a maintenance channel for disk operations and delete …
Read MoreOracle RMAN Delete Obsolete - Remove Unneeded Backups
Feb 12, 2026 / · 11 min read · Oracle RMAN Database Backup Retention Policy Storage Management v$backup_piece ·Oracle RMAN Delete Obsolete - Remove Unneeded Backups Purpose A backup disk fills up slowly. Every night adds another set of backup files, and nobody removes the old ones. One morning the nightly backup fails because there is no space left. RMAN already knows which backups are no longer needed, but it does not remove …
Read MoreDelete Archive Log Older Than 5 Days in Oracle RMAN
Feb 5, 2026 / · 4 min read · Oracle Database RMAN Archive Logs Database Maintenance Backup Recovery Oracle DBA Storage Management Database Administration ·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 …
Read MoreChecking All Disks in Diskgroup Data
This SQL code instructs Oracle to perform a thorough check of all disks within the diskgroup named data1 Check the internal consistency of a diskgroup SQL Code 1alter diskgroup data1 check all 2/ Sample Oracle Output 1no rows selected 2SQL> Description of the Oracle Database SQL code Purpose: To initiate a …
Read MoreOracle ASM Disk Balancing: Monitor with v$asm_operation
Jan 14, 2024 / · 2 min read · oracle asm oracle disk information storage management diskgroup v$asm_operation ·Monitoring ASM Operations in Oracle Database, Using thev$asm_operationView SQL Code 1select * 2from v$asm_operation 3/ Mount/dismount disk groups 1alter diskgroup all mount 2/ 1alter diskgroup data1 mount 2/ 1alter diskgroup all dismount 2/ 1alter diskgroup data1 dismount 2/ Description of the Oracle Database SQL code …
Read MoreOracle ASM: Drop a Disk Group with DROP DISKGROUP
Removing a Disk Group Permanently in Oracle Database, The drop diskgroup Command SQL Code 1drop diskgroup <name> including contents 2/ Description of the Oracle Database SQL code Purpose: The primary purpose of this SQL code is to permanently remove an entire disk group, identified by its name, from the Oracle database …
Read MoreOracle ASM: Add a Disk to an Existing Disk Group
Jan 10, 2024 / · 2 min read · Oracle ASM Oracle Disk Information Storage Management diskgroup v$asm_disk ·Expanding Storage Capacity in Oracle Database, Adding a Disk to Diskgroup Data1 SQL Code Note: Wildcards can be used for raw device names (eg. raw* 1alter diskgroup data1 2add disk '/dev/raw/raw4' 3/ Sample Oracle Output 1no rows selected 2SQL> Description of the Oracle Database SQL code Purpose: The primary purpose of …
Read MoreQuerying ASM Disk Information in Oracle
Jan 7, 2024 / · 6 min read · Oracle ASM Oracle Disk Information Storage Management v$asm_disk v$asm_disk_stat v$asm_diskgroup v$asm_file v$asm_operation ·Querying ASM Disk Information in Oracle A disk group that reports plenty of free space can still be one disk failure away from trouble, and a LUN the storage team says is ready can still be invisible to ASM. Both show up in one query against v$asm_disk: the per-disk free space, and the group 0 rows for disks not yet in …
Read More