In host1, I have a database called orcl.
In host2, I have a same database name called orcl.
They have same exactly same datafile location.
I take the rman backup from host1.
Inorder to use duplicate database command, should I copy the backupset from host1 to host2?
In host2 I issued:
rman target sys/sy@orcl AUXILIARY /
DUPLICATE TARGET DATABASE TO orcl nofilenamecheck;
restoring datafile 00001 to /orcl/database/oracle/data/system01.ora
restoring datafile 00002 to /orcl/database/oracle/data/undotbs01.ora
restoring datafile 00003 to /orcl/database/oracle/data/sysaux01.ora
restoring datafile 00004 to /orcl/database/oracle/data/users01.ora
restoring datafile 00005 to /orcl/database/oracle/data/users02.ora
restoring datafile 00006 to /orcl/database/oracle/data/users03.ora
restoring datafile 00007 to /orcl/database/oracle/data/users04.ora
restoring datafile 00008 to /orcl/database/oracle/data/users05.ora
restoring datafile 00009 to /orcl/database/oracle/data/statspacktbs_01.dbf
restoring datafile 00010 to /orcl/database/oracle/data/users06.ora
restoring datafile 00011 to /orcl/database/oracle/data/user07.ora
channel ORA_AUX_DISK_1: reading from backup piece /db/tmp/rman/oracle_13_1
ORA-19870: error reading backup piece /db/tmp/rman/oracle_13_1
ORA-19505: failed to identify file "/db/tmp/rman/oracle_13_1"
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 12/11/2009 21:56:55
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 11 found to restore
RMAN-06023: no backup or copy of datafile 10 found to restore
RMAN-06023: no backup or copy of datafile 9 found to restore
RMAN-06023: no backup or copy of datafile 8 found to restore
RMAN-06023: no backup or copy of datafile 7 found to restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore