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.
Leave a Reply