RE: Methods for testing RMAN backups?

  • From: "Smith, Ron L." <rlsmith@xxxxxxx>
  • To: <rgramolini@xxxxxxxxxxxxxxx>, <premjhere@xxxxxxxxx>
  • Date: Tue, 25 Oct 2005 13:24:05 -0500

Just a note about a recent experience.  I had tested RMAN recovery using
an RMAN production backup that I FTP'ed from our production server to a
test server.  Everything went great.  Did it several times with no

Then I had the Unix admins restore a production backup from Netbackup to
the same test server.  This time the recovery failed because it did not
copy the control file as it should have.  I tried it several times with
the same result.  I haven't had time to try a backup from another day,
but it does have me concerned.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ruth Gramolini
Sent: Tuesday, October 25, 2005 11:59 AM
To: premjhere@xxxxxxxxx
Cc: oracle-l
Subject: RE: Methods for testing RMAN backups?

I do this on all of my backups, production and other.  It doesn't hurt
anything.  But you should also try to do a real restore and recovery
from  a dropped table for example to make sure you know how to do this.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Prem
Sent: Tuesday, October 25, 2005 10:21 AM
To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Methods for testing RMAN backups?

Hi Tom,

RMAN>restore database validate;

Hope you do this on your production systems.
Just wanted to confirm that it doesn't mess up anything :)
I have long wanted to do this, but don't know whether there
is any other issue doing this ?

I am on / Solaris 8.

What's the version you do it on ? Have you tried it on 8i systems ?

Thanks in advance.

Prem Khanna J

From: oracle-l-bounce@xxxxxxxxxxxxx


A good first test is to validate your backup.  Simply allocate a channel
and issue a "restore database validate;".  This does everything that a
restore would do except it does not touch the database.  Validate both
your database and archivelog backups.  This will prove that you can get
the backups off of tape or from disk, depending on the type of backup
you are doing.  I run a validate backup every week for all of our

After this, I would insist on performing a complete restore just so that
you know it can be done.

Good Luck!



Important Notice!!
If you are not the intended recipient of this e-mail message, any use, 
distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received this 
message by mistake, then delete the e-mail message.
Thank you.

Other related posts: