my script is as follows
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
*****************************************************
output of report_need_backup_email.txt is
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 |
=======================================================================================
**************************************************
I require it like
=======================================================
|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 |
=======================================================
***********************************************************************************************************************
how to make end of each line as above it is not showing in the post but I want "|" at the end of each line in straight line like the way they appear at start of each line