How to verify RMAN backup files?

Dear Experts,

One of our Oracle servers has crashed. The server was Windows 2008 R2 std edition with Oracle 11gR2. We installed Windows 2008R2 and Oracle 11gR2 on another server with the same instance name; however Oracle Home is not in the same drive  compared to previous one and there is no tablespace other than System yet.

I have RMAN backup files in an external disk. However, I'm suspicious of RMAN backup files' consistency, whether they are restorable or not. How can I check the consistency of these files? Please note that the original server has been lost. I want to introduce these files to new Oracle Server's RMAN and verify whether they are OK.

BR
GurcanKAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
I don't know how to verify a backup file is 'valid' or not just by looking at the file itself.

If the database is mounted there is a RESTORE VALIDATE:
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmvalid.htm#i1031282

That link also references a 'trial recovery'.
0
GurcanKAuthor Commented:
New installation does not know about the RMAN backup files and their place. How can I introduce it to RMAN before running RESTORE DATABASE VALIDATE?
0
slightwv (䄆 Netminder) Commented:
I'm far from an RMAN expert.  A lot of what I know comes from the online docs and limited disaster recovery testing.

I'm not sure how to tell an RMAN backup to apply itself to an existing new database.

I believe you will need to follow the steps of restoring to a new host.

Restoring a Database on a New Host
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmadvre.htm#i1007814

There are a lot of papers/blogs out there that 'claim' to have the steps but I cannot recommend any one over the other.

If you are unfamiliar with disaster recovery using RMAN and this is a production system, I would suggest you open a priority 1 SR (down production system) with Oracle Support.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.