RE: RMAN Testing Suggestions

not sure i understand exactly what you mean.  

we run our RMAN backup script. delete a datafile(s) and restore/recover

From: Alex [mailto:stant_98_at_yahoo.com]
Sent: Monday, November 22, 2004 11:14 AM To: Stephens, Chris; DWILLIAMS_at_LIFETOUCH.COM; ORACLE-L Subject: RE: RMAN Testing Suggestions

When you say lost datafile and other files, do you mean completely lost or did you have backup copies?

"Stephens, Chris" <ChrisStephens_at_pqa.com> wrote:

        We always tested:         

	Lost datafile
	Lost system datafile
	Lost control file
	Lost all control files
	Lost pfile,spfile
	


	=20

	
	-----Original Message-----
	From: oracle-l-bounce_at_freelists.org
	[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of DENNIS
WILLIAMS
	Sent: Monday, November 22, 2004 10:23 AM
	To: ORACLE-L
	Subject: RMAN Testing Suggestions
	
	List - Recently in response to an RMAN question, several listers
	mentioned how critical it is to perform a test recovery after
	configuring RMAN. I agree whole-heartedly. I was wondering if
some
	people could share some details of what tests seem appropriate.
A simple
	test I can think of is to backup the database, then shut it
down, rename
	the system datafile, then attempt to bring the database back up,
then
	recover the datafile using an RMAN command and open the
database. Is
	this test sufficient? On one hand I want to ensure RMAN is
correctly
	configured for backup and recovery, but on the other hand these
tests
	are best performed on a new database before handing it over to
the
	users. And the users are usually clamoring to use the database,
so I
	don't want to conduct extensive tests that are just testing RMAN
itself.
	Any thoughts?


	=20

	
	Dennis Williams
	
	DBA
	
	Lifetouch, Inc.
	
	
	
	--
	http://www.freelists.org/webpage/oracle-l
	--
	http://www.freelists.org/webpage/oracle-l
	

________________________________

Do you Yahoo!?
The all-new My Yahoo! <http://my.yahoo.com> - Get yours free!

--
http://www.freelists.org/webpage/oracle-l