#!/bin/bash

if [[ $# == 1 ]]
then
  target=$1
else
 echo "usage $0 target"
 exit
fi

sid=${target}
sid1=${target}1

export ORACLE_SID=${sid1}
export ORACLE_HOME=`/usr/local/bin/dbhome $sid`
export PATH=$ORACLE_HOME/bin:/bin:/usr/local/bin

logfile=/var/log/oracle/rman_clone_${sid}.out
echo "DBNAME = $sid" > $logfile

rmlfile=/var/log/oracle/rman_clone_${sid}.log
rcvfile=/home/oracle/bin/clone${sid}.rcv
errfile=/var/log/oracle/rman_clone_${sid}.err
tmsfile=/var/log/oracle/rman_clone_${sid}.time

[[ -f $rcvfile ]]
if [ "$?" != 0 ]
then
  echo "ERROR: ${rcvfile} not found"
  exit
fi

echo "running PROD archivelog backup prior to clone operations" >> $logfile
$HOME/rman_scripts/run_rman_script $HOME/rman_scripts/11gR2_arclogs_clone.rcv vmspd1


echo "restarting DB for clone operations" >> $logfile
$ORACLE_HOME/bin/sqlplus /nolog << EOS >> $logfile
connect /as sysdba
alter system set cluster_database=false scope=spfile;
shutdown immediate
startup nomount
exit
EOS

echo -n "begin duplicate : " >> $tmsfile
date >> $tmsfile

$ORACLE_HOME/bin/rman log $rmlfile nocatalog @$rcvfile

echo -n "end   duplicate : " >> $tmsfile
date >> $tmsfile

egrep "RMAN-|ORA-" $rmlfile > $errfile
if [ -s $errfile ]
then
        /bin/mailx -s "Oracle Clone ${sid}" oracle_rman@datapipe.com < $rmlfile
fi

echo "performing post database clone operations" >> $logfile
sqlplus /nolog << EOS >> $logfile
connect /as sysdba
alter system set cluster_database=true scope=spfile;
shutdown immediate
startup;
@/home/oracle/sql/${sid}_temp.sql
select instance_name from v\$instance;
alter system switch logfile;
set scan off
@/home/oracle/psoft_sql/${sid}_refresh.sql
exit
EOS

if [ -s $logfile ]
then
  /bin/mailx -s "${sid} post clone log" oracle_dba@datapipe.com < $logfile
  /bin/mailx -s "${sid} post clone log" IT@provade.com < $logfile
fi

#
# bounce the psoft infrastructure
#
rmffile=/var/log/oracle/psoft_clone_${sid}.log

case "${sid}" in

 vmssp)         /usr/bin/ssh -t psoft@10.40.10.170 '$HOME/bin/rman_rmcache.sh' > $rmffile
                ;;

 vmspvw)        /usr/bin/ssh -t psoft@10.40.10.171 '$HOME/bin/rman_rmcache.sh' > $rmffile
                ;;

 vmscfg)        /usr/bin/ssh -t psoft@10.40.10.172 '$HOME/bin/rman_rmcache.sh' > $rmffile
                ;;

 *)             /bin/echo "Invalid Option"
                ;;

esac


if [ -s $rmffile ]
then
  /bin/mailx -s "${sid} post clone psoft bounce" oracle_dba@datapipe.com < $rmffile
  /bin/mailx -s "${sid} post clone psoft bounce" IT@provade.com < $rmffile
fi

exit
