{
sql clone "alter system set db_name =
''IBS'' comment=
''Modified by RMAN duplicate'' scope=spfile";
sql clone "alter system set db_unique_name =
''ORCL1'' comment=
''Modified by RMAN duplicate'' scope=spfile";
shutdown clone immediate;
startup clone force nomount
backup as copy current controlfile auxiliary format 'E:\APP\ADMINISTRATOR\OR
ADATA\ORCL1\CONTROL01.CTL';
restore clone controlfile to 'E:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL1
\CONTROL02.CTL' from
'E:\APP\ADMINISTRATOR\ORADATA\ORCL1\CONTROL01.CTL';
alter clone database mount;
}
executing Memory Script
sql statement: alter system set db_name = ''IBS'' comment= ''Modified by RMAN
duplicate'' scope=spfile
sql statement: alter system set db_unique_name = ''ORCL1'' comment= ''Modified
by RMAN duplicate'' scope=spfile
Oracle instance shut down
Oracle instance started
Total System Global Area 9820950528 bytes
Fixed Size 2184112 bytes
Variable Size 5033167952 bytes
Database Buffers 4764729344 bytes
Redo Buffers 20869120 bytes
Starting backup at 30-DEC-11
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=187 device type=DISK
channel ORA_DISK_1: starting datafile copy
copying current control file
output file name=E:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\SNCFIBS.O
RA tag=TAG20111230T181012 RECID=1 STAMP=771271813
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 30-DEC-11
Starting restore at 30-DEC-11
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=193 device type=DISK
channel ORA_AUX_DISK_1: copied control file copy
Finished restore at 30-DEC-11
database mounted
contents of Memory Script:
{
set newname for datafile 1 to
"F:\BBCLDB\ORCL1\SYSTEM01.DBF";
set newname for datafile 2 to
"F:\BBCLDB\ORCL1\SYSAUX01.DBF";
set newname for datafile 3 to
"F:\BBCLDB\ORCL1\UNDOTBS01.DBF";
set newname for datafile 4 to
"F:\BBCLDB\ORCL1\USERS01.DBF";
set newname for datafile 5 to
"F:\BBCLDB\ORCL1\CI_DATALRG01.DBF";
set newname for datafile 6 to
"F:\BBCLDB\ORCL1\DATAUSR01.DBF";
set newname for datafile 7 to
"F:\BBCLDB\ORCL1\DATALRG01.DBF";
set newname for datafile 8 to
"F:\BBCLDB\ORCL1\DATASML01.DBF";
set newname for datafile 9 to
"F:\BBCLDB\ORCL1\INDEXLRG01.DBF";
set newname for datafile 10 to
"F:\BBCLDB\ORCL1\INDEXSML.DBF";
set newname for datafile 11 to
"F:\BBCLDB\ORCL1\DATALRG02.DBF";
set newname for datafile 12 to
"F:\BBCLDB\ORCL1\DATALRG03.DBF";
set newname for datafile 13 to
"F:\BBCLDB\ORCL1\DATALRG04.DBF";
set newname for datafile 14 to
"F:\BBCLDB\ORCL1\DATALRG05.DBF";
set newname for datafile 15 to
"F:\BBCLDB\ORCL1\DATALRG06.DBF";
set newname for datafile 16 to
"F:\BBCLDB\ORCL1\DATALRG07.DBF";
set newname for datafile 17 to
"F:\BBCLDB\ORCL1\INDEXLRG02.DBF";
set newname for datafile 18 to
"F:\BBCLDB\ORCL1\INDEXLRG03.DBF";
set newname for datafile 19 to
"F:\BBCLDB\ORCL1\INDEXLRG04.DBF";
set newname for datafile 20 to
"F:\BBCLDB\ORCL1\INDEXLRG05.DBF";
set newname for datafile 21 to
"F:\BBCLDB\ORCL1\INDEXLRG06.DBF";
set newname for datafile 22 to
"F:\BBCLDB\ORCL1\INDEXLRG07.DBF";
set newname for datafile 23 to
"F:\BBCLDB\ORCL1\DATALRG08.DBF";
backup as copy reuse
datafile 1 auxiliary format
"F:\BB