Overwrite existing DB with backup of another DB using RMAN
731311Aug 20 2010 — edited Aug 22 2010Using RMAN, I would like to overwrite one of our development databases with a copy of the production database. They are on different windows servers. Oracle_Home is different, the directory structure is different and the database names are different. There are multiple databases on the development server - I can only write over one of them - the others should remain the unaffected. I have never duplicated or restored a database from one server to another before and I have read many conflicting things about how to do it. Some of the steps I've seen involve shutting down the source (production) database and that is not an option. Is there a simple, non-invasive way to overwrite our dev database using RMAN?
Thanks!