Flashback Database after testing



#!/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

Leave a Reply

Discover more from OraMatt: YABAOracle

Subscribe now to keep reading and get access to the full archive.

Continue reading