[sourcecode language=”bash”]
#!/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
[/sourcecode]