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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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@xxxxxxxxx]=20
Sent: Monday, November 22, 2004 11:23 AM
To: Stephens, Chris; DWILLIAMS@xxxxxxxxxxxxx; 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@xxxxxxx> wrote:=20

        not sure i understand exactly what you mean.
        =20
        we run our RMAN backup script.  delete a datafile(s) and
restore/recover

________________________________

        From: Alex [mailto:stant_98@xxxxxxxxx]=20
        Sent: Monday, November 22, 2004 11:14 AM
        To: Stephens, Chris; DWILLIAMS@xxxxxxxxxxxxx; ORACLE-L
        Subject: RE: RMAN Testing Suggestions
=09
=09
        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:
        =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@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
        =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-l

Other related posts: