#! /usr/bin/ksh

export ORACLE_SID=$1
MIPATH=`dirname $0`
MIDATE=`date +%Y%m%d_%H%M%S`
MILOG="$MIPATH/restore_${ORACLE_SID}_${MIDATE}.log"

rman target / nocatalog <<EOF$ORACLE_SID |tee $MILOG
shutdown immediate
startup mount
crosscheck backup;
run  {
allocate channel c1 type disk;
allocate channel c2 type disk;
restore database;
release channel c1;
release channel c2;
}
recover database;
alter database open;
EOF$ORACLE_SID

NBERR=`grep -c "RMAN-00569" $MILOG`
if [ $NBERR -eq 0 ];then
  echo "Fin normale du restore et recover de $ORACLE_SID" |tee -a $MILOG
else
  echo "Erreur(s) detectees lors du restore et/ou recover de $ORACLE_SID" |tee -a $MILOG
fi
exit $NBERR