Refresh dev database from prod using RMAN

I have hotbackups, archivelog backup and controlfile back up from prod using RMAN. On another box I already have a dev instance running of this database. How can I refresh dev database using backup files provided. I do not want to use duplicate command. Please help.

use the restore command then

Quote:

---

Originally Posted by davey23uk

use the restore command then

---

Or clone it with the duplicate command.

run {
startup mount pfile=\INIT.ORA;

allocate channel ch1 type disk;

restore database;
recover database;

release channel ch1;
}

I am assuming you have same partitioning for PROD and DEV databases.

Quote:

---

Originally Posted by purirb

On another box I already have a dev instance running of this database.

---

You don't want a new instance, you just want to restore your existing db and start a new instance of it.