Shell Programming and Scripting

cnt=`ps -ef |grep pmon|grep -v grep|awk 'END {{print NR}}'`
cnt2=`ps -ef |grep tns|grep -v grep|awk 'END {{print NR}}'`
if [ $cnt = 2 ]
then
        if [ $cnt2 = 1 ]
        then

                rman target/ catalog recdb/recdb@recdb cmdfile report_need_backup.sql > report_need_backup.txt
                echo "=======================================================================================" > report_need_backup_email.txt

                awk '/2>/, /dbf/ {print}' report_need_backup.txt|grep -v "2>" >> report_need_backup_email.txt
                echo "=======================================================================================" >> report_need_backup_email.txt


                echo -e "\t\t=======================================================================================" >> report_need_backup_email2.txt
            grep -v ^= report_need_backup_email.txt|while read line
            do
                    echo -e  "\t\t |$line                    | " >> report_need_backup_email2.txt
            done

                echo -e  "\t\t=======================================================================================" >> report_need_backup_email2.txt
                mail -s "TABLESPACE NEEDED TO BE BACKED UP" oracle < report_need_backup_email2.txt
        else
                mail -s "LISTENER IS DOWN " oracle < no_body.log
        fi
else

        mail -s "EITHER OF THE DATABSE IS DOWN " oracle < no_body.log

fi

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------
8    0     /u02/backup/perfstat01.dbf
=======================================================================================
*****************************************************
            =======================================================================================
                |RMAN retention policy will be applied to the command                    |
                |RMAN retention policy is set to redundancy 1                    |
                |Report of files with less than 1 redundant backups                    |
                |File #bkps Name                    |
                |---- ----- -----------------------------------------------------                    |
                |8    0     /u02/backup/perfstat01.dbf                    |
                =======================================================================================

                |RMAN retention policy will be applied to the command                                                         |
                |RMAN retention policy is set to redundancy 1                                                                             |
                |Report of files with less than 1 redundant backups                              |
                |File #bkps Name                                                                           |
                |---- ----- -----------------------------------------------------        |
                |8    0     /u02/backup/perfstat01.dbf                                                                                                      |
                =======================================================