Rotational script to rotate the alert log
Script help to rotate the alert log file or any log file.
You will need to provide the following parameter
ORACLE_SID : Name of the database
LOG_FILE: Location of the alert log file
It will rotate according to CRONTAB scheduled and it will rename old alert log file with prefix date.
Note: Last statement in the script FOR remove the older file more than 30 days. you can change +30 to +90 for older than 90 days as your wish you can modified.
Script
#!/bin/bash
DATE_FORMAT=’date +”%Y”-“%m”-“%d”‘
ORACLE_SID=ORCL
LOG_FILE=/data01/alert/log
mv $LOG_FILE/alert$ORACLE_SID.log $LOG_FILE/alert$ORACLE_SID-$DATE_FORMAT.log
touch alert$ORACLE_SID.log
# Delete old log files more than 30 days you can change it by change +30 value to +60 for 60 days older and so on
