| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN Testing Suggestions
After every RMAN backup has completed we have a script that recovers a =
controlfile to /tmp.
That seems to provide a good degree of certainty that the files have = been written to tape in the first place.
John
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Stephens, Chris
Sent: Monday, November 22, 2004 5:30 PM
To: Alex; ORACLE-L
Subject: RE: RMAN Testing Suggestions
i have a script (basically taken from 'mastering pl/sql') that runs
against the rman views in each database via database links from out
'management database' to verify the backups completed sucessfully.
=20
...i do periodically validate them though. probably a couple times a
month.
From: Alex [mailto:stant_98_at_yahoo.com]=20 Sent: Monday, November 22, 2004 11:23 AM To: Stephens, Chris; DWILLIAMS_at_LIFETOUCH.COM; ORACLE-L Subject: RE: RMAN Testing Suggestions
got it. you physically deleted the files from the OS and restored them. do you validate you backups periodically?
"Stephens, Chris" <ChrisStephens_at_pqa.com> wrote:=20
not sure i understand exactly what you mean.restore/recover
=20
we run our RMAN backup script. delete a datafile(s) and
From: Alex [mailto:stant_98_at_yahoo.com]=20 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:
=09
Lost datafile Lost system datafile Lost control file Lost all control files Lost pfile,spfile
=09
=3D20
=09
-----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
=09
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? =3D20
=09
Dennis Williams
=09
DBA
=09
Lifetouch, Inc.
=09
=09
=09
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l
=09
=09
Do you Yahoo!? The all-new My Yahoo! <http://my.yahoo.com/> - Get yours free!=20 ________________________________
Do you Yahoo!?
Meet the all-new My Yahoo! <http://my.yahoo.com> - Try it today!=20
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 23 2004 - 12:31:42 CST
 |
 |