RMAN> run 2> { 3> SET NEWNAME FOR DATAFILE 1 TO 'C:\ORACLE\ORADATA\ORCLDUP\SYSTEM01.DBF'; 4> SET NEWNAME FOR DATAFILE 2 TO 'C:\ORACLE\ORADATA\ORCLDUP\SYSAUX01.DBF'; 5> SET NEWNAME FOR DATAFILE 3 TO 'C:\ORACLE\ORADATA\ORCLDUP\UNDOTBS01.DBF'; 6> SET NEWNAME FOR DATAFILE 4 TO 'C:\ORACLE\ORADATA\ORCLDUP\USERS01.DBF'; 7> SET NEWNAME FOR DATAFILE 5 TO 'C:\ORACLE\ORADATA\ORCLDUP\EXAMPLE01.DBF'; 8> SET NEWNAME FOR TEMPFILE 1 TO 'C:\ORACLE\ORADATA\ORCLDUP\TEMP01.DBF'; 9> duplicate target database to orcldup from active database; 10> } 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 Duplicate Db at 13-DEC-08 using channel ORA_AUX_DISK_1 contents of Memory Script: { set newname for datafile 1 to "C:\ORACLE\ORADATA\ORCLDUP\SYSTEM01.DBF"; set newname for datafile 2 to "C:\ORACLE\ORADATA\ORCLDUP\SYSAUX01.DBF"; set newname for datafile 3 to "C:\ORACLE\ORADATA\ORCLDUP\UNDOTBS01.DBF"; set newname for datafile 4 to "C:\ORACLE\ORADATA\ORCLDUP\USERS01.DBF"; set newname for datafile 5 to "C:\ORACLE\ORADATA\ORCLDUP\EXAMPLE01.DBF"; backup as copy reuse datafile 1 auxiliary format "C:\ORACLE\ORADATA\ORCLDUP\SYSTEM01.DBF" datafile 2 auxiliary format "C:\ORACLE\ORADATA\ORCLDUP\SYSAUX01.DBF" datafile 3 auxiliary format "C:\ORACLE\ORADATA\ORCLDUP\UNDOTBS01.DBF" datafile 4 auxiliary format "C:\ORACLE\ORADATA\ORCLDUP\USERS01.DBF" datafile 5 auxiliary format "C:\ORACLE\ORADATA\ORCLDUP\EXAMPLE01.DBF" ; sql 'alter system archive log current'; } executing Memory Script executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting backup at 13-DEC-08 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=121 device type=DISK channel ORA_DISK_1: starting datafile copy input datafile file number=00001 name=C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF output file name=C:\ORACLE\ORADATA\ORCLDUP\SYSTEM01.DBF tag=TAG20081213T193406 R ECID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45 channel ORA_DISK_1: starting datafile copy input datafile file number=00002 name=C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF output file name=C:\ORACLE\ORADATA\ORCLDUP\SYSAUX01.DBF tag=TAG20081213T193406 R ECID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:35 channel ORA_DISK_1: starting datafile copy input datafile file number=00005 name=C:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF output file name=C:\ORACLE\ORADATA\ORCLDUP\EXAMPLE01.DBF tag=TAG20081213T193406 RECID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting datafile copy input datafile file number=00003 name=C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF output file name=C:\ORACLE\ORADATA\ORCLDUP\UNDOTBS01.DBF tag=TAG20081213T193406 RECID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting datafile copy input datafile file number=00004 name=C:\ORACLE\ORADATA\ORCL\USERS01.DBF output file name=C:\ORACLE\ORADATA\ORCLDUP\USERS01.DBF tag=TAG20081213T193406 RE CID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 13-DEC-08 sql statement: alter system archive log current sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCLDUP" RESETLOGS ARCHIVE LOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 SIZE 50 M , GROUP 2 SIZE 50 M , GROUP 3 SIZE 50 M DATAFILE 'C:\ORACLE\ORADATA\ORCLDUP\SYSTEM01.DBF' CHARACTER SET WE8MSWIN1252 contents of Memory Script: { backup as copy reuse archivelog like "C:\ORACLE\PRODUCT\11.1.0\DB_1\RDBMS\ARC00008_0673378113.001 " auxiliary format "C:\ORACLE\FLASH_RECOVERY_AREA\ORCLDUP\ARCHIVELOG\2008_12_13\O1_MF_1_8_%U_.ARC" archivelog like "C:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_12_13\O1_MF_1_8_4N7JBC2H_.A RC" auxiliary format "C:\ORACLE\FLASH_RECOVERY_AREA\ORCLDUP\ARCHIVELOG\2008_12_13\O1_MF_1_8_%U_.ARC" ; catalog clone recovery area; switch clone datafile all; } executing Memory Script Starting backup at 13-DEC-08 using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log copy input archived log thread=1 sequence=8 RECID=11 STAMP=673385764 output file name=C:\ORACLE\FLASH_RECOVERY_AREA\ORCLDUP\ARCHIVELOG\2008_12_13\O1_ MF_1_8_ARCH_D-ORCL_ID-1201158845_S-8_T-1_A-673378113_06K26397_.ARC RECID=0 STAMP =0 channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting archived log copy input archived log thread=1 sequence=8 RECID=12 STAMP=673385764 output file name=C:\ORACLE\FLASH_RECOVERY_AREA\ORCLDUP\ARCHIVELOG\2008_12_13\O1_ MF_1_8_ARCH_D-ORCL_ID-1201158845_S-8_T-1_A-673378113_07K2639B_.ARC RECID=0 STAMP =0 channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01 Finished backup at 13-DEC-08 searching for all files in the recovery area List of Files Unknown to the Database ===================================== File Name: C:\ORACLE\FLASH_RECOVERY_AREA\ORCLDUP\ARCHIVELOG\2008_12_13\O1_MF_1_8 _ARCH_D-ORCL_ID-1201158845_S-8_T-1_A-673378113_06K26397_.ARC File Name: C:\ORACLE\FLASH_RECOVERY_AREA\ORCLDUP\ARCHIVELOG\2008_12_13\O1_MF_1_8 _ARCH_D-ORCL_ID-1201158845_S-8_T-1_A-673378113_07K2639B_.ARC cataloging files... cataloging done List of Cataloged Files ======================= File Name: C:\ORACLE\FLASH_RECOVERY_AREA\ORCLDUP\ARCHIVELOG\2008_12_13\O1_MF_1_8 _ARCH_D-ORCL_ID-1201158845_S-8_T-1_A-673378113_06K26397_.ARC File Name: C:\ORACLE\FLASH_RECOVERY_AREA\ORCLDUP\ARCHIVELOG\2008_12_13\O1_MF_1_8 _ARCH_D-ORCL_ID-1201158845_S-8_T-1_A-673378113_07K2639B_.ARC datafile 2 switched to datafile copy input datafile copy RECID=1 STAMP=673385777 file name=C:\ORACLE\ORADATA\ORCLDUP\ SYSAUX01.DBF datafile 3 switched to datafile copy input datafile copy RECID=2 STAMP=673385777 file name=C:\ORACLE\ORADATA\ORCLDUP\ UNDOTBS01.DBF datafile 4 switched to datafile copy input datafile copy RECID=3 STAMP=673385777 file name=C:\ORACLE\ORADATA\ORCLDUP\ USERS01.DBF datafile 5 switched to datafile copy input datafile copy RECID=4 STAMP=673385777 file name=C:\ORACLE\ORADATA\ORCLDUP\ EXAMPLE01.DBF contents of Memory Script: { set until scn 954837; recover clone database delete archivelog ; } executing Memory Script executing command: SET until clause Starting recover at 13-DEC-08 using channel ORA_AUX_DISK_1 starting media recovery archived log for thread 1 with sequence 8 is already on disk as file C:\ORACLE\F LASH_RECOVERY_AREA\ORCLDUP\ARCHIVELOG\2008_12_13\O1_MF_1_8_ARCH_D-ORCL_ID-120115 8845_S-8_T-1_A-673378113_06K26397_.ARC archived log file name=C:\ORACLE\FLASH_RECOVERY_AREA\ORCLDUP\ARCHIVELOG\2008_12_ 13\O1_MF_1_8_ARCH_D-ORCL_ID-1201158845_S-8_T-1_A-673378113_06K26397_.ARC thread= 1 sequence=8 media recovery complete, elapsed time: 00:00:02 Finished recover at 13-DEC-08 contents of Memory Script: { shutdown clone immediate; startup clone nomount ; } executing Memory Script database dismounted Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total System Global Area 535662592 bytes Fixed Size 1334380 bytes Variable Size 176161684 bytes Database Buffers 352321536 bytes Redo Buffers 5844992 bytes sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCLDUP" RESETLOGS ARCHIVE LOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 SIZE 50 M , GROUP 2 SIZE 50 M , GROUP 3 SIZE 50 M DATAFILE 'C:\ORACLE\ORADATA\ORCLDUP\SYSTEM01.DBF' CHARACTER SET WE8MSWIN1252 contents of Memory Script: { set newname for tempfile 1 to "C:\ORACLE\ORADATA\ORCLDUP\TEMP01.DBF"; switch clone tempfile all; catalog clone datafilecopy "C:\ORACLE\ORADATA\ORCLDUP\SYSAUX01.DBF"; catalog clone datafilecopy "C:\ORACLE\ORADATA\ORCLDUP\UNDOTBS01.DBF"; catalog clone datafilecopy "C:\ORACLE\ORADATA\ORCLDUP\USERS01.DBF"; catalog clone datafilecopy "C:\ORACLE\ORADATA\ORCLDUP\EXAMPLE01.DBF"; switch clone datafile all; } executing Memory Script executing command: SET NEWNAME renamed tempfile 1 to C:\ORACLE\ORADATA\ORCLDUP\TEMP01.DBF in control file cataloged datafile copy datafile copy file name=C:\ORACLE\ORADATA\ORCLDUP\SYSAUX01.DBF RECID=1 STAMP=673 385801 cataloged datafile copy datafile copy file name=C:\ORACLE\ORADATA\ORCLDUP\UNDOTBS01.DBF RECID=2 STAMP=67 3385801 cataloged datafile copy datafile copy file name=C:\ORACLE\ORADATA\ORCLDUP\USERS01.DBF RECID=3 STAMP=6733 85801 cataloged datafile copy datafile copy file name=C:\ORACLE\ORADATA\ORCLDUP\EXAMPLE01.DBF RECID=4 STAMP=67 3385801 datafile 2 switched to datafile copy input datafile copy RECID=1 STAMP=673385801 file name=C:\ORACLE\ORADATA\ORCLDUP\ SYSAUX01.DBF datafile 3 switched to datafile copy input datafile copy RECID=2 STAMP=673385801 file name=C:\ORACLE\ORADATA\ORCLDUP\ UNDOTBS01.DBF datafile 4 switched to datafile copy input datafile copy RECID=3 STAMP=673385801 file name=C:\ORACLE\ORADATA\ORCLDUP\ USERS01.DBF datafile 5 switched to datafile copy input datafile copy RECID=4 STAMP=673385801 file name=C:\ORACLE\ORADATA\ORCLDUP\ EXAMPLE01.DBF contents of Memory Script: { Alter clone database open resetlogs; } executing Memory Script database opened Finished Duplicate Db at 13-DEC-08 RMAN> ================================= RMAN> run 2> { 3> SET NEWNAME FOR DATAFILE 1 TO 'C:\ORACLE\ORADATA\ORCLTEST\SYSTEM01.DBF'; 4> SET NEWNAME FOR DATAFILE 2 TO 'C:\ORACLE\ORADATA\ORCLTEST\SYSAUX01.DBF'; 5> SET NEWNAME FOR DATAFILE 3 TO 'C:\ORACLE\ORADATA\ORCLTEST\UNDOTBS01.DBF'; 6> SET NEWNAME FOR DATAFILE 4 TO 'C:\ORACLE\ORADATA\ORCLTEST\USERS01.DBF'; 7> SET NEWNAME FOR DATAFILE 5 TO 'C:\ORACLE\ORADATA\ORCLTEST\EXAMPLE01.DBF'; 8> duplicate target database to orcltest from active database 9> DB_FILE_NAME_CONVERT ('C:\ORACLE\ORADATA\ORCL\','C:\ORACLE\ORADATA\ORCLTEST\'); 10> } executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting Duplicate Db at 13-DEC-08 using channel ORA_AUX_DISK_1 contents of Memory Script: { set newname for datafile 1 to "C:\ORACLE\ORADATA\ORCLTEST\SYSTEM01.DBF"; set newname for datafile 2 to "C:\ORACLE\ORADATA\ORCLTEST\SYSAUX01.DBF"; set newname for datafile 3 to "C:\ORACLE\ORADATA\ORCLTEST\UNDOTBS01.DBF"; set newname for datafile 4 to "C:\ORACLE\ORADATA\ORCLTEST\USERS01.DBF"; set newname for datafile 5 to "C:\ORACLE\ORADATA\ORCLTEST\EXAMPLE01.DBF"; backup as copy reuse datafile 1 auxiliary format "C:\ORACLE\ORADATA\ORCLTEST\SYSTEM01.DBF" datafile 2 auxiliary format "C:\ORACLE\ORADATA\ORCLTEST\SYSAUX01.DBF" datafile 3 auxiliary format "C:\ORACLE\ORADATA\ORCLTEST\UNDOTBS01.DBF" datafile 4 auxiliary format "C:\ORACLE\ORADATA\ORCLTEST\USERS01.DBF" datafile 5 auxiliary format "C:\ORACLE\ORADATA\ORCLTEST\EXAMPLE01.DBF" ; sql 'alter system archive log current'; } executing Memory Script executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME executing command: SET NEWNAME Starting backup at 13-DEC-08 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=118 device type=DISK channel ORA_DISK_1: starting datafile copy input datafile file number=00001 name=C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF output file name=C:\ORACLE\ORADATA\ORCLTEST\SYSTEM01.DBF tag=TAG20081213T204627 RECID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45 channel ORA_DISK_1: starting datafile copy input datafile file number=00002 name=C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF output file name=C:\ORACLE\ORADATA\ORCLTEST\SYSAUX01.DBF tag=TAG20081213T204627 RECID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:45 channel ORA_DISK_1: starting datafile copy input datafile file number=00005 name=C:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF output file name=C:\ORACLE\ORADATA\ORCLTEST\EXAMPLE01.DBF tag=TAG20081213T204627 RECID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:11 channel ORA_DISK_1: starting datafile copy input datafile file number=00003 name=C:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF output file name=C:\ORACLE\ORADATA\ORCLTEST\UNDOTBS01.DBF tag=TAG20081213T204627 RECID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07 channel ORA_DISK_1: starting datafile copy input datafile file number=00004 name=C:\ORACLE\ORADATA\ORCL\USERS01.DBF output file name=C:\ORACLE\ORADATA\ORCLTEST\USERS01.DBF tag=TAG20081213T204627 RECID=0 STAMP=0 channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01 Finished backup at 13-DEC-08 sql statement: alter system archive log current sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCLTEST" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 SIZE 50 M , GROUP 2 SIZE 50 M , GROUP 3 SIZE 50 M DATAFILE 'C:\ORACLE\ORADATA\ORCLTEST\SYSTEM01.DBF' CHARACTER SET WE8MSWIN1252 contents of Memory Script: { backup as copy reuse archivelog like "C:\ORACLE\PRODUCT\11.1.0\DB_1\RDBMS\ARC00009_0673378113.001" auxiliary format "C:\ORACLE\FLASH_RECOVERY_AREA\ORCLTEST\ARCHIVELOG\2008_12_13\O1_MF_1_9_%U_.ARC" archivelog like "C:\ORACLE\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2008_12_13\O1_MF_1_9_4N7NLCJS_.ARC" auxiliary format "C:\ORACLE\FLASH_RECOVERY_AREA\ORCLTEST\ARCHIVELOG\2008_12_13\O1_MF_1_9_%U_.ARC" ; catalog clone recovery area; switch clone datafile all; } executing Memory Script Starting backup at 13-DEC-08 using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log copy input archived log thread=1 sequence=9 RECID=13 STAMP=673390117 output file name=C:\ORACLE\FLASH_RECOVERY_AREA\ORCLTEST\ARCHIVELOG\2008_12_13\O1_MF_1_9_ARCH_D-ORCL_ID-1201158845_S-9_T-1_A-673378113_0DK267H7_.ARC RECID=0 STAMP=0 channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01 channel ORA_DISK_1: starting archived log copy input archived log thread=1 sequence=9 RECID=14 STAMP=673390117 output file name=C:\ORACLE\FLASH_RECOVERY_AREA\ORCLTEST\ARCHIVELOG\2008_12_13\O1_MF_1_9_ARCH_D-ORCL_ID-1201158845_S-9_T-1_A-673378113_0EK267HC_.ARC RECID=0 STAMP=0 channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01 Finished backup at 13-DEC-08 searching for all files in the recovery area List of Files Unknown to the Database ===================================== File Name: C:\ORACLE\FLASH_RECOVERY_AREA\ORCLTEST\ARCHIVELOG\2008_12_13\O1_MF_1_9_ARCH_D-ORCL_ID-1201158845_S-9_T-1_A-673378113_0DK267H7_.ARC File Name: C:\ORACLE\FLASH_RECOVERY_AREA\ORCLTEST\ARCHIVELOG\2008_12_13\O1_MF_1_9_ARCH_D-ORCL_ID-1201158845_S-9_T-1_A-673378113_0EK267HC_.ARC cataloging files... cataloging done List of Cataloged Files ======================= File Name: C:\ORACLE\FLASH_RECOVERY_AREA\ORCLTEST\ARCHIVELOG\2008_12_13\O1_MF_1_9_ARCH_D-ORCL_ID-1201158845_S-9_T-1_A-673378113_0DK267H7_.ARC File Name: C:\ORACLE\FLASH_RECOVERY_AREA\ORCLTEST\ARCHIVELOG\2008_12_13\O1_MF_1_9_ARCH_D-ORCL_ID-1201158845_S-9_T-1_A-673378113_0EK267HC_.ARC datafile 2 switched to datafile copy input datafile copy RECID=1 STAMP=673390129 file name=C:\ORACLE\ORADATA\ORCLTEST\SYSAUX01.DBF datafile 3 switched to datafile copy input datafile copy RECID=2 STAMP=673390130 file name=C:\ORACLE\ORADATA\ORCLTEST\UNDOTBS01.DBF datafile 4 switched to datafile copy input datafile copy RECID=3 STAMP=673390130 file name=C:\ORACLE\ORADATA\ORCLTEST\USERS01.DBF datafile 5 switched to datafile copy input datafile copy RECID=4 STAMP=673390130 file name=C:\ORACLE\ORADATA\ORCLTEST\EXAMPLE01.DBF contents of Memory Script: { set until scn 960646; recover clone database delete archivelog ; } executing Memory Script executing command: SET until clause Starting recover at 13-DEC-08 using channel ORA_AUX_DISK_1 starting media recovery archived log for thread 1 with sequence 9 is already on disk as file C:\ORACLE\FLASH_RECOVERY_AREA\ORCLTEST\ARCHIVELOG\2008_12_13\O1_MF_1_9_ARCH_D-ORCL_ID-1201158845_S-9_T-1_A-673378113_0EK267HC_.ARC archived log file name=C:\ORACLE\FLASH_RECOVERY_AREA\ORCLTEST\ARCHIVELOG\2008_12_13\O1_MF_1_9_ARCH_D-ORCL_ID-1201158845_S-9_T-1_A-673378113_0EK267HC_.ARC thread=1 sequence=9 media recovery complete, elapsed time: 00:00:03 Finished recover at 13-DEC-08 contents of Memory Script: { shutdown clone immediate; startup clone nomount ; } executing Memory Script database dismounted Oracle instance shut down connected to auxiliary database (not started) Oracle instance started Total System Global Area 535662592 bytes Fixed Size 1334380 bytes Variable Size 176161684 bytes Database Buffers 352321536 bytes Redo Buffers 5844992 bytes sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCLTEST" RESETLOGS ARCHIVELOG MAXLOGFILES 16 MAXLOGMEMBERS 3 MAXDATAFILES 100 MAXINSTANCES 8 MAXLOGHISTORY 292 LOGFILE GROUP 1 SIZE 50 M , GROUP 2 SIZE 50 M , GROUP 3 SIZE 50 M DATAFILE 'C:\ORACLE\ORADATA\ORCLTEST\SYSTEM01.DBF' CHARACTER SET WE8MSWIN1252 contents of Memory Script: { set newname for tempfile 1 to "C:\ORACLE\ORADATA\ORCLTEST\TEMP01.DBF"; switch clone tempfile all; catalog clone datafilecopy "C:\ORACLE\ORADATA\ORCLTEST\SYSAUX01.DBF"; catalog clone datafilecopy "C:\ORACLE\ORADATA\ORCLTEST\UNDOTBS01.DBF"; catalog clone datafilecopy "C:\ORACLE\ORADATA\ORCLTEST\USERS01.DBF"; catalog clone datafilecopy "C:\ORACLE\ORADATA\ORCLTEST\EXAMPLE01.DBF"; switch clone datafile all; } executing Memory Script executing command: SET NEWNAME renamed tempfile 1 to C:\ORACLE\ORADATA\ORCLTEST\TEMP01.DBF in control file cataloged datafile copy datafile copy file name=C:\ORACLE\ORADATA\ORCLTEST\SYSAUX01.DBF RECID=1 STAMP=673390154 cataloged datafile copy datafile copy file name=C:\ORACLE\ORADATA\ORCLTEST\UNDOTBS01.DBF RECID=2 STAMP=673390154 cataloged datafile copy datafile copy file name=C:\ORACLE\ORADATA\ORCLTEST\USERS01.DBF RECID=3 STAMP=673390154 cataloged datafile copy datafile copy file name=C:\ORACLE\ORADATA\ORCLTEST\EXAMPLE01.DBF RECID=4 STAMP=673390154 datafile 2 switched to datafile copy input datafile copy RECID=1 STAMP=673390154 file name=C:\ORACLE\ORADATA\ORCLTEST\SYSAUX01.DBF datafile 3 switched to datafile copy input datafile copy RECID=2 STAMP=673390154 file name=C:\ORACLE\ORADATA\ORCLTEST\UNDOTBS01.DBF datafile 4 switched to datafile copy input datafile copy RECID=3 STAMP=673390154 file name=C:\ORACLE\ORADATA\ORCLTEST\USERS01.DBF datafile 5 switched to datafile copy input datafile copy RECID=4 STAMP=673390154 file name=C:\ORACLE\ORADATA\ORCLTEST\EXAMPLE01.DBF contents of Memory Script: { Alter clone database open resetlogs; } executing Memory Script database opened Finished Duplicate Db at 13-DEC-08 RMAN>