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.

It is possible to restore as a new database.

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

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.