OraMatt: YABAOracle

#!/bin/bash -x
#
#
#
# MattDee
# June 29, 2011
#
#
# Flashback database to Restore Points before Testing
#
#
#
for i in dbm dbma dbmb dbmc
do
	srvctl stop database -d $i
	export ORACLE_SID=${i}1
		rman target sys/oracle<<EOF
		SHUTDOWN IMMEDIATE;
		STARTUP MOUNT;
		LIST RESTORE POINT ALL;
		FLASHBACK DATABASE TO RESTORE POINT 'BEFORE_TEST';
		ALTER DATABASE OPEN RESETLOGS;
		CROSSCHECK ARCHIVELOG ALL;
		DELETE NOPROMPT ARCHIVELOG ALL;
		CROSSCHECK ARCHIVELOG ALL;
		SHUTDOWN IMMEDIATE;
		exit	

EOF
srvctl start database -d $i
done