How to verify RMAN backup files?

Posted on 2014-07-17
Last Modified: 2014-07-17
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.

Question by:GurcanK
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    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:

    That link also references a 'trial recovery'.

    Author Comment

    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?
    LVL 76

    Accepted Solution

    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

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now