RE: RMAN Testing Suggestions
- From: Alex <stant_98@xxxxxxxxx>
- To: "Stephens, Chris" <ChrisStephens@xxxxxxx>, DWILLIAMS@xxxxxxxxxxxxx, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 22 Nov 2004 08:23:11 -0800 (PST)
got it. you physically deleted the files from the OS and restored them. do you
validate you backups periodically?
"Stephens, Chris" <ChrisStephens@xxxxxxx> wrote: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@xxxxxxxxx]
Sent: Monday, November 22, 2004 11:14 AM
To: Stephens, Chris; DWILLIAMS@xxxxxxxxxxxxx; 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@xxxxxxx> 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Do you Yahoo!?
The all-new My Yahoo! ? Get yours free!
---------------------------------
Do you Yahoo!?
Meet the all-new My Yahoo! ? Try it today!
--
//www.freelists.org/webpage/oracle-l
Other related posts:
