Forum Discussion

technimdaxviii's avatar
technimdaxviii
Level 5
8 years ago

Restore RMAN Backup from Tape to Disk

Hi All, We are currently working to document refreshing a test environment using RMAN backup from tape. Unfortunately, we're having difficulty restoring the backup from tape to disk. Is there any do...
  • Genericus's avatar
    Genericus
    8 years ago

    We do this all the time for DR testing - restore Oracle database from tape to alternate host.

    #1 - have DBA set up the database area. Path is not really relevant, since RMAN controls where everything goes.

    #2 - run RMAN restore script from destination using SOURCE client and policy name variables.

    Watch for typos in script, 90% of what I find is misspelled client name, or policy

    If using physical tape, you may need to extend the media timeout, tape contention can be a factor, I have had to run restore through multiple times, and RMAN will detect what is missing and just restore that on the second pass.

     

     

Michael_G_Ander's avatar
Michael_G_Ander
Level 6
8 years ago

Yes, restore is described in the Oracle Admin Guide and there are multiple tech notes about specific cases like alternate client restore.

  • Marianne's avatar
    Marianne
    Level 6
    8 years ago

    The assumption is that you will restore to an Alternate Client and not the same machine where it was backed up from?

    Work with your Oracle DBA as restore steps will be slightly different where Rman Catalog is used and where backup was done with 'nocatalog' option. 
    The Oracle dba needs to ensure that all requirements are met from Oracle point of view before rman restore is attempted. 

    If you type the following in Google search bar:
    NetBackup Oracle alternate client restore
    you will find a couple of TNs and forum posts.

    If you tell us which NBU version, we can provide URL to the NBU for Oracle manual for your version (or look for NBU Documentation links in 'Handy NBU Links' in my signature).

    • technimdaxviii's avatar
      technimdaxviii
      Level 5
      8 years ago

      Hi Mam Marianne,

      Yes, its correct. Just lil clarification, the plan is to restore the tape backup to the server/disk. FTP to the test server and do the restore and recover the database. Test server has no NBU client installed.

      NBU version: 7.6.0.2 

      NBU master is running in Solaris machine, same with media and client servers.

      Thank  you...

      • Marianne's avatar
        Marianne
        Level 6
        8 years ago

        It is not a NetBackup function to restore to alternate disk path.
        There is no way to restore Oracle at file-level to a different path.

        Backup is done of a database using rman.

        Restore can therefore only be done back into Oracle using rman.

        The Oracle DBA will need to find out if it is possible to restore to another database/instance name (clone?) on the same Oracle server without overwriting the production database.

  • technimdaxviii's avatar
    technimdaxviii
    Level 5
    8 years ago

    Hi Sir Michael,

    Thank you for the response. What changed you mean for question #1?

    Yes, we're also checking manual and some VOX posts/issue. Usually its for alternate client restore. Where alternate client should have the same file structure from the source. But on this scenario, there is a difference in path directory..

    Example:

    For Prod: /u01/oradata/PROD

    For Dev: /u01/oradata/DEV

    Regards,

    Jr

    • Michal_Mikulik1's avatar
      Michal_Mikulik1
      Moderator
      8 years ago

      Hello,

       

      as mentioned above, work with your Oracle DBA. Alternate Oracle DB restore is a relatively complex and multistep process.

      You also did not mention what is the problem, but I guess it will be likely Oracle configuration problem rather than NBU issue.

      Michal

      • technimdaxviii's avatar
        technimdaxviii
        Level 5
        8 years ago

        Hi Michal,

        This not a totally a problem, I'm just seeking a pieces of advice if it possible to extract a backup from tape. Seems the only way is using rman itself.

        Thank you..