#!/bin/ksh
#*******************************************************************************
#                          KSH PROGRAM
#*******************************************************************************
#
#    PROGRAM ID           : prod_dump_status.ksh
#
#D   DESCRIPTION          : Provide an overview of the production dumps on the
#D                          NAS share
#D
#
#    INPUT PARAMETERS     : none
#
#    OUTPUT PARAMETERS    : none
#
#
#    INPUT FILES          : /app/orcl/oradata/ORCL/dump/ORCL_PROD_DUMP/*
#                           /app/orcl/oradata/ORCL/dump/ORCL_PROD_DUMP/ARCHIVE/*
#
#    OUTPUT FILES         : none
#
#
#    SPECIAL LOGIC NOTES  : none
#
#*******************************************************************************
#                        MODIFICATION LOG
#
#
#    DATE                               SE
#       DESCRIPTION
#    ---------------------------------------------------------------------------
#    Thu Jan 29 11:42:55 CET 2015       (Hajo)
#       add gzip to the program aliasses
#    ---------------------------------------------------------------------------
#    Mon Jan 19 17:42:18 CET 2015       (Hajo)
#       initial version
#    ---------------------------------------------------------------------------
#
#*******************************************************************************


#*******************************************************************************
# INITIALIZATION
#*******************************************************************************
export s_myName=`basename $0`                               # remember my name

export s_prod_dump_dir=/app/orcl/oradata/ORCL/dump/ORCL_PROD_DUMP
#export s_prod_dump_dir=/app/orcl/oradata/ORCL/dump/hruehl/tm2
export s_prod_dump_filename=ORCL_FULL


#------------------------------
# program aliasses
#------------------------------
alias awk='/usr/bin/awk'
alias gzip='/usr/bin/gzip'
alias ls='/bin/ls'
alias sed='/usr/bin/sed'


#*******************************************************************************
# MAIN
#*******************************************************************************
# change to dump directory
cd ${s_prod_dump_dir}/
echo "--------------------------------------------------------------------------------"
echo "SPACE USAGE <${s_prod_dump_dir}/>:"
df -h .
echo "--------------------------------------------------------------------------------"
echo "FILES IN DIRECTORY <${s_prod_dump_dir}/>:"
ls -al ${s_prod_dump_filename}*.* > /dev/null 2>&1
if [[ $? -ne 0 ]]
then
    echo "--- SORRY, no files found on <${s_prod_dump_dir}/> ---"
else
    ls -al ${s_prod_dump_filename}*
fi

# change to ARCHIVE directory
cd ARCHIVE/
echo "--------------------------------------------------------------------------------"
echo "FILES IN ARCHIVE DIRECTORY <${s_prod_dump_dir}/ARCHIVE/>:"
ls -al ${s_prod_dump_filename}*

# change to dump directory and show a summary of the current export log file
cd ${s_prod_dump_dir}/
ls -al ${s_prod_dump_filename}*.log > /dev/null 2>&1
if [[ $? -ne 0 ]]
then
    echo "--------------------------------------------------------------------------------"
    echo "--- SORRY, no log file found on <${s_prod_dump_dir}/> ---"
    exit
else
    s_latest_log=$(ls -al ORCL_FULL*.log | awk '{print $9}' | tail -1)
    echo "--------------------------------------------------------------------------------"
    echo "ORA- ERRORS (CONSOLIDATED) IN LOG FILE <${s_latest_log}>:"
    grep '^ORA-' ${s_latest_log} | sort -u
    echo "--------------------------------------------------------------------------------"
    echo "LAST 10 LINES OF LOG FILE <${s_latest_log}>:"
    tail -10 ${s_latest_log}
fi


#******************************************************************************
# FINE
#*******************************************************************************
exit