export ORATAB=/etc/oratab

###START OF LOOP
for db in `egrep -i ":NBU" $ORATAB | grep -v "^#" | grep -v "\*" | cut -d":" -f1 | sort | uniq`
do
  echo "processing database: $db"

export ORATAB=/etc/oratab

### Look for a list of databases successfully backed up today.  Create if it doesn't exist.
comp=$(date "+Completed.%Y%m%d")
if [ ! -f $comp ]
then    touch $comp
fi

###START OF LOOP
for db in $(awk -F: '$0 ~ /:[Nn][Bb][Uu]/ && $1 !~ /^#/ && $0 !~ /[*]/ {print $1}' $ORATAB | sort -u)
do
  echo "processing database: $db"
   if [ $(grep -c -e "^$db\$" $comp) -gt 0 ]
   then   printf "Skipping %s: It has already been backed up.\n" "$db"
          continue
   fi

# ---------------------------------------------------------------------------
# Log the completion of this script.
# ---------------------------------------------------------------------------

  if [ "$RSTAT" = "0" ]
  then
    LOGMSG="Backup successfully $ORACLE_SID"
    echo $LOGMSG|mailx -s "BACKUP Status ..." abc@company.com
  else

# ---------------------------------------------------------------------------
# Log the completion of this script.
# ---------------------------------------------------------------------------

  if [ "$RSTAT" = "0" ]
  then
    LOGMSG="Backup successfully $ORACLE_SID"
    echo $LOGMSG|mailx -s "BACKUP Status ..." abc@company.com
    echo $db >> $comp
  else