Duplicate clone database from backup location

You don’t need to use traditional method.(Restore control-file,catalog it,restore,recover,rename,etc…)

Just connect auxiliary (not target) database with RMAN and run duplicate script.Make sure database in no-mount mode with new dbname.

Version 12.2.0.1

rman auxiliary /
run {
allocate auxiliary channel c1 type disk;
allocate auxiliary channel c2 type disk;
allocate auxiliary channel c3 type disk;
allocate auxiliary channel c4 type disk;
allocate auxiliary channel c5 type disk;
allocate auxiliary channel c6 type disk;
allocate auxiliary channel c7 type disk;
allocate auxiliary channel c8 type disk;
allocate auxiliary channel c9 type disk;
allocate auxiliary channel c10 type disk;
DUPLICATE TARGET DATABASE TO myclone BACKUP LOCATION ‘/orabackup1/devx1/backup’;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
release channel c6;
release channel c7;
release channel c8;
release channel c9;
release channel c10;
}

 

### Here is output. RMAN take care of everything.

 

RMAN> connect auxiliary /

connected to auxiliary database: MYCLONE (not mounted)

RMAN> run {
2> allocate auxiliary channel c1 type disk;
3> allocate auxiliary channel c2 type disk;
4> allocate auxiliary channel c3 type disk;
5> allocate auxiliary channel c4 type disk;
6> allocate auxiliary channel c5 type disk;
7> allocate auxiliary channel c6 type disk;
8> allocate auxiliary channel c7 type disk;
9> allocate auxiliary channel c8 type disk;
10> allocate auxiliary channel c9 type disk;
11> allocate auxiliary channel c10 type disk;
12> DUPLICATE TARGET DATABASE TO myclone BACKUP LOCATION ‘/orabackup1/devx1/backup’;
13> release channel c1;
14> release channel c2;
15> release channel c3;
16> release channel c4;
17> release channel c5;
18> release channel c6;
19> release channel c7;
20> release channel c8;
21> release channel c9;
22> release channel c10;
23> }

allocated channel: c1
channel c1: SID=245 device type=DISK

allocated channel: c2
channel c2: SID=366 device type=DISK

allocated channel: c3
channel c3: SID=487 device type=DISK

allocated channel: c4
channel c4: SID=608 device type=DISK

allocated channel: c5
channel c5: SID=729 device type=DISK

allocated channel: c6
channel c6: SID=850 device type=DISK

allocated channel: c7
channel c7: SID=971 device type=DISK

allocated channel: c8
channel c8: SID=1092 device type=DISK

allocated channel: c9
channel c9: SID=1213 device type=DISK

allocated channel: c10
channel c10: SID=1334 device type=DISK

Starting Duplicate Db at 09-APR-19

contents of Memory Script:
{
sql clone “create spfile from memory”;
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount;
}
executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 6442450944 bytes

Fixed Size 8807168 bytes
Variable Size 3070233856 bytes
Database Buffers 1107296256 bytes
Redo Buffers 108630016 bytes
In-Memory Area 2147483648 bytes
allocated channel: c1
channel c1: SID=245 device type=DISK
allocated channel: c2
channel c2: SID=366 device type=DISK
allocated channel: c3
channel c3: SID=487 device type=DISK
allocated channel: c4
channel c4: SID=608 device type=DISK
allocated channel: c5
channel c5: SID=729 device type=DISK
allocated channel: c6
channel c6: SID=850 device type=DISK
allocated channel: c7
channel c7: SID=971 device type=DISK
allocated channel: c8
channel c8: SID=1090 device type=DISK
allocated channel: c9
channel c9: SID=1213 device type=DISK
allocated channel: c10
channel c10: SID=1334 device type=DISK

contents of Memory Script:
{
sql clone “alter system set control_files =
”+DATA_devx1/MYCLONE/CONTROLFILE/current.1030.1005148929”, ”+RECO_devx1/MYCLONE/CONTROLFILE/current.382.1005148931” comment=
”Set by RMAN” scope=spfile”;
sql clone “alter system set db_name =
”MYCDB” comment=
”Modified by RMAN duplicate” scope=spfile”;
sql clone “alter system set db_unique_name =
”myclone” comment=
”Modified by RMAN duplicate” scope=spfile”;
shutdown clone immediate;
startup clone force nomount
restore clone primary controlfile from ‘/orabackup1/devx1/backup/MYCDB_control_file.bkp’;
alter clone database mount;
}
executing Memory Script

sql statement: alter system set control_files = ”+DATA_devx1/MYCLONE/CONTROLFILE/current.1030.1005148929”, ”+RECO_devx1/MYCLONE/CONTROLFILE/current.382.1005148931” comment= ”Set by RMAN” scope=spfile

sql statement: alter system set db_name = ”MYCDB” comment= ”Modified by RMAN duplicate” scope=spfile

sql statement: alter system set db_unique_name = ”myclone” comment= ”Modified by RMAN duplicate” scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area 6442450944 bytes

Fixed Size 8807168 bytes
Variable Size 3070233856 bytes
Database Buffers 1107296256 bytes
Redo Buffers 108630016 bytes
In-Memory Area 2147483648 bytes
allocated channel: c1
channel c1: SID=729 device type=DISK
allocated channel: c2
channel c2: SID=851 device type=DISK
allocated channel: c3
channel c3: SID=971 device type=DISK
allocated channel: c4
channel c4: SID=1092 device type=DISK
allocated channel: c5
channel c5: SID=1213 device type=DISK
allocated channel: c6
channel c6: SID=1334 device type=DISK
allocated channel: c7
channel c7: SID=1455 device type=DISK
allocated channel: c8
channel c8: SID=1577 device type=DISK
allocated channel: c9
channel c9: SID=1697 device type=DISK
allocated channel: c10
channel c10: SID=1819 device type=DISK

Starting restore at 09-APR-19

channel c2: skipped, AUTOBACKUP already found
channel c3: skipped, AUTOBACKUP already found
channel c4: skipped, AUTOBACKUP already found
channel c5: skipped, AUTOBACKUP already found
channel c6: skipped, AUTOBACKUP already found
channel c7: skipped, AUTOBACKUP already found
channel c8: skipped, AUTOBACKUP already found
channel c9: skipped, AUTOBACKUP already found
channel c10: skipped, AUTOBACKUP already found
channel c1: restoring control file
channel c1: restore complete, elapsed time: 00:00:14
output file name=+DATA_devx1/MYCLONE/CONTROLFILE/current.1030.1005148929
output file name=+RECO_devx1/MYCLONE/CONTROLFILE/current.382.1005148931
Finished restore at 09-APR-19

database mounted

contents of Memory Script:
{
set until scn 34801815;
sql clone ‘alter database flashback off’;
set newname for clone datafile 1 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 4 to new;
set newname for clone datafile 5 to new;
set newname for clone datafile 6 to new;
set newname for clone datafile 8 to new;
set newname for clone datafile 9 to new;
set newname for clone datafile 10 to new;
set newname for clone datafile 11 to new;
set newname for clone datafile 28 to new;
set newname for clone datafile 29 to new;
set newname for clone datafile 30 to new;
set newname for clone datafile 31 to new;
set newname for clone datafile 32 to new;
set newname for clone datafile 33 to new;
set newname for clone datafile 34 to new;
set newname for clone datafile 35 to new;
set newname for clone datafile 36 to new;
set newname for clone datafile 37 to new;
set newname for clone datafile 38 to new;
set newname for clone datafile 39 to new;
set newname for clone datafile 40 to new;
set newname for clone datafile 41 to new;
restore
clone database
;
}
executing Memory Script

executing command: SET until clause

sql statement: alter database flashback off

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 09-APR-19

channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00006 to +DATA_devx1
channel c1: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14762_1
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00004 to +DATA_devx1
channel c2: restoring datafile 00029 to +DATA_devx1
channel c2: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14757_1
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00009 to +DATA_devx1
channel c3: restoring datafile 00028 to +DATA_devx1
channel c3: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14756_1
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00010 to +DATA_devx1
channel c4: restoring datafile 00036 to +DATA_devx1
channel c4: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14759_1
channel c5: starting datafile backup set restore
channel c5: specifying datafile(s) to restore from backup set
channel c5: restoring datafile 00034 to +DATA_devx1
channel c5: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14761_1
channel c6: starting datafile backup set restore
channel c6: specifying datafile(s) to restore from backup set
channel c6: restoring datafile 00037 to +DATA_devx1
channel c6: restoring datafile 00038 to +DATA_devx1
channel c6: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14755_1
channel c7: starting datafile backup set restore
channel c7: specifying datafile(s) to restore from backup set
channel c7: restoring datafile 00003 to +DATA_devx1
channel c7: restoring datafile 00039 to +DATA_devx1
channel c7: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14754_1
channel c8: starting datafile backup set restore
channel c8: specifying datafile(s) to restore from backup set
channel c8: restoring datafile 00031 to +DATA_devx1
channel c8: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14760_1
channel c9: starting datafile backup set restore
channel c9: specifying datafile(s) to restore from backup set
channel c9: restoring datafile 00033 to +DATA_devx1
channel c9: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14764_1
channel c10: starting datafile backup set restore
channel c10: specifying datafile(s) to restore from backup set
channel c10: restoring datafile 00001 to +DATA_devx1
channel c10: restoring datafile 00011 to +DATA_devx1
channel c10: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14758_1
channel c2: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14757_1 tag=TAG20190409T141723
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:00:04
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00005 to +DATA_devx1
channel c2: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14765_1
channel c3: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14756_1 tag=TAG20190409T141723
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:00:04
channel c3: starting datafile backup set restore
channel c3: specifying datafile(s) to restore from backup set
channel c3: restoring datafile 00030 to +DATA_devx1
channel c3: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14763_1
channel c4: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14759_1 tag=TAG20190409T141723
channel c4: restored backup piece 1
channel c4: restore complete, elapsed time: 00:00:04
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00032 to +DATA_devx1
channel c4: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14766_1
channel c4: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14766_1 tag=TAG20190409T141723
channel c4: restored backup piece 1
channel c4: restore complete, elapsed time: 00:00:04
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00008 to +DATA_devx1
channel c4: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14767_1
channel c6: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14755_1 tag=TAG20190409T141723
channel c6: restored backup piece 1
channel c6: restore complete, elapsed time: 00:00:08
channel c6: starting datafile backup set restore
channel c6: specifying datafile(s) to restore from backup set
channel c6: restoring datafile 00035 to +DATA_devx1
channel c6: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14769_1
channel c6: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14769_1 tag=TAG20190409T141723
channel c6: restored backup piece 1
channel c6: restore complete, elapsed time: 00:00:01
channel c6: starting datafile backup set restore
channel c6: specifying datafile(s) to restore from backup set
channel c6: restoring datafile 00040 to +DATA_devx1
channel c6: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14768_1
channel c4: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14767_1 tag=TAG20190409T141723
channel c4: restored backup piece 1
channel c4: restore complete, elapsed time: 00:00:02
channel c4: starting datafile backup set restore
channel c4: specifying datafile(s) to restore from backup set
channel c4: restoring datafile 00041 to +DATA_devx1
channel c4: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14770_1
channel c6: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14768_1 tag=TAG20190409T141723
channel c6: restored backup piece 1
channel c6: restore complete, elapsed time: 00:00:01
channel c4: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14770_1 tag=TAG20190409T141723
channel c4: restored backup piece 1
channel c4: restore complete, elapsed time: 00:00:01
channel c2: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14765_1 tag=TAG20190409T141723
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:00:14
channel c3: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14763_1 tag=TAG20190409T141723
channel c3: restored backup piece 1
channel c3: restore complete, elapsed time: 00:00:13
channel c9: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14764_1 tag=TAG20190409T141723
channel c9: restored backup piece 1
channel c9: restore complete, elapsed time: 00:00:16
channel c1: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14762_1 tag=TAG20190409T141723
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:36
channel c5: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14761_1 tag=TAG20190409T141723
channel c5: restored backup piece 1
channel c5: restore complete, elapsed time: 00:00:45
channel c8: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14760_1 tag=TAG20190409T141723
channel c8: restored backup piece 1
channel c8: restore complete, elapsed time: 00:00:44
channel c10: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14758_1 tag=TAG20190409T141723
channel c10: restored backup piece 1
channel c10: restore complete, elapsed time: 00:00:44

channel c7: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14754_1 tag=TAG20190409T141723
channel c7: restored backup piece 1
channel c7: restore complete, elapsed time: 00:01:25
Finished restore at 09-APR-19

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

datafile 1 switched to datafile copy
input datafile copy RECID=24 STAMP=1005149104 file name=+DATA_devx1/MYCLONE/DATAFILE/system.1469.1005149021
datafile 3 switched to datafile copy
input datafile copy RECID=25 STAMP=1005149104 file name=+DATA_devx1/MYCLONE/DATAFILE/sysaux.1397.1005149021
datafile 4 switched to datafile copy
input datafile copy RECID=26 STAMP=1005149104 file name=+DATA_devx1/MYCLONE/DATAFILE/undotbs1.4722.1005149019
datafile 5 switched to datafile copy
input datafile copy RECID=27 STAMP=1005149104 file name=+DATA_devx1/MYCLONE/6A394766F7B2CCCEE0533C281BACC06B/DATAFILE/system.1533.1005149023
datafile 6 switched to datafile copy
input datafile copy RECID=28 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/6A394766F7B2CCCEE0533C281BACC06B/DATAFILE/sysaux.4399.1005149019
datafile 8 switched to datafile copy
input datafile copy RECID=29 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/6A394766F7B2CCCEE0533C281BACC06B/DATAFILE/undotbs1.1634.1005149027
datafile 9 switched to datafile copy
input datafile copy RECID=30 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/DATAFILE/undotbs2.1930.1005149019
datafile 10 switched to datafile copy
input datafile copy RECID=31 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/DATAFILE/undotbs3.1922.1005149021
datafile 11 switched to datafile copy
input datafile copy RECID=32 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/DATAFILE/undotbs4.1560.1005149023
datafile 28 switched to datafile copy
input datafile copy RECID=33 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1331.1005149019
datafile 29 switched to datafile copy
input datafile copy RECID=34 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/DATAFILE/users3.3656.1005149019
datafile 30 switched to datafile copy
input datafile copy RECID=35 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/754B89790418FF71E0533D281BAC20CC/DATAFILE/system.1580.1005149025
datafile 31 switched to datafile copy
input datafile copy RECID=36 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/754B89790418FF71E0533D281BAC20CC/DATAFILE/sysaux.468.1005149021
datafile 32 switched to datafile copy
input datafile copy RECID=37 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/754B89790418FF71E0533D281BAC20CC/DATAFILE/undotbs1.1620.1005149025
datafile 33 switched to datafile copy
input datafile copy RECID=38 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/754B8979041AFF71E0533D281BAC20CC/DATAFILE/system.1497.1005149021
datafile 34 switched to datafile copy
input datafile copy RECID=39 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/754B8979041AFF71E0533D281BAC20CC/DATAFILE/sysaux.1038.1005149019
datafile 35 switched to datafile copy
input datafile copy RECID=40 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/754B8979041AFF71E0533D281BAC20CC/DATAFILE/undotbs1.1700.1005149027
datafile 36 switched to datafile copy
input datafile copy RECID=41 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1926.1005149019
datafile 37 switched to datafile copy
input datafile copy RECID=42 STAMP=1005149105 file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1485.1005149021
datafile 38 switched to datafile copy
input datafile copy RECID=43 STAMP=1005149106 file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1241.1005149021
datafile 39 switched to datafile copy
input datafile copy RECID=44 STAMP=1005149106 file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1529.1005149023
datafile 40 switched to datafile copy
input datafile copy RECID=45 STAMP=1005149106 file name=+DATA_devx1/MYCLONE/754B89790418FF71E0533D281BAC20CC/DATAFILE/undo_2.1664.1005149029
datafile 41 switched to datafile copy
input datafile copy RECID=46 STAMP=1005149106 file name=+DATA_devx1/MYCLONE/754B8979041AFF71E0533D281BAC20CC/DATAFILE/undo_2.2891.1005149029

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

executing command: SET until clause

Starting recover at 09-APR-19

starting media recovery

channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=87
channel c1: reading from backup piece /orabackup1/devx1/backup/MYCDB_FULL_20190409_14771_1
channel c1: piece handle=/orabackup1/devx1/backup/MYCDB_FULL_20190409_14771_1 tag=TAG20190409T141858
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:01
archived log file name=+RECO_devx1/MYCLONE/ARCHIVELOG/2019_04_09/thread_1_seq_87.2480.1005149113 thread=1 sequence=87
channel clone_default: deleting archived log(s)
archived log file name=+RECO_devx1/MYCLONE/ARCHIVELOG/2019_04_09/thread_1_seq_87.2480.1005149113 RECID=1 STAMP=1005149112
media recovery complete, elapsed time: 00:00:01
Finished recover at 09-APR-19
released channel: c1
released channel: c2
released channel: c3
released channel: c4
released channel: c5
released channel: c6
released channel: c7
released channel: c8
released channel: c9
released channel: c10
Oracle instance started

Total System Global Area 6442450944 bytes

Fixed Size 8807168 bytes
Variable Size 3070233856 bytes
Database Buffers 1107296256 bytes
Redo Buffers 108630016 bytes
In-Memory Area 2147483648 bytes

contents of Memory Script:
{
sql clone “alter system set db_name =
”MYCLONE” comment=
”Reset to original value by RMAN” scope=spfile”;
sql clone “alter system reset db_unique_name scope=spfile”;
}
executing Memory Script

sql statement: alter system set db_name = ”MYCLONE” comment= ”Reset to original value by RMAN” scope=spfile

sql statement: alter system reset db_unique_name scope=spfile
Oracle instance started

Total System Global Area 6442450944 bytes

Fixed Size 8807168 bytes
Variable Size 3070233856 bytes
Database Buffers 1107296256 bytes
Redo Buffers 108630016 bytes
In-Memory Area 2147483648 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE “MYCLONE” RESETLOGS ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 292
LOGFILE
GROUP 11 SIZE 4 G ,
GROUP 12 SIZE 4 G ,
GROUP 13 SIZE 4 G ,
GROUP 14 SIZE 4 G
DATAFILE
‘+DATA_devx1/MYCLONE/DATAFILE/system.1469.1005149021’,
‘+DATA_devx1/MYCLONE/6A394766F7B2CCCEE0533C281BACC06B/DATAFILE/system.1533.1005149023’,
‘+DATA_devx1/MYCLONE/754B89790418FF71E0533D281BAC20CC/DATAFILE/system.1580.1005149025’,
‘+DATA_devx1/MYCLONE/754B8979041AFF71E0533D281BAC20CC/DATAFILE/system.1497.1005149021’
CHARACTER SET AL32UTF8

contents of Memory Script:
{
set newname for clone tempfile 1 to new;
set newname for clone tempfile 2 to new;
set newname for clone tempfile 3 to new;
set newname for clone tempfile 4 to new;
switch clone tempfile all;
catalog clone datafilecopy “+DATA_devx1/MYCLONE/DATAFILE/sysaux.1397.1005149021”,
“+DATA_devx1/MYCLONE/DATAFILE/undotbs1.4722.1005149019”,
“+DATA_devx1/MYCLONE/6A394766F7B2CCCEE0533C281BACC06B/DATAFILE/sysaux.4399.1005149019”,
“+DATA_devx1/MYCLONE/6A394766F7B2CCCEE0533C281BACC06B/DATAFILE/undotbs1.1634.1005149027”,
“+DATA_devx1/MYCLONE/DATAFILE/undotbs2.1930.1005149019”,
“+DATA_devx1/MYCLONE/DATAFILE/undotbs3.1922.1005149021”,
“+DATA_devx1/MYCLONE/DATAFILE/undotbs4.1560.1005149023”,
“+DATA_devx1/MYCLONE/DATAFILE/users2.1331.1005149019”,
“+DATA_devx1/MYCLONE/DATAFILE/users3.3656.1005149019”,
“+DATA_devx1/MYCLONE/754B89790418FF71E0533D281BAC20CC/DATAFILE/sysaux.468.1005149021”,
“+DATA_devx1/MYCLONE/754B89790418FF71E0533D281BAC20CC/DATAFILE/undotbs1.1620.1005149025”,
“+DATA_devx1/MYCLONE/754B8979041AFF71E0533D281BAC20CC/DATAFILE/sysaux.1038.1005149019”,
“+DATA_devx1/MYCLONE/754B8979041AFF71E0533D281BAC20CC/DATAFILE/undotbs1.1700.1005149027”,
“+DATA_devx1/MYCLONE/DATAFILE/users2.1926.1005149019”,
“+DATA_devx1/MYCLONE/DATAFILE/users2.1485.1005149021”,
“+DATA_devx1/MYCLONE/DATAFILE/users2.1241.1005149021”,
“+DATA_devx1/MYCLONE/DATAFILE/users2.1529.1005149023”,
“+DATA_devx1/MYCLONE/754B89790418FF71E0533D281BAC20CC/DATAFILE/undo_2.1664.1005149029”,
“+DATA_devx1/MYCLONE/754B8979041AFF71E0533D281BAC20CC/DATAFILE/undo_2.2891.1005149029”;
switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to +DATA_devx1 in control file
renamed tempfile 2 to +DATA_devx1 in control file
renamed tempfile 3 to +DATA_devx1 in control file
renamed tempfile 4 to +DATA_devx1 in control file

cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/DATAFILE/sysaux.1397.1005149021 RECID=1 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/DATAFILE/undotbs1.4722.1005149019 RECID=2 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/6A394766F7B2CCCEE0533C281BACC06B/DATAFILE/sysaux.4399.1005149019 RECID=3 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/6A394766F7B2CCCEE0533C281BACC06B/DATAFILE/undotbs1.1634.1005149027 RECID=4 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/DATAFILE/undotbs2.1930.1005149019 RECID=5 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/DATAFILE/undotbs3.1922.1005149021 RECID=6 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/DATAFILE/undotbs4.1560.1005149023 RECID=7 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1331.1005149019 RECID=8 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/DATAFILE/users3.3656.1005149019 RECID=9 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/754B89790418FF71E0533D281BAC20CC/DATAFILE/sysaux.468.1005149021 RECID=10 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/754B89790418FF71E0533D281BAC20CC/DATAFILE/undotbs1.1620.1005149025 RECID=11 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/754B8979041AFF71E0533D281BAC20CC/DATAFILE/sysaux.1038.1005149019 RECID=12 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/754B8979041AFF71E0533D281BAC20CC/DATAFILE/undotbs1.1700.1005149027 RECID=13 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1926.1005149019 RECID=14 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1485.1005149021 RECID=15 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1241.1005149021 RECID=16 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1529.1005149023 RECID=17 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/754B89790418FF71E0533D281BAC20CC/DATAFILE/undo_2.1664.1005149029 RECID=18 STAMP=1005149161
cataloged datafile copy
datafile copy file name=+DATA_devx1/MYCLONE/754B8979041AFF71E0533D281BAC20CC/DATAFILE/undo_2.2891.1005149029 RECID=19 STAMP=1005149161

datafile 3 switched to datafile copy
input datafile copy RECID=1 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/DATAFILE/sysaux.1397.1005149021
datafile 4 switched to datafile copy
input datafile copy RECID=2 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/DATAFILE/undotbs1.4722.1005149019
datafile 6 switched to datafile copy
input datafile copy RECID=3 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/6A394766F7B2CCCEE0533C281BACC06B/DATAFILE/sysaux.4399.1005149019
datafile 8 switched to datafile copy
input datafile copy RECID=4 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/6A394766F7B2CCCEE0533C281BACC06B/DATAFILE/undotbs1.1634.1005149027
datafile 9 switched to datafile copy
input datafile copy RECID=5 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/DATAFILE/undotbs2.1930.1005149019
datafile 10 switched to datafile copy
input datafile copy RECID=6 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/DATAFILE/undotbs3.1922.1005149021
datafile 11 switched to datafile copy
input datafile copy RECID=7 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/DATAFILE/undotbs4.1560.1005149023
datafile 28 switched to datafile copy
input datafile copy RECID=8 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1331.1005149019
datafile 29 switched to datafile copy
input datafile copy RECID=9 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/DATAFILE/users3.3656.1005149019
datafile 31 switched to datafile copy
input datafile copy RECID=10 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/754B89790418FF71E0533D281BAC20CC/DATAFILE/sysaux.468.1005149021
datafile 32 switched to datafile copy
input datafile copy RECID=11 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/754B89790418FF71E0533D281BAC20CC/DATAFILE/undotbs1.1620.1005149025
datafile 34 switched to datafile copy
input datafile copy RECID=12 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/754B8979041AFF71E0533D281BAC20CC/DATAFILE/sysaux.1038.1005149019
datafile 35 switched to datafile copy
input datafile copy RECID=13 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/754B8979041AFF71E0533D281BAC20CC/DATAFILE/undotbs1.1700.1005149027
datafile 36 switched to datafile copy
input datafile copy RECID=14 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1926.1005149019
datafile 37 switched to datafile copy
input datafile copy RECID=15 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1485.1005149021
datafile 38 switched to datafile copy
input datafile copy RECID=16 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1241.1005149021
datafile 39 switched to datafile copy
input datafile copy RECID=17 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/DATAFILE/users2.1529.1005149023
datafile 40 switched to datafile copy
input datafile copy RECID=18 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/754B89790418FF71E0533D281BAC20CC/DATAFILE/undo_2.1664.1005149029
datafile 41 switched to datafile copy
input datafile copy RECID=19 STAMP=1005149161 file name=+DATA_devx1/MYCLONE/754B8979041AFF71E0533D281BAC20CC/DATAFILE/undo_2.2891.1005149029
Reenabling controlfile options for auxiliary database
Executing: alter database add supplemental log data
Executing: alter database force logging

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

database opened
Executing: alter database flashback on

contents of Memory Script:
{
sql clone “alter pluggable database all open”;
}
executing Memory Script

sql statement: alter pluggable database all open
Cannot remove created server parameter file
Finished Duplicate Db at 09-APR-19

RMAN>
RMAN>

Leave a Reply

Your email address will not be published. Required fields are marked *