• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 815
  • Last Modified:

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
0
GurcanK
Asked:
GurcanK
  • 2
1 Solution
 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now