Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Want to "Refresh" a test database with a production database with RMAN

921861Mar 5 2012 — edited Mar 6 2012

Hello RMAN Gurus! I have a request to refresh a test database with our current production database. Until recently, I was able to do this with Data Pump Export/Import nicely. Unfortunately, the Production database is growing and I am unable to complete this process in a 12 hour window.

The Prod and Test databases live on different hosts and have different SIDs. The Test database is a permanent database for testing. I have begun researching database cloning with RMAN and the documentation answers many of my questions except for one. Can the RMAN duplicate command work with an existing database? All the examples I have seen have a step where auxiliary instance needs to be created. What if it does but it also has a full blown set of database files associated with it?

Thanks in advance for your assistance!
Shawn

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 3 2012

Added on Mar 5 2012

#performance-availability, #recovery-manager-rman

9 comments

11,985 views