Restoring ORACLE RMAN backup in QA environment

Last post 09-23-2020, 12:09 PM by efg. 1 replies.
Sort Posts: Previous Next
  • Restoring ORACLE RMAN backup in QA environment
    Posted: 09-23-2020, 4:21 AM

    There is a requirement from the customer to restore Production's one-month old data to UAT environment. There is no network connectivity between Commvault and UAT server. Is there any way to restore Oracle RMAN data in UAT? I told them to arrange another server in Production environment with same OS, Oracle Database and Commvault Oracle RMAN iData agent installed to do the restoration as there is no connectivity between prod and UAT environment.  


    Guys is there any other method like restore Oracle RMAN data in any server as a dump and copy it in UAT environment.


    Your valuable comment will be highly appreciated

  • Re: Restoring ORACLE RMAN backup in QA environment
    Posted: 09-23-2020, 12:09 PM
    • efg is not online. Last active: 10-22-2020, 6:26 PM efg
    • Top 10 Contributor
    • Joined on 02-02-2010
    • CommVault Tinton Falls NJ
    • Master
    • Points 1,751

    Hi Amit,

    From what I can see it looks like there may be 2 possible procedures that you can use to accomplish this task.  The first is to use the "Application Free" restore that is available for the Oracle agent.   Here is a link to the procedure in the docs:

    Basically you restore the backup to disk (as backup files) that can then be transferred to the UAT server.  Once there you would need to install the CV agent using "uncoupled" install as the SBT APIs are required for RMAN. (Oracle requirement)  Once the agent is installed you can run RMAN from command line (linking in the CV SBT API) and restore the DB from the backup files transferred over from the restore.

    Another option would be to create a "Logical Dump" subclient which creates a backup using Oracle data pump/exports.  This backup can then also be restored to disk and copied over to the UAT server whereby it can then be imported to an instance using the appropriate Oracle utilities.  Here are links to our documentation for logical dump subclient and restore from logical dump subclient:

    Setting up a subclient:

    Restoring from logical dump subclient:

    Of course you would need to get the restored dump files transfered over to the UAT server for the import operation.


    Let us know if this helps

    Ernst F. Graeler
    Senior Engineer III
The content of the forums, threads and posts reflects the thoughts and opinions of each author, and does not represent the thoughts, opinions, plans or strategies of Commvault Systems, Inc. ("Commvault") and Commvault undertakes no obligation to update, correct or modify any statements made in this forum. Any and all third party links, statements, comments, or feedback posted to, or otherwise provided by this forum, thread or post are not affiliated with, nor endorsed by, Commvault.
Commvault, Commvault and logo, the “CV” logo, Commvault Systems, Solving Forward, SIM, Singular Information Management, Simpana, Commvault Galaxy, Unified Data Management, QiNetix, Quick Recovery, QR, CommNet, GridStor, Vault Tracker, InnerVault, QuickSnap, QSnap, Recovery Director, CommServe, CommCell, SnapProtect, ROMS, and CommValue, are trademarks or registered trademarks of Commvault Systems, Inc. All other third party brands, products, service names, trademarks, or registered service marks are the property of and used to identify the products or services of their respective owners. All specifications are subject to change without notice.
Copyright © 2020 Commvault | All Rights Reserved. | Legal | Privacy Policy