Database Software

Hello -

I have live & dev databases (on different servers). Both have the same file structure, and environment variables, db name and dbid are all identical.


I am attempting to restore a live rman backup to the dev instance. (ie to replace the dev DB with a copy of live).

First, I backed up the live DB & control file, and FTP'd these to a directory on the dev server. I then ran the following steps in rman (on dev):


RMAN> connect target;
RMAN> shutdown immediate;


RMAN> startup nomount;
RMAN> restore controlfile from '/archive/livecopy/control_file_backup.bkp';


RMAN> alter database mount;
RMAN> catalog backuppiece '/archive/livecopy/full_hot_backup.bkp';


These all passed without error.

However, the database will not recover:

RMAN> recover database;

starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/01/2012 13:18:46
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until cancel using backup controlfile
ORA-00283: recovery session canceled due to errors
ORA-19909: datafile 1 belongs to an orphan incarnation
ORA-01110: data file 1: '/database/DWL/data01/system01.dbf'



Am I missing a step somewhere? The live backup is more recent than any activity on the dev instance, so am a little confused with the reference to the orphan incarnation (ORA-19909).

Any help would be greatfully appreciated.