C:\Documents and Settings\Administrator>rman target sys/dba@Demo1 auxiliary sys/
dba@BOX

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Oct 8 14:47:19 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

connected to target database: DEMO1 (DBID=3637186409)
connected to auxiliary database: BOX (not mounted)

RMAN>  DUPLICATE TARGET DATABASE TO BOX
2> pfile=c:\oradata\BOX\initbox.ora;

Starting Duplicate Db at 08-OCT-07
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=155 devtype=DISK

contents of Memory Script:
{
   set until scn  1936887;
   set newname for datafile  1 to
 "C:\ORADATA\BOX\DATAFILES\SYSTEM01.DBF";
   set newname for datafile  2 to
 "C:\ORADATA\BOX\DATAFILES\UNDOTBS01.DBF";
   set newname for datafile  3 to
 "C:\ORADATA\BOX\DATAFILES\SYSAUX01.DBF";
   set newname for datafile  4 to
 "C:\ORADATA\BOX\DATAFILES\USERS01.DBF";
   set newname for datafile  5 to
 "C:\ORADATA\BOX\DATAFILES\EXAMPLE01.DBF";
   restore
   check readonly
   clone database
   ;
}
executing 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

Starting restore at 08-OCT-07
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to C:\ORADATA\BOX\DATAFILES\SYSTEM01.DBF
restoring datafile 00002 to C:\ORADATA\BOX\DATAFILES\UNDOTBS01.DBF
restoring datafile 00003 to C:\ORADATA\BOX\DATAFILES\SYSAUX01.DBF
restoring datafile 00004 to C:\ORADATA\BOX\DATAFILES\USERS01.DBF
restoring datafile 00005 to C:\ORADATA\BOX\DATAFILES\EXAMPLE01.DBF
channel ORA_AUX_DISK_1: reading from backup piece C:\ORADATA\FLASH_RECOVERY_AREA
\DEMO1\BACKUPSET\2007_10_08\O1_MF_NNND0_BACKUP_FULL_DEMO1__1_3JL7OL1K_.BKP
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=C:\ORADATA\FLASH_RECOVERY_AREA\DEMO1\BACKUPSET\2007_10_08\O1_MF_NNN
D0_BACKUP_FULL_DEMO1__1_3JL7OL1K_.BKP tag=BACKUP_FULL_DEMO1__100807020001
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:35
Finished restore at 08-OCT-07
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "BOX" RESETLOGS ARCHIVELOG

  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP  1 ( 'C:\ORADATA\BOX\ONLINELOGS\REDO01.LOG' ) SIZE 50 M  REUSE,
  GROUP  2 ( 'C:\ORADATA\BOX\ONLINELOGS\REDO02.LOG' ) SIZE 50 M  REUSE,
  GROUP  3 ( 'C:\ORADATA\BOX\ONLINELOGS\REDO03.LOG' ) SIZE 50 M  REUSE
 DATAFILE
  'C:\ORADATA\BOX\DATAFILES\SYSTEM01.DBF'
 CHARACTER SET WE8MSWIN1252


contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script

released channel: ORA_AUX_DISK_1
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=635438956 filename=C:\ORADATA\BOX\DATAFILES\UN
DOTBS01.DBF
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=635438956 filename=C:\ORADATA\BOX\DATAFILES\SY
SAUX01.DBF
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=635438956 filename=C:\ORADATA\BOX\DATAFILES\US
ERS01.DBF
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=635438956 filename=C:\ORADATA\BOX\DATAFILES\EX
AMPLE01.DBF

contents of Memory Script:
{
   set until scn  1936887;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 08-OCT-07
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=155 devtype=DISK
channel ORA_AUX_DISK_1: starting incremental datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: C:\ORADATA\BOX\DATAFILES\SYSTEM01.DBF

destination for restore of datafile 00002: C:\ORADATA\BOX\DATAFILES\UNDOTBS01.DB
F
destination for restore of datafile 00003: C:\ORADATA\BOX\DATAFILES\SYSAUX01.DBF

destination for restore of datafile 00004: C:\ORADATA\BOX\DATAFILES\USERS01.DBF
destination for restore of datafile 00005: C:\ORADATA\BOX\DATAFILES\EXAMPLE01.DB
F
channel ORA_AUX_DISK_1: reading from backup piece C:\ORADATA\FLASH_RECOVERY_AREA
\DEMO1\BACKUPSET\2007_10_08\O1_MF_NNND1_BACKUP_INCR_DEMO1__1_3JMKWCQ2_.BKP
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=C:\ORADATA\FLASH_RECOVERY_AREA\DEMO1\BACKUPSET\2007_10_08\O1_MF_NNN
D1_BACKUP_INCR_DEMO1__1_3JMKWCQ2_.BKP tag=BACKUP_INCR_DEMO1__100807020026
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07

starting media recovery

archive log thread 1 sequence 40 is already on disk as file C:\ORADATA\DEMO1\ARC
HIVE\DEMO1_00040_0634403463_001.DBF
archive log filename=C:\ORADATA\DEMO1\ARCHIVE\DEMO1_00040_0634403463_001.DBF thr
ead=1 sequence=40
media recovery complete, elapsed time: 00:00:01
Finished recover at 08-OCT-07

contents of Memory Script:
{
   shutdown clone;
   startup clone nomount pfile= 'c:\oradata\BOX\initbox.ora';
}
executing Memory Script