ORACLE ADRCI

#!/bin/bash

# Author: Dawid Mocek
# All rights reserved


# ! Skrypt uruchamia sie przez crontaba user`a oracle !#




# Removes ALERT|INCIDENT|TRACE|CDUMP|HM|UTSCDMP messages for:
# diag/rdbms/meddb/meddb1
# diag/rdbms/admdb/admdb1
# diag/rdbms/dwdb/dwdb1
# instances


# Remove messages older than HOURS. Safely can be changed by you
# eg. 420h = 7 days
HOURS=420

# Do not change values below :
ORACLE_BASE=/appdb/oracle
ORACLE_HOME=/appdb/oracle/product/11.2.0/dbhome_1
ADRCI_CMD=/appdb/oracle/product/11.2.0/dbhome_1/bin/adrci
MINUTES=0

MEDDB_HOME=diag/rdbms/inst1/inst11
ADMDB_HOME=diag/rdbms/inst2/inst22


# MAIN

let "MINUTES = HOURS * 60"

if [ "$MINUTES" -gt "0" ]; then

    if [ -d "$ORACLE_BASE/$MEDDB_HOME" ]; then
    echo "Purging $MEDDB_HOME"
    MED_CMD="SET HOMEPATH $MEDDB_HOME; PURGE -AGE $MINUTES -TYPE ALERT; PURGE -AGE $MINUTES -TYPE INCIDENT; PURGE -AGE $MINUTES -TYPE TRACE; PURGE -AGE $MINUTES -TYPE CDUMP; PURGE -AGE $MINUTES -TYPE HM; PURGE -AGE $MINUTES -TYPE UTSCDMP"
    MED_RET=(`$ADRCI_CMD exec=$MED_CMD`)
    fi

    if [ -d "$ORACLE_BASE/$ADMDB_HOME" ]; then
        echo "Purging $ADMDB_HOME"
        ADM_CMD="SET HOMEPATH $ADMDB_HOME; PURGE -AGE $MINUTES -TYPE ALERT; PURGE -AGE $MINUTES -TYPE INCIDENT; PURGE -AGE $MINUTES -TYPE TRACE; PURGE -AGE $MINUTES -TYPE CDUMP; PURGE -AGE $MINUTES -TYPE HM; PURGE -AGE $MINUTES -TYPE UTSCDMP"
    ADM_RET=(`$ADRCI_CMD exec=$ADM_CMD`)
    fi

    if [ -d "$ORACLE_BASE/$DWDB_HOME" ]; then
        echo "Purging $DWDB_HOME"
        DW_CMD="SET HOMEPATH $DWDB_HOME; PURGE -AGE $MINUTES -TYPE ALERT; PURGE -AGE $MINUTES -TYPE INCIDENT; PURGE -AGE $MINUTES -TYPE TRACE; PURGE -AGE $MINUTES -TYPE CDUMP; PURGE -AGE $MINUTES -TYPE HM; PURGE -AGE $MINUTES -TYPE UTSCDMP"
    DW_RET=(`$ADRCI_CMD exec=$DW_CMD`)
    fi
fi