26 | 06 | 2017
Latest Articles
Popular Articles

RMAN

Clone Database on another host using SETNAME and LOGFILE clause

User Rating:  / 0
PoorBest 

Clone Database on another host using SETNAME and LOGFILE clause.

 

See also Clone a database using db_file_name_convert & log_file_name_convert 

1. You need to duplicate a database on the same host but forcefully to another location than the target database, either
2. You need to duplicate a database on another host with another filesystem layout
3. You would like to use the RMAN duplicate technology since it is told to be easy.

There we go 

1. Copy password file and spfile from the target database towards the new auxiliary Oracle Home and make your change ie

2. Adjust the instance initilization parameters which uses OS paths like background_dump_dest, user_dump_dest, core_dump_dest, control_files

3. Create a valid TNS entry in the tnsnames.ora which addresses to the target database.

 

SQL> startup nomount;
ORACLE instance started.

Total System Global Area

1073741824 bytes
Fixed Size 2089400 bytes
Variable Size 700452424 bytes
Database Buffers 364904448 bytes
Redo Buffers 6295552 bytes

SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining Scoring Engine
and Real Application Testing options

rman target sys/password@target_db

RMAN > connect auxiliary /

run {
set until logseq 38968;
allocate auxiliary channel ch1 device type DISK;
allocate auxiliary channel ch2 device type DISK;
allocate auxiliary channel ch3 device type DISK;
allocate auxiliary channel ch4 device type DISK;
set newname for datafile 1 to '/u01/oradata/PLAT801M/system01.dbf';
set newname for datafile 2 to '/u01/oradata/PLAT801M/undotbs01.dbf';
set newname for datafile 3 to '/u01/oradata/PLAT801M/sysaux01.dbf';
set newname for datafile 4 to '/u01/oradata/PLAT801M/users01.dbf';
set newname for datafile 5 to '/u01/oradata/PLAT801M/som_stage_d01.dbf';
set newname for datafile 6 to '/u01/oradata/PLAT801M/som_stage_i01.dbf';
set newname for datafile 7 to '/u01/oradata/PLAT801M/audit_data01.dbf';
set newname for datafile 8 to '/u01/oradata/PLAT801M/platpifid01.dbf';
set newname for datafile 9 to '/u01/oradata/PLAT801M/platpifii01.dbf';
set newname for datafile 10 to '/u01/oradata/PLAT801M/imp_silv_d01.dbf';
set newname for datafile 11 to '/u01/oradata/PLAT801M/imp_silv_i01.dbf';
set newname for datafile 12 to '/u01/oradata/PLAT801M/imp_long_d01.dbf';
set newname for datafile 13 to '/u01/oradata/PLAT801M/imp_long_i01.dbf';
set newname for datafile 14 to '/u01/oradata/PLAT801M/imp_pall_d01.dbf';
set newname for datafile 15 to '/u01/oradata/PLAT801M/imp_pall_i01.dbf';
set newname for datafile 16 to '/u01/oradata/PLAT801M/imp_gold_d01.dbf';
set newname for datafile 17 to '/u01/oradata/PLAT801M/imp_gold_i01.dbf';
set newname for datafile 18 to '/u01/oradata/PLAT801M/irt_silv_d01.dbf';
set newname for datafile 19 to '/u01/oradata/PLAT801M/irt_silv_i01.dbf';
set newname for datafile 20 to '/u01/oradata/PLAT801M/irt_gold_d01.dbf';
set newname for datafile 21 to '/u01/oradata/PLAT801M/irt_gold_i01.dbf';
set newname for datafile 22 to '/u01/oradata/PLAT801M/place_d01.dbf';
set newname for datafile 23 to '/u01/oradata/PLAT801M/place_i01.dbf';
set newname for datafile 24 to '/u01/oradata/PLAT801M/undotbs02.dbf';
set newname for datafile 25 to '/u01/oradata/PLAT801M/platpifid02.dbf';
set newname for datafile 26 to '/u01/oradata/PLAT801M/imp_pall_d02.dbf';
set newname for tempfile 1 to '/u01/oradata/PLAT801M/temp01.dbf';
duplicate target database to PLAT801M nofilenamecheck
LOGFILE
GROUP 1 ('/u01/oradata/PLAT801M/redo01a.log') SIZE 50M REUSE,
GROUP 2 ('/u01/oradata/PLAT801M/redo02a.log') SIZE 50M REUSE,
GROUP 3 ('/u01/oradata/PLAT801M/redo03a.log') SIZE 50M REUSE;
}
 

executing command: SET until clause

allocated channel: ch1
channel ch1: sid=155 devtype=DISK

allocated channel: ch2
channel ch2: sid=154 devtype=DISK

allocated channel: ch3
channel ch3: sid=153 devtype=DISK

allocated channel: ch4
channel ch4: sid=152 devtype=DISK

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

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

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting Duplicate Db at 17-JAN-13

contents of Memory Script:
{
set until scn 8878392535231;
set newname for datafile 1 to
"/u01/oradata/PLAT801M/system01.dbf";
set newname for datafile 2 to
"/u01/oradata/PLAT801M/undotbs01.dbf";
set newname for datafile 3 to
"/u01/oradata/PLAT801M/sysaux01.dbf";
set newname for datafile 4 to
"/u01/oradata/PLAT801M/users01.dbf";
set newname for datafile 5 to
"/u01/oradata/PLAT801M/som_stage_d01.dbf";
set newname for datafile 6 to
"/u01/oradata/PLAT801M/som_stage_i01.dbf";
set newname for datafile 7 to
"/u01/oradata/PLAT801M/audit_data01.dbf";
set newname for datafile 8 to
"/u01/oradata/PLAT801M/platpifid01.dbf";
set newname for datafile 9 to
"/u01/oradata/PLAT801M/platpifii01.dbf";
set newname for datafile 10 to
"/u01/oradata/PLAT801M/imp_silv_d01.dbf";
set newname for datafile 11 to
"/u01/oradata/PLAT801M/imp_silv_i01.dbf";
set newname for datafile 12 to
"/u01/oradata/PLAT801M/imp_long_d01.dbf";
set newname for datafile 13 to
"/u01/oradata/PLAT801M/imp_long_i01.dbf";
set newname for datafile 14 to
"/u01/oradata/PLAT801M/imp_pall_d01.dbf";
set newname for datafile 15 to
"/u01/oradata/PLAT801M/imp_pall_i01.dbf";
set newname for datafile 16 to
"/u01/oradata/PLAT801M/imp_gold_d01.dbf";
set newname for datafile 17 to
"/u01/oradata/PLAT801M/imp_gold_i01.dbf";
set newname for datafile 18 to
"/u01/oradata/PLAT801M/irt_silv_d01.dbf";
set newname for datafile 19 to
"/u01/oradata/PLAT801M/irt_silv_i01.dbf";
set newname for datafile 20 to
"/u01/oradata/PLAT801M/irt_gold_d01.dbf";
set newname for datafile 21 to
"/u01/oradata/PLAT801M/irt_gold_i01.dbf";
set newname for datafile 22 to
"/u01/oradata/PLAT801M/place_d01.dbf";
set newname for datafile 23 to
"/u01/oradata/PLAT801M/place_i01.dbf";
set newname for datafile 24 to
"/u01/oradata/PLAT801M/undotbs02.dbf";
set newname for datafile 25 to
"/u01/oradata/PLAT801M/platpifid02.dbf";
set newname for datafile 26 to
"/u01/oradata/PLAT801M/imp_pall_d02.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

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

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 17-JAN-13

channel ch1: starting datafile backupset restore
channel ch1: specifying datafile(s) to restore from backup set
restoring datafile 00010 to /u01/oradata/PLAT801M/imp_silv_d01.dbf
restoring datafile 00011 to /u01/oradata/PLAT801M/imp_silv_i01.dbf
restoring datafile 00019 to /u01/oradata/PLAT801M/irt_silv_i01.dbf
channel ch1: reading from backup piece /u01/rman/PLAT801M/DB_PLAT801M_ofnvjp1a_1_1
channel ch2: starting datafile backupset restore
channel ch2: specifying datafile(s) to restore from backup set
restoring datafile 00025 to /u01/oradata/PLAT801M/platpifid02.dbf
channel ch2: reading from backup piece /u01/rman/PLAT801M/DB_PLAT801M_oenvjp19_1_1
channel ch3: starting datafile backupset restore
channel ch3: specifying datafile(s) to restore from backup set
restoring datafile 00006 to /u01/oradata/PLAT801M/som_stage_i01.dbf
restoring datafile 00012 to /u01/oradata/PLAT801M/imp_long_d01.dbf
restoring datafile 00013 to /u01/oradata/PLAT801M/imp_long_i01.dbf
restoring datafile 00015 to /u01/oradata/PLAT801M/imp_pall_i01.dbf
restoring datafile 00017 to /u01/oradata/PLAT801M/imp_gold_i01.dbf
restoring datafile 00020 to /u01/oradata/PLAT801M/irt_gold_d01.dbf
restoring datafile 00021 to /u01/oradata/PLAT801M/irt_gold_i01.dbf
channel ch3: reading from backup piece /u01/rman/PLAT801M/DB_PLAT801M_ohnvjpgl_1_1
channel ch4: starting datafile backupset restore
channel ch4: specifying datafile(s) to restore from backup set
restoring datafile 00005 to /u01/oradata/PLAT801M/som_stage_d01.dbf
restoring datafile 00009 to /u01/oradata/PLAT801M/platpifii01.dbf
restoring datafile 00016 to /u01/oradata/PLAT801M/imp_gold_d01.dbf
restoring datafile 00018 to /u01/oradata/PLAT801M/irt_silv_d01.dbf
restoring datafile 00022 to /u01/oradata/PLAT801M/place_d01.dbf
restoring datafile 00023 to /u01/oradata/PLAT801M/place_i01.dbf
restoring datafile 00026 to /u01/oradata/PLAT801M/imp_pall_d02.dbf
channel ch4: reading from backup piece /u01/rman/PLAT801M/DB_PLAT801M_ognvjpet_1_1
channel ch3: restored backup piece 1
piece handle=/u01/rman/PLAT801M/DB_PLAT801M_ohnvjpgl_1_1 tag=TAG20130117T010025
channel ch3: restore complete, elapsed time: 00:00:45
channel ch3: starting datafile backupset restore
channel ch3: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /u01/oradata/PLAT801M/audit_data01.dbf
channel ch3: reading from backup piece /u01/rman/PLAT801M/DB_PLAT801M_odnvjp19_1_1
channel ch4: restored backup piece 1
piece handle=/u01/rman/PLAT801M/DB_PLAT801M_ognvjpet_1_1 tag=TAG20130117T010025
channel ch4: restore complete, elapsed time: 00:01:50
channel ch4: starting datafile backupset restore
channel ch4: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/oradata/PLAT801M/system01.dbf
restoring datafile 00002 to /u01/oradata/PLAT801M/undotbs01.dbf
restoring datafile 00003 to /u01/oradata/PLAT801M/sysaux01.dbf
restoring datafile 00004 to /u01/oradata/PLAT801M/users01.dbf
restoring datafile 00008 to /u01/oradata/PLAT801M/platpifid01.dbf
restoring datafile 00014 to /u01/oradata/PLAT801M/imp_pall_d01.dbf
restoring datafile 00024 to /u01/oradata/PLAT801M/undotbs02.dbf
channel ch4: reading from backup piece /u01/rman/PLAT801M/DB_PLAT801M_ocnvjp19_1_1
channel ch1: restored backup piece 1
piece handle=/u01/rman/PLAT801M/DB_PLAT801M_ofnvjp1a_1_1 tag=TAG20130117T010025
channel ch1: restore complete, elapsed time: 00:02:26
channel ch2: restored backup piece 1
piece handle=/u01/rman/PLAT801M/DB_PLAT801M_oenvjp19_1_1 tag=TAG20130117T010025
channel ch2: restore complete, elapsed time: 00:03:11
channel ch3: restored backup piece 1
piece handle=/u01/rman/PLAT801M/DB_PLAT801M_odnvjp19_1_1 tag=TAG20130117T010025
channel ch3: restore complete, elapsed time: 00:06:21


datafile 22 switched to datafile copy
input datafile copy recid=21 stamp=804955670 filename=/u01/oradata/PLAT801M/place_d01.dbf
datafile 23 switched to datafile copy
input datafile copy recid=22 stamp=804955670 filename=/u01/oradata/PLAT801M/place_i01.dbf
datafile 24 switched to datafile copy
input datafile copy recid=23 stamp=804955670 filename=/u01/oradata/PLAT801M/undotbs02.dbf
datafile 25 switched to datafile copy
input datafile copy recid=24 stamp=804955670 filename=/u01/oradata/PLAT801M/platpifid02.dbf
datafile 26 switched to datafile copy
input datafile copy recid=25 stamp=804955670 filename=/u01/oradata/PLAT801M/imp_pall_d02.dbf

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

executing command: SET until clause

Starting recover at 17-JAN-13

starting media recovery

channel ch1: starting archive log restore to default destination
channel ch1: restoring archive log
archive log thread=1 sequence=38966
channel ch1: restoring archive log
archive log thread=1 sequence=38967
channel ch1: reading from backup piece /u01/rman/PLAT801M/AL_PLAT801M_ornvjtah
channel ch1: restored backup piece 1
piece handle=/u01/rman/PLAT801M/AL_PLAT801M_ornvjtah tag=TAG20130117T021252
channel ch1: restore complete, elapsed time: 00:00:08
archive log filename=/u01/oradata/PLAT801M/flash_area_recovery/PLAT801M/archivelog/2013_01_17/o1_mf_1_38966_8hj08cfh_.arc thread=1 sequence=38966
channel clone_default: deleting archive log(s)
archive log filename=/u01/oradata/PLAT801M/flash_area_recovery/PLAT801M/archivelog/2013_01_17/o1_mf_1_38966_8hj08cfh_.arc recid=2 stamp=804955680
archive log filename=/u01/oradata/PLAT801M/flash_area_recovery/PLAT801M/archivelog/2013_01_17/o1_mf_1_38967_8hj08cvy_.arc thread=1 sequence=38967
channel clone_default: deleting archive log(s)
archive log filename=/u01/oradata/PLAT801M/flash_area_recovery/PLAT801M/archivelog/2013_01_17/o1_mf_1_38967_8hj08cvy_.arc recid=1 stamp=804955675
media recovery complete, elapsed time: 00:00:05
Finished recover at 17-JAN-13

contents of Memory Script:
{
shutdown clone;
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 1610612736 bytes

Fixed Size 2084296 bytes
Variable Size 989856312 bytes
Database Buffers 603979776 bytes
Redo Buffers 14692352 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "PLAT801M" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 1168
LOGFILE
GROUP 1 ( '/u01/oradata/PLAT801M/redo01a.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/u01/oradata/PLAT801M/redo02a.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/u01/oradata/PLAT801M/redo03a.log' ) SIZE 50 M REUSE
DATAFILE
'/u01/oradata/PLAT801M/system01.dbf'
CHARACTER SET AL32UTF8


contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/oradata/PLAT801M/temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/u01/oradata/PLAT801M/undotbs01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/sysaux01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/users01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/som_stage_d01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/som_stage_i01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/audit_data01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/platpifid01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/platpifii01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/imp_silv_d01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/imp_silv_i01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/imp_long_d01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/imp_long_i01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/imp_pall_d01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/imp_pall_i01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/imp_gold_d01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/imp_gold_i01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/irt_silv_d01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/irt_silv_i01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/irt_gold_d01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/irt_gold_i01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/place_d01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/place_i01.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/undotbs02.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/platpifid02.dbf";
catalog clone datafilecopy "/u01/oradata/PLAT801M/imp_pall_d02.dbf";
switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed temporary file 1 to /u01/oradata/PLAT801M/temp01.dbf in control file

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/undotbs01.dbf recid=1 stamp=804955701

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/sysaux01.dbf recid=2 stamp=804955701

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/users01.dbf recid=3 stamp=804955701

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/som_stage_d01.dbf recid=4 stamp=804955702

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/som_stage_i01.dbf recid=5 stamp=804955702

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/audit_data01.dbf recid=6 stamp=804955702

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/platpifid01.dbf recid=7 stamp=804955702

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/platpifii01.dbf recid=8 stamp=804955703

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/imp_silv_d01.dbf recid=9 stamp=804955703

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/imp_silv_i01.dbf recid=10 stamp=804955703

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/imp_long_d01.dbf recid=11 stamp=804955703

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/imp_long_i01.dbf recid=12 stamp=804955704

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/imp_pall_d01.dbf recid=13 stamp=804955704

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/imp_pall_i01.dbf recid=14 stamp=804955704

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/imp_gold_d01.dbf recid=15 stamp=804955704

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/imp_gold_i01.dbf recid=16 stamp=804955705

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/irt_silv_d01.dbf recid=17 stamp=804955705

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/irt_silv_i01.dbf recid=18 stamp=804955705

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/irt_gold_d01.dbf recid=19 stamp=804955705

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/irt_gold_i01.dbf recid=20 stamp=804955706

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/place_d01.dbf recid=21 stamp=804955706

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/place_i01.dbf recid=22 stamp=804955706

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/undotbs02.dbf recid=23 stamp=804955707

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/platpifid02.dbf recid=24 stamp=804955707

cataloged datafile copy
datafile copy filename=/u01/oradata/PLAT801M/imp_pall_d02.dbf recid=25 stamp=804955707

datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=804955701 filename=/u01/oradata/PLAT801M/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=804955701 filename=/u01/oradata/PLAT801M/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=804955701 filename=/u01/oradata/PLAT801M/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=804955702 filename=/u01/oradata/PLAT801M/som_stage_d01.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=804955702 filename=/u01/oradata/PLAT801M/som_stage_i01.dbf
datafile 7 switched to datafile copy
input datafile copy recid=6 stamp=804955702 filename=/u01/oradata/PLAT801M/audit_data01.dbf
datafile 8 switched to datafile copy
input datafile copy recid=7 stamp=804955702 filename=/u01/oradata/PLAT801M/platpifid01.dbf
datafile 9 switched to datafile copy
input datafile copy recid=8 stamp=804955703 filename=/u01/oradata/PLAT801M/platpifii01.dbf
datafile 10 switched to datafile copy
input datafile copy recid=9 stamp=804955703 filename=/u01/oradata/PLAT801M/imp_silv_d01.dbf
datafile 11 switched to datafile copy
input datafile copy recid=10 stamp=804955703 filename=/u01/oradata/PLAT801M/imp_silv_i01.dbf
datafile 12 switched to datafile copy
input datafile copy recid=11 stamp=804955703 filename=/u01/oradata/PLAT801M/imp_long_d01.dbf
datafile 13 switched to datafile copy
input datafile copy recid=12 stamp=804955704 filename=/u01/oradata/PLAT801M/imp_long_i01.dbf
datafile 14 switched to datafile copy
input datafile copy recid=13 stamp=804955704 filename=/u01/oradata/PLAT801M/imp_pall_d01.dbf
datafile 15 switched to datafile copy
input datafile copy recid=14 stamp=804955704 filename=/u01/oradata/PLAT801M/imp_pall_i01.dbf
datafile 16 switched to datafile copy
input datafile copy recid=15 stamp=804955704 filename=/u01/oradata/PLAT801M/imp_gold_d01.dbf
datafile 17 switched to datafile copy
input datafile copy recid=16 stamp=804955705 filename=/u01/oradata/PLAT801M/imp_gold_i01.dbf
datafile 18 switched to datafile copy
input datafile copy recid=17 stamp=804955705 filename=/u01/oradata/PLAT801M/irt_silv_d01.dbf
datafile 19 switched to datafile copy
input datafile copy recid=18 stamp=804955705 filename=/u01/oradata/PLAT801M/irt_silv_i01.dbf
datafile 20 switched to datafile copy
input datafile copy recid=19 stamp=804955705 filename=/u01/oradata/PLAT801M/irt_gold_d01.dbf
datafile 21 switched to datafile copy
input datafile copy recid=20 stamp=804955706 filename=/u01/oradata/PLAT801M/irt_gold_i01.dbf
datafile 22 switched to datafile copy
input datafile copy recid=21 stamp=804955706 filename=/u01/oradata/PLAT801M/place_d01.dbf
datafile 23 switched to datafile copy
input datafile copy recid=22 stamp=804955706 filename=/u01/oradata/PLAT801M/place_i01.dbf
datafile 24 switched to datafile copy
input datafile copy recid=23 stamp=804955707 filename=/u01/oradata/PLAT801M/undotbs02.dbf
datafile 25 switched to datafile copy
input datafile copy recid=24 stamp=804955707 filename=/u01/oradata/PLAT801M/platpifid02.dbf
datafile 26 switched to datafile copy
input datafile copy recid=25 stamp=804955707 filename=/u01/oradata/PLAT801M/imp_pall_d02.dbf


contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 17-JAN-13

RMAN>