FAQ
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
problems.

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.

Ron

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
On Behalf Of Ruth Gramolini
Sent: Tuesday, October 25, 2005 11:59 AM
To: premjhere_at_gmail.com
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.

HTH,

Ruth

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
On Behalf Of Prem
Sent: Tuesday, October 25, 2005 10:21 AM
To: Thomas.Mercadante_at_labor.state.ny.us; oracle-l_at_freelists.org
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 9.2.0.6 / Solaris 8.

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

Thanks in advance.

Regards,
Prem Khanna J

From: oracle-l-bounce_at_freelists.org

On

Vanessa,

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
databases.

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

Good Luck!

Tom

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

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

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.
--
http://www.freelists.org/webpage/oracle-l

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 13 of 16 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 13, '05 at 7:52a
activeOct 25, '05 at 2:36p
posts16
users10
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase