Today, I will be sharing one handy shell script that can be used to delete old archive logs. Considering the archive logs are already backed up and not required for any recovery purpose. In the following example i will be deleting archive that are 5 days old.
vi archive_del.sh
|
#!/bin/bash # Set the
number of days DAYS_OLD=5 # Function to
delete archive logs older than specified days for a given ORACLE_SID delete_old_archivelogs()
{ ORACLE_SID=$1 export ORACLE_SID echo "Deleting archive logs older than
$DAYS_OLD days for database $ORACLE_SID..." rman target / <<EOF CROSSCHECK ARCHIVELOG ALL; DELETE NOPROMPT ARCHIVELOG ALL COMPLETED
BEFORE 'SYSDATE-$DAYS_OLD'; EXIT; EOF if [ $? -eq 0 ]; then echo "Archive logs older than
$DAYS_OLD days deleted successfully for database $ORACLE_SID." else echo "Failed to delete archive logs
for database $ORACLE_SID." fi } # Source the
Oracle environment variables source
/usr/local/bin/oraenv # Get the
list of running Oracle database instances (ORACLE_SID) excluding ASM ORACLE_INSTANCES=$(ps
-ef | grep pmon | grep -v grep | grep -v asm | awk '{print $9}' | cut -d'_'
-f3) # Loop
through each instance and delete old archive logs for SID in
$ORACLE_INSTANCES; do delete_old_archivelogs $SID done |
Schedule the above script in crontab as per your requirement.
