#!/bin/bash

#echo "** This script is no longer used IF this db has a dr side"
#echo "** Please use the one in /home/oracle/flashback"
#exit 0

export DATABASE=bcmspqa
export ORACLE_SID=bcmspqa1
export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3.14
export PATH=$PATH:$PATH:$ORACLE_HOME/bin

#echo "*** Dumping awr report"
#sqlplus "/ as sysdba" @report_awr

#echo "*** Dumping awr raw data"
#sqlplus "/ as sysdba" @dump_awr

echo "*** Stopping database"
srvctl stop database -d $DATABASE

echo "*** Starting database in mount mode"
srvctl modify database -d $DATABASE -s mount
srvctl start database -d $DATABASE

echo "*** Flashback running"
rman target / cmdfile=reset1_July.rman

echo "*** Stopping database"
srvctl stop database -d $DATABASE

echo "*** Resetting logs"
rman target / cmdfile=reset2.rman

echo "*** Starting database normal"
srvctl modify database -d $DATABASE -s open
srvctl start database -d $DATABASE

#echo -e "Subject: Automated message: Reset of ertload has completed\n\nAutomated message: Reset of eztoload has completed" | /usr/sbin/sendmail "seth_hartbecke@mcgraw-hill.com,craig_willner@mcgraw-hill.com,anas_madharsha@mcgraw-hill.com,travis_michels@mcgraw-hill.com,srava