DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Backup PROD and Restore to TEST using RMAN

  1. #1
    Join Date
    Jun 2021
    Posts
    1

    Backup PROD and Restore to TEST using RMAN

    Hello Everybody,

    My company has a Production database and a Test database, so we can try everything before applying it to production, but our data in the test database is limited, so we wanted to grab all the data from Production and pass it to Test using RMAN. I've seen how to do a database backup in RMAN, but I wasn't able to find anything about using the backup to restore a different database.

    Is it possible to use RMAN backup for that? If so, can you give me some pointers/documentation?

    Thank you.

  2. #2
    Join Date
    Dec 2002
    Posts
    74
    It is possible to restore as a new database.

    https://asktom.oracle.com/pls/apex/a...a-new-database

  3. #3
    Join Date
    Sep 2021
    Posts
    1
    This is a late response to your question, but if you are using multi-tenant database you might look into the pluggable database clone feature. I find the clone option is far more elegant and efficient than using RMAN to refresh/copy data.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width