Rotate alert logs (alertlog) with shell script - Revision history

Stuart at 11:19, 18 October 2013

2013-10-18T11:19:23Z

Stuart at 11:18, 18 October 2013

2013-10-18T11:18:49Z

Stuart at 11:17, 18 October 2013

2013-10-18T11:17:15Z

Stuart at 13:16, 15 October 2013

2013-10-15T13:16:14Z

Stuart at 14:00, 10 October 2013

2013-10-10T14:00:49Z

Stuart at 13:57, 10 October 2013

2013-10-10T13:57:13Z

Stuart: Created page with "

 #!/bin/ksh # ============================================================================== # Name         : alertlog_rotate.ksh # Description  : Rotates the Oracle aler..."

2013-10-10T11:42:54Z

Created page with "<pre> #!/bin/ksh # ============================================================================== # Name : alertlog_rotate.ksh # Description : Rotates the Oracle aler..."

New page

<pre>
#!/bin/ksh
# ==============================================================================
# Name : alertlog_rotate.ksh
# Description : Rotates the Oracle alert log
#
# Parameters : -s sid
#
# Notes : Ensures at least a month is kept even if someone
# runs the script every 10 minutes
#
# Modification History
# ====================
# When Who What
# ========= ================= ==================================================
# 12-SEP-13 Stuart Barkley Created
# ==============================================================================

PROGNAME=`basename $0`
OS=`uname`
ORATAB="/etc/oratab"
VERSIONS=7

ID=`which id`
AWK=`which awk`
GREP=`which grep`
[[ "${OS}" == "SunOS" ]] && ID='/usr/xpg4/bin/id'
[[ "${OS}" == "SunOS" ]] && AWK='/usr/xpg4/bin/awk'
[[ "${OS}" == "SunOS" ]] && GREP='/usr/xpg4/bin/grep'

[[ ! -r /etc/oratab ]] && echo "oratab is not where we want it. Please run 'ln -s /var/opt/oracle/oratab $ORATAB' as root and try again" && exit 1

# -------------------------
# get the arguments, if any
# -------------------------
while getopts "s:" OPT
do
case "$OPT" in
s) export ORACLE_SID=$OPTARG;;
esac
done
shift $((OPTIND-1))

# --------------------------------
# check we have required arguments
# --------------------------------
[[ -z $ORACLE_SID ]] && echo "Not all manatory parameters supplied. Usage: $0 -s <SID>" && exit 1

# -------------------------------
# check the supplied SID is valid
# -------------------------------
$GREP -q -E "^$ORACLE_SID" $ORATAB
[[ $? -ne 0 ]] && echo "$ORACLE_SID not found in $ORATAB, please verify SID and run again" && exit 1

# ------------------------------------------
# check we are running as the database owner
# ------------------------------------------
DB_STARTED_AS=`ps -ef | $GREP [p]mon | $GREP $ORACLE_SID | $AWK '{print $1}'`
WE_ARE=`$ID -un`
[[ "$DB_STARTED_AS" != "$WE_ARE" ]] && echo "You are ${WE_ARE}. Please run as the database owner (${DB_STARTED_AS})." && exit 1

# -------------------------------------------------------------------
# setup the Oracle environment so we can find the alert log directory
# -------------------------------------------------------------------
ORAENV_ASK=NO
. oraenv

# -----------------------------------------------
# Now we can get the ALERT_PATH from the database
# -----------------------------------------------
ALERT_PATH=`sqlplus -s "/ as sysdba"<<EOSQL
set pages 0
set feedb off
select value from v\\$diag_info where lower(name) = 'diag trace';
EOSQL
`
[[ $? -ne 0 ]] && echo "Problem connecting to SQL*Plus. Has to be run from a privileged user account (oracle, oraibm etc.)" && exit 1

cd $ALERT_PATH
[[ $? -ne 0 ]] && echo "ALERT_PATH not set or set to a non-existing directory (${ALERT_PATH}), please verify and run again" && exit 1

# -------------------------------------------------
# Ensure the oldest alert log is older than a month
# -------------------------------------------------
if [[ -e "alert_${ORACLE_SID}.log.${VERSIONS}" ]]; then
CNT=`find . -name "alert_${ORACLE_SID}.log.${VERSIONS}" -mtime +30 | wc -l`
[[ $CNT -eq 0 ]] && echo "Oldest alert log is not a month old yet, stopping." && exit 1
fi

# ------------------------------------------------------
# rotate the old logs. 6->7, 5->6 etc... down until 1->2
# ------------------------------------------------------
i=$VERSIONS
while [[ $i -ge 2 ]]; do
if [[ -e alert_$ORACLE_SID.log.$((i-1)) ]]; then
mv alert_$ORACLE_SID.log.$((i-1)) alert_$ORACLE_SID.log.$i
[[ $? -ne 0 ]] && echo "Cannot rename alert_$ORACLE_SID.log.$((i-1)) to alert_$ORACLE_SID.log.$i, permissions?" && exit 1
fi
i=$((i-1))
done

# and finally, rotate the current log
cp alert_$ORACLE_SID.log alert_$ORACLE_SID.log.1
[[ $? -ne 0 ]] && echo "Cannot rename alert_$ORACLE_SID.log to alert_$ORACLE_SID.log.1, permissions?" && exit 1
echo > alert_$ORACLE_SID.log
</pre>

@@ Line 40: / Line 40: @@
 # -------------------------------------------
-# dont run around trying to find it,
+# dont run around trying to find oratab,
 # just get them to put it in a standard place
 # -------------------------------------------

← Older revision		Revision as of 11:18, 18 October 2013
Line 38:		Line 38:
	[[ "${OS}" == "SunOS" ]] && GREP='/usr/xpg4/bin/grep'		[[ "${OS}" == "SunOS" ]] && GREP='/usr/xpg4/bin/grep'

		+
		+	# -------------------------------------------
		+	# dont run around trying to find it,
		+	# just get them to put it in a standard place
		+	# -------------------------------------------
	[[ ! -r $ORATAB ]] && echo "oratab is not where we want it. Please run 'ln -s <wherever your oratab is> $ORATAB' as root and try again" && exit 1		[[ ! -r $ORATAB ]] && echo "oratab is not where we want it. Please run 'ln -s <wherever your oratab is> $ORATAB' as root and try again" && exit 1

← Older revision		Revision as of 11:17, 18 October 2013
Line 38:		Line 38:
	[[ "${OS}" == "SunOS" ]] && GREP='/usr/xpg4/bin/grep'		[[ "${OS}" == "SunOS" ]] && GREP='/usr/xpg4/bin/grep'

−	[[ ! -r ~~/etc/oratab~~ ]] && echo "oratab is not where we want it. Please run 'ln -s ~~/var/opt/oracle/~~oratab $ORATAB' as root and try again" && exit 1	+	[[ ! -r $ORATAB ]] && echo "oratab is not where we want it. Please run 'ln -s <wherever your oratab is> $ORATAB' as root and try again" && exit 1

@@ Line 1: / Line 1: @@
 <pre>
-#!/bin/ksh
+#!/usr/bin/ksh
 # ==============================================================================
-# Name         : alertlog_rotate.ksh
+# Name         : maint_rotate_alertlog.ksh
 # Description  : Rotates the Oracle alert log
+#
-# Parameters   : -s sid
+# Parameters   : -s (mandatory) sid
+#
 # Notes        : Ensures at least a month is kept even if someone
@@ Line 18: / Line 21: @@
 ORATAB="/etc/oratab"
-VERSIONS=7             # number of alertlog history files
+DEF_VERSIONS=7         # default number of alertlog history files
-ROTATE_PERIOD=7        # minimum number of days between rotations
+DEF_ROTATE_PERIOD=7    # default number of days between rotations
-ALERTLOG_AGE=30        # minimum number of days before oldest log can be deleted
+DEF_ALERTLOG_AGE=30    # default number of days before oldest log can be deleted
 # =======================================
@@ Line 42: / Line 44: @@
 # get the arguments, if any
 # -------------------------
-while getopts "s:" OPT
+while getopts "s:v:p:a:" OPT
 do
      case "$OPT" in
      s) export ORACLE_SID=$OPTARG;;
      esac
 done
@@ Line 55: / Line 60: @@
 # --------------------------------
 [[ -z $ORACLE_SID ]] && echo "Not all mandatory parameters supplied. Usage: $0 -s <SID>" && exit 1
@@ Line 99: / Line 112: @@
 if [[ -e "alert_${ORACLE_SID}.log.${VERSIONS}" ]]; then
      CNT=`find . -name "alert_${ORACLE_SID}.log.${VERSIONS}" -mtime +${ALERTLOG_AGE} | wc -l`
-     [[ $CNT -eq 0 ]] &&  echo "Oldest alert log is not ${ALERTLOG_AGE} days old yet, stopping." && exit 1
+     if [[ $CNT -eq 0 ]]; then
 fi
 # --------------------------------------------------
@@ Line 107: / Line 127: @@
 if [[ -e "alert_${ORACLE_SID}.log.1" ]]; then
      CNT=`find . -name "alert_${ORACLE_SID}.log.1" -mtime +${ROTATE_PERIOD} | wc -l`
-     [[ $CNT -eq 0 ]] &&  echo "Last alert log rotation was less than ${ROTATE_PERIOD} days ago, stopping." && exit 1
+     [[ $CNT -eq 0 ]] &&  echo "Last alert log rotation was less than ${ROTATE_PERIOD} days ago, nothing to do here." && exit 1
 fi

@@ Line 54: / Line 54: @@
 # check we have required arguments
 # --------------------------------
-[[ -z $ORACLE_SID ]] && echo "Not all manatory parameters supplied. Usage: $0 -s <SID>" && exit 1
+[[ -z $ORACLE_SID ]] && echo "Not all mandatory parameters supplied. Usage: $0 -s <SID>" && exit 1
@@ Line 60: / Line 60: @@
 # check the supplied SID is valid
 # -------------------------------
-$GREP -q -E "^$ORACLE_SID" $ORATAB
+$GREP -q -E "^${ORACLE_SID}:" $ORATAB
 [[ $? -ne 0 ]] && echo "$ORACLE_SID not found in $ORATAB, please verify SID and run again" && exit 1

@@ Line 17: / Line 17: @@
 # ==============================================================================
 ORATAB="/etc/oratab"
-VERSIONS=7
+VERSIONS=7             # number of alertlog history files
 ID=`which id`
 AWK=`which awk`
@@ Line 88: / Line 94: @@
-# -------------------------------------------------
+# ---------------------------------------------------
-# Ensure the oldest alert log is older than a month
+# Ensure the oldest alert log is older than permitted
-# -------------------------------------------------
+# ---------------------------------------------------
 if [[ -e "alert_${ORACLE_SID}.log.${VERSIONS}" ]]; then
-     CNT=`find . -name "alert_${ORACLE_SID}.log.${VERSIONS}" -mtime +30 | wc -l`
+     CNT=`find . -name "alert_${ORACLE_SID}.log.${VERSIONS}" -mtime +${ALERTLOG_AGE} | wc -l`
-     [[ $CNT -eq 0 ]] &&  echo "Oldest alert log is not a month old yet, stopping." && exit 1
+     [[ $CNT -eq 0 ]] &&  echo "Oldest alert log is not ${ALERTLOG_AGE} days old yet, stopping." && exit 1
 fi