tement: CREATE CONTROLFILE REUSE SET DATABASE "ORCLDUP" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 '/u01/app/oracle/oradata/orcldup/redo01.log' SIZE 20 M ,
GROUP 2 '/u01/app/oracle/oradata/orcldup/redo02.log' SIZE 20 M ,
GROUP 3 '/u01/app/oracle/oradata/orcldup/redo03.log' SIZE 20 M
DATAFILE
'/u01/dup_test/orcldup/system01.dbf'
CHARACTER SET WE8ISO8859P1
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/dup_test/orcldup/temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/u01/dup_test/orcldup/undotbs01.dbf";
catalog clone datafilecopy "/u01/dup_test/orcldup/sysaux01.dbf";
catalog clone datafilecopy "/u01/dup_test/orcldup/users01.dbf";
catalog clone datafilecopy "/u01/dup_test/orcldup/example01.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed temporary file 1 to /u01/dup_test/orcldup/temp01.dbf in control file
cataloged datafile copy
datafile copy filename=/u01/dup_test/orcldup/undotbs01.dbf recid=1 stamp=845228858
cataloged datafile copy
datafile copy filename=/u01/dup_test/orcldup/sysaux01.dbf recid=2 stamp=845228860
cataloged datafile copy
datafile copy filename=/u01/dup_test/orcldup/users01.dbf recid=3 stamp=845228862
cataloged datafile copy
datafile copy filename=/u01/dup_test/orcldup/example01.dbf recid=4 stamp=845228865
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=845228858 filename=/u01/dup_test/orcldup/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=845228860 filename=/u01/dup_test/orcldup/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=845228862 filename=/u01/dup_test/orcldup/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=845228865 filename=/u01/dup_test/orcldup/example01.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 18-APR-14
RMAN>
验证：
SQL> conn sys/safe@orcl_dup as sysdba
Connected.
SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
TEMP
UNDOTBS1
SYSAUX
USERS
EXAMPLE
6 rows selected.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
/u01/dup_test/orcldup/system01.dbf
/u01/dup_test/orcldup/undotbs01.dbf
/u01/dup_test/orcldup/sysaux01.dbf
/u01/dup_test/orcldup/users01.dbf
/u01/dup_test/orcldup/example01.dbf
SQL> select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
/u01/dup_test/orcldup/temp01.dbf
注意路径已经转化。