RMAN> backup database; Starting backup at 11-MAR-08 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00001 name=D:\ORACLE\ORADATA\PREETHI\SYSTEM01.DBF input datafile fno=00002 name=D:\ORACLE\ORADATA\PREETHI\UNDOTBS01.DBF input datafile fno=00014 name=D:\ORACLE\ORADATA\PREETHI\RMAN.DBF input datafile fno=00005 name=D:\ORACLE\ORADATA\PREETHI\EXAMPLE01.DBF input datafile fno=00012 name=D:\ORACLE\ORADATA\PREETHI\STATS.DBF input datafile fno=00009 name=D:\ORACLE\ORADATA\PREETHI\USERS01.DBF input datafile fno=00010 name=D:\ORACLE\ORADATA\PREETHI\XDB01.DBF input datafile fno=00006 name=D:\ORACLE\ORADATA\PREETHI\INDX01.DBF input datafile fno=00003 name=D:\ORACLE\ORADATA\PREETHI\CWMLITE01.DBF input datafile fno=00004 name=D:\ORACLE\ORADATA\PREETHI\DRSYS01.DBF input datafile fno=00007 name=D:\ORACLE\ORADATA\PREETHI\ODM01.DBF input datafile fno=00008 name=D:\ORACLE\ORADATA\PREETHI\TOOLS01.DBF input datafile fno=00011 name=D:\ORACLE\ORADATA\PREETHI\USERDATA.DBF channel ORA_DISK_1: starting piece 1 at 11-MAR-08 channel ORA_DISK_1: finished piece 1 at 11-MAR-08 piece handle=D:\ORACLE\ORA92\DATABASE\0JJB1IG4_1_1 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:17 Finished backup at 11-MAR-08 Starting Control File and SPFILE Autobackup at 11-MAR-08 piece handle=D:\RMAN\ORA_C-1003563599-20080311-03 comment=NONE Finished Control File and SPFILE Autobackup at 11-MAR-08 RMAN> duplicate target database to 'rmanclone'; Starting Duplicate Db at 11-MAR-08 using channel ORA_AUX_DISK_1 datafile 10 not processed because file is offline printing stored script: Memory Script { set until scn 5404956; set newname for datafile 1 to ";\SYSTEM01.DBF"; set newname for datafile 2 to ";\UNDOTBS01.DBF"; set newname for datafile 3 to ";\CWMLITE01.DBF"; set newname for datafile 4 to ";\DRSYS01.DBF"; set newname for datafile 5 to ";\EXAMPLE01.DBF"; set newname for datafile 6 to ";\INDX01.DBF"; set newname for datafile 7 to ";\ODM01.DBF"; set newname for datafile 8 to ";\TOOLS01.DBF"; set newname for datafile 9 to ";\USERS01.DBF"; set newname for datafile 11 to ";\USERDATA.DBF"; set newname for datafile 12 to ";\STATS.DBF"; set newname for datafile 14 to ";\RMAN.DBF"; restore check readonly clone database skip tablespace XDB ; } executing script: Memory Script executing command: SET until clause executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting restore at 11-MAR-08 using channel ORA_AUX_DISK_1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 03/11/2008 23:14:11 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 14 found to restore RMAN-06023: no backup or copy of datafile 12 found to restore RMAN-06023: no backup or copy of datafile 11 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