Refresh dev database from prod using RMAN

[purirb]

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.

[davey23uk]

use the restore command then

[julian]

use the restore command then

Or clone it with the duplicate command.

[pareshjavkar]

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.

[marist89]

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.