cat /opt/app/DBNAME/admin/DBNAME/rman/clientscripts/start_hotbackup.DBNAME
#!/bin/ksh
TIMESTAMP=`date +%a%b%d`
OUTF= /opt/app/DBNAME/admin/DBNAME/logs/rmanLogs/Veritas_Netbackup_${NB_ORA_PC_SCHED}_$TIMESTAMP.log
find  /opt/app/DBNAME/admin/DBNAME/logs/rmanLogs -name "Veritas_Netbackup_*.log*" -mtime +35 -exec rm -Rf {} \;
{ # output block
. /opt/app/DBNAME/.profcron

ORACLE_SID=DBNAME
NB_ORA_SCRIPTS=/opt/app/DBNAME/admin/DBNAME/rman/clientscripts
NLS_DATE_FORMAT='DD-MON-YYYY HH24:MI:SS'
echo
echo "`date` ----Start of backup script----"
echo "ORACLE_SID: $ORACLE_SID"
echo "ORACLE_HOME: $ORACLE_HOME"

if [ ${NB_ORA_FULL} -eq 1 ]
then
        echo "Script_Backup_Level 0 (Full)";
        CMDFILE=${NB_ORA_SCRIPTS}/hotb_lev0
        BACKUP_LEVEL=0
elif [ ${NB_ORA_CINC} -eq 1 ]
then
        echo "Script_Backup_Level 1 (Cumulative)";
        CMDFILE=${NB_ORA_SCRIPTS}/hotb_lev1
        BACKUP_LEVEL=1
elif [ ${NB_ORA_INCR} -eq 1 ]
then
        echo "Script_Backup_Level 2 (Differential)";
        CMDFILE=${NB_ORA_SCRIPTS}/hotb_lev2
        BACKUP_LEVEL=2
else
        echo "User Backup: Script_Backup_Level 0 (Full)";
        CMDFILE=${NB_ORA_SCRIPTS}/hotb_lev0
        BACKUP_LEVEL=0
        NB_ORA_SCHED=${NB_ORA_SCHED:="Full"}
        NB_ORA_FULL=1
        NB_ORA_SCHEDULED=0
fi

# temporary setting until backload is complete
#CMDFILE=${NB_ORA_SCRIPTS}/hotb_arch

# Get next sequence from rman tracking schema on bthcat
BUID_VALUE=`sqlplus -silent rman_status/statusman@bthcat <<END
set pagesize 0 feedback off verify off heading off echo off
select buid_seq.nextval from dual;
exit;
END`
# Insert record into backup_status database on bthcat
INSERT_REC=`sqlplus -silent rman_status/statusman@bthcat <<END
insert into backup_status (buid, host, sid, backup_level, start_time, status) -
  values ($BUID_VALUE, '$HOSTNAME', 'DBNAME', $BACKUP_LEVEL, sysdate, 'W');
exit;
END`

RMANCMD="${ORACLE_HOME}/bin/rman target / rcvcat ${RMAN_ADM}@bthcat cmdfile $CMDFILE"

echo
echo "% $RMANCMD"
echo

su DBNAME -c "
export ORACLE_SID=$ORACLE_SID
export NB_ORA_SCHED=${NB_ORA_PC_SCHED}DB
env | grep 'NB_'
$RMANCMD
exit $?
"

RETURN_STATUS=$?

echo
echo "`date` ----End of backup script----"
echo
echo "exit $RETURN_STATUS"

} >> $OUTF 2>&1

if [ $RETURN_STATUS -eq 0 ]; then
  echo "$NB_ORA_PC_SCHED RMAN backup successful for $ORACLE_SID on $HOSTNAME at `date '+%d%h%y %H:%M:%S'`" | mailx -s "RMAN backup successful" $DBA
  # Update rman status tracking schema on bthcat
  UPDATE_REC=`sqlplus -silent rman_status/statusman@bthcat <<END
  update backup_status set (end_time, status) = (select sysdate, 'S' from dual) -
  where buid = $BUID_VALUE;
  exit $RETURN_STATUS;
  END`
  else
    sed -n '/RMAN-00571/,/exit 1/p' $OUTF | mailx -s "$NB_ORA_PC_SCHED RMAN backup failed for $ORACLE_SID on $HOSTNAME" $DBA $DBALIST
    UPDATE_REC=`sqlplus -silent rman_status/statusman@bthcat <<END
    update backup_status set (end_time, status) = (select sysdate, 'F' from dual) -
    where buid = $BUID_VALUE;
    exit $RETURN_STATUS;
  END`
fi
exit $RETURN_STATUS