RMAN
Clone Database on another host using SETNAME and LOGFILE clause
User Rating: / 0
- Details
-
Parent Category: Articles
-
Created on Wednesday, 13 February 2013 11:32
-
Last Updated on Tuesday, 10 December 2019 14:59
-
Published on Wednesday, 13 February 2013 11:35
-
Hits: 8445
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>