RMAN复制数据库（九）

执行步骤如下:1.创建辅助实例的密码文件(这里辅助实例名为dup)

[oracle@jingyong1 dbs]$ orapwd file=/u01/app/oracle/product/10.2.0/db/dbs/orapwdup password=oracle entries=10 [oracle@jingyong1 dbs]$ ls -lrt orapwdup -rw-r----- 1 oracle oinstall 2560 Mar 25 20:49 orapwdup

2.创建辅助实例网络连接,修改监听文件，使用静态监听来监听辅助实例远程主机jingyong1

[oracle@jingyong1 admin]$ vi listener.ora  SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =      (SID_NAME = dup)       (ORACLE_HOME =/u01/app/oracle/product/10.2.0/db)     )   )  LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.11)(PORT = 1521))     )   )

给辅助实例增加网络服务名

[oracle@jingyong1 admin]$ vi tnsnames.ora dup =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.56.11)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME =dup)       (UR=A)     )   )

在目标主机上给辅助实例增加网络服务名

[oracle@oracle11g admin]$ vi tnsnames.ora dup =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.56.11)(PORT = 1521))     )     (CONNECT_DATA =       (SERVICE_NAME =dup)       (UR=A)     )   )

测试网络连接远程主机jingyong1

[oracle@jingyong1 admin]$ export ORACLE_SID=dup [oracle@jingyong1 admin]$ sqlplus /nolog  SQL*Plus: Release 10.2.0.5.0 - Production on Wed Mar 25 20:53:26 2015  Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.  SQL> conn sys/oracle@dup as sysdba Connected to an idle instance.

目标主机oracle11g

[oracle@oracle11g admin]$ sqlplus /nolog  SQL*Plus: Release 10.2.0.5.0 - Production on Wed Mar 25 21:00:13 2015  Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.  SQL> conn sys/oracle@dup as sysdba Connected to an idle instance.

3.创建辅助实例的参数文件

[oracle@jingyong1 dbs]$ vi initdup.ora  db_name=dup db_unique_name=dup control_files= /u01/app/oracle/oradata/dup/control01.ctl #db_file_name_convert=('/u01/app/oracle/oradata/test/','/u01/app/oracle/oradata/dup/') #log_file_name_convert=('/u01/app/oracle/oradata/test/','/u01/app/oracle/oradata/dup/') remote_login_passwordfile=exclusive compatible = 10.2.0.5.0 db_block_size=8192 sga_target=160M sga_max_size=160M pga_aggregate_target=16M     [oracle@jingyong1 dbs]$ export ORACLE_SID=dup [oracle@jingyong1 dbs]$ sqlplus / as sysdba  SQL*Plus: Release 10.2.0.5.0 - Production on Wed Mar 25 21:08:14 2015  Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.  Connected to an idle instance.  SQL> create spfile from pfile='/u01/app/oracle/product/10.2.0/db/dbs/initdup.ora';  File created.

4.启动辅助实例

[oracle@jingyong1 dbs]$ export ORACLE_SID=dup [oracle@jingyong1 dbs]$ sqlplus / as sysdba  SQL*Plus: Release 10.2.0.5.0 - Production on Thu Mar 26 09:06:57 2015  Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.  Connected to an idle instance.  SQL> startup nomount ORACLE instance started.  Total System Global Area  167772160 bytes Fixed Size                  1272624 bytes Variable Size              58721488 bytes Database Buffers          104857600 bytes Redo Buffers                2920448 bytes SQL> set long 300 SQL> set linesize 300 SQL> show parameter spfile  NAME                                 TYPE                   VALUE ------------------------------------ ---------------------- ------------------------------ spfile                               string                 /u01/app/oracle/product/10.2.0                                                             /db/dbs/spfiledup.ora

断开连接

SQL> exit Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

这里一定要断开启动辅助实例的会话否则在执行复制操作时会出现如下错误 ：

executing Memory Script  RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of Duplicate Db command at 03/24/2015 18:28:32 RMAN-03015: error occurred in stored script Memory Script RMAN-06136: ORACLE error from auxiliary database: ORA-01013: user requested cancel of current operation

5.加载或打开目标数据库

[oracle@oracle11g ~]$ export ORACLE_SID=test [oracle@oracle11g ~]$ sqlplus / as sysdba  SQL*Plus: Release 10.2.0.5.0 - Production on Thu Mar 26 08:49:51 2015  Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.  Connected to an idle instance.  SQL> startup ORACLE instance started.  Total System Global Area  167772160 bytes Fixed Size                  1272600 bytes Variable Size              92275944 bytes Database Buffers           71303168 bytes Redo Buffers                2920448 bytes Database mounted. Database opened.

6.确保有需要的备份和归档重做日志,对目标数据库（被复制的数据库）进行备份（包含数据文件和归档重做日志）

[oracle@oracle11g admin]$ export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss' [oracle@oracle11g admin]$ rman target sys/zzh_2046@test catalog rman/rman@jy Recovery Manager: Release 10.2.0.5.0 - Production on Tue Mar 24 15:15:52 2015 Copyright (c) 1982, 2007, Oracle.  All rights reserved. connected to target database: TEST (DBID=2168949517) connected to recovery catalog database RMAN> backup as backupset database plus archivelog delete all input; Starting backup at 25-MAR-15 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=65 recid=72 stamp=875262973 input archive log thread=1 sequence=66 recid=73 stamp=875266238 channel ORA_DISK_1: starting piece 1 at 25-MAR-15 channel ORA_DISK_1: finished piece 1 at 25-MAR-15 piece handle=/u02/ora_test875266246_751 tag=TAG20150325T093040 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04 channel ORA_DISK_1: deleting archive log(s) archive log filename=/u02/1_65_870806981.dbf recid=72 stamp=875262973 archive log filename=/u02/1_66_870806981.dbf recid=73 stamp=875266238 Finished backup at 25-MAR-15 Starting backup at 25-MAR-15 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backupset channel ORA_DISK_1: specifying datafile(s) in backupset input datafile fno=00001 name=/u01/app/oracle/oradata/test/system01.dbf input datafile fno=00003 name=/u01/app/oracle/oradata/test/sysaux01.dbf input datafile fno=00005 name=/u01/app/oracle/oradata/test/example01.dbf input datafile fno=00006 name=/u01/app/oracle/oradata/test/tspitr01.dbf input datafile fno=00002 name=/u01/app/oracle/oradata/test/undotbs01.dbf input datafile fno=00004 name=/u01/app/oracle/oradata/test/users01.dbf channel ORA_DISK_1: starting piece 1 at 25-MAR-15 channel ORA_DISK_1: finished piece 1 at 25-MAR-15 piece handle=/u02/ora_test875266253_761 tag=TAG20150325T093052 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:02:46 Finished backup at 25-MAR-15 Starting backup at 25-MAR-15 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archive log backupset channel ORA_DISK_1: specifying archive log(s) in backup set input archive log thread=1 sequence=67 recid=74 stamp=875266422 channel ORA_DISK_1: starting piece 1 at 25-MAR-15 channel ORA_DISK_1: finished piece 1 at 25-MAR-15 piece handle=/u02/ora_test875266425_771 tag=TAG20150325T093344 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02 channel ORA_DISK_1: deleting archive log(s) archive log filename=/u02/1_67_870806981.dbf recid=74 stamp=875266422 Finished backup at 25-MAR-15 Starting Control File and SPFILE Autobackup at 25-MAR-15 piece handle=/u01/app/oracle/flash_recovery_area/TEST/autobackup/2015_03_25/o1_mf_s_875266428_bk4441pd_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 25-MAR-15 RMAN> list backup; List of Backup Sets =================== BS Key  Size       Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 4782    5.72M      DISK 00:00:04     25-MAR-15  BP Key: 4783   Status: AVAILABLE  Compressed: NO  Tag: TAG20150325T093040  Piece Name: /u02/ora_test875266246_751   List of Archived Logs in backup set 4782   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time   ---- ------- ---------- --------- ---------- ---------   1    65      1009334    24-MAR-15 1038362    25-MAR-15   1    66      1038362    25-MAR-15 1040219    25-MAR-15 BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 4794    Full    624.76M    DISK 00:02:40     25-MAR-15  BP Key: 4797   Status: AVAILABLE  Compressed: NO  Tag: TAG20150325T093052  Piece Name: /u02/ora_test875266253_761   List of Datafiles in backup set 4794   File LV Type Ckp SCN    Ckp Time  Name   ---- -- ---- ---------- --------- ----   1       Full 1040242    25-MAR-15 /u01/app/oracle/oradata/test/system01.dbf   2       Full 1040242    25-MAR-15 /u01/app/oracle/oradata/test/undotbs01.dbf   3       Full 1040242    25-MAR-15 /u01/app/oracle/oradata/test/sysaux01.dbf   4       Full 1040242    25-MAR-15 /u01/app/oracle/oradata/test/users01.dbf   5       Full 1040242    25-MAR-15 /u01/app/oracle/oradata/test/example01.dbf   6       Full 1040242    25-MAR-15 /u01/app/oracle/oradata/test/tspitr01.dbf BS Key  Size       Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 4811    12.50K     DISK 00:00:01     25-MAR-15  BP Key: 4818   Status: AVAILABLE  Compressed: NO  Tag: TAG20150325T093344  Piece Name: /u02/ora_test875266425_771   List of Archived Logs in backup set 4811   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time   ---- ------- ---------- --------- ---------- ---------   1    67      1040219    25-MAR-15 1040304    25-MAR-15 BS Key  Type LV Size       Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 4827    Full    6.89M      DISK 00:00:06     25-MAR-15  BP Key: 4829   Status: AVAILABLE  Compressed: NO  Tag: TAG20150325T093348  Piece Name: /u01/app/oracle/flash_recovery_area/TEST/autobackup/2015_03_25/o1_mf_s_875266428_bk4441pd_.bkp   Control File Included: Ckp SCN: 1040326      Ckp time: 25-MAR-15   SPFILE Included: Modification time: 25-MAR-15 

将上面的备份传输到远程主机的相同目录中：

[oracle@jingyong1 dup]$ scp -r oracle@192.168.56.2:/u02/ora_test875266246_751 /u02 oracle@192.168.56.2's password: ora_test875266246_751                                                                                                                100% 5857KB   5.7MB/s   00:00 [oracle@jingyong1 dup]$ scp -r oracle@192.168.56.2:/u02/ora_test875266253_761 /u02 oracle@192.168.56.2's password: ora_test875266253_761                                                                                                                100%  625MB   8.1MB/s   01:17 [oracle@jingyong1 dup]$ scp -r oracle@192.168.56.2:/u02/ora_test875266425_771 /u02 oracle@192.168.56.2's password: ora_test875266425_771                                                                                                                100%   13KB  13.0KB/s   00:00 [oracle@jingyong1 dup]$ scp -r oracle@192.168.56.2:/u01/app/oracle/flash_recovery_area/TEST/autobackup/2015_03_25/o1_mf_s_875266428_bk4441pd_.bkp /u01/app/oracle/flash_recovery_area/TEST/autobackup/2015-03-25 oracle@192.168.56.2's password: o1_mf_s_875266428_bk4441pd_.bkp

7.执行duplicate命令，如果没有配置自动通道，那么至少手动分配一个辅助实例如果是使用PFILE参数文件启动辅助实例需要指定pfile参数文件，且pfile参数文件必须存储在运行RMAN执行复制的主机上。这里辅助实例使用SPFILE参数文件来启动，并使用自动通道:

[oracle@oracle11g admin]$ export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss' [oracle@oracle11g admin]$ rman target sys/zzh_2046@test auxiliary sys/oracle@dup catalog rman/rman@jy  Recovery Manager: Release 10.2.0.5.0 - Production on Thu Mar 26 09:22:10 2015  Copyright (c) 1982, 2007, Oracle.  All rights reserved.  connected to target database: TEST (DBID=2168949517) connected to recovery catalog database connected to auxiliary database: DUP (not mounted)  RMAN> duplicate target database to dup until time "to_date('2015-03-26 09:00:00','yyyy-mm-dd hh24:mi:ss')";  Starting Duplicate Db at 2015-03-26 09:22:55 allocated channel: ORA_AUX_DISK_1 channel ORA_AUX_DISK_1: sid=37 devtype=DISK  contents of Memory Script: {    set until scn  1125870;    set newname for datafile  1 to  "/u01/app/oracle/oradata/dup/system01.dbf";    set newname for datafile  2 to  "/u01/app/oracle/oradata/dup/undotbs01.dbf";    set newname for datafile  3 to  "/u01/app/oracle/oradata/dup/sysaux01.dbf";    set newname for datafile  4 to  "/u01/app/oracle/oradata/dup/users01.dbf";    set newname for datafile  5 to  "/u01/app/oracle/oradata/dup/example01.dbf";    set newname for datafile  6 to  "/u01/app/oracle/oradata/dup/tspitr01.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  Starting restore at 2015-03-26 09:22:56 using channel ORA_AUX_DISK_1  channel ORA_AUX_DISK_1: starting datafile backupset restore channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set restoring datafile 00001 to /u01/app/oracle/oradata/dup/system01.dbf restoring datafile 00002 to /u01/app/oracle/oradata/dup/undotbs01.dbf restoring datafile 00003 to /u01/app/oracle/oradata/dup/sysaux01.dbf restoring datafile 00004 to /u01/app/oracle/oradata/dup/users01.dbf restoring datafile 00005 to /u01/app/oracle/oradata/dup/example01.dbf restoring datafile 00006 to /u01/app/oracle/oradata/dup/tspitr01.dbf channel ORA_AUX_DISK_1: reading from backup piece /u02/ora_test875266253_761 channel ORA_AUX_DISK_1: restored backup piece 1 piece handle=/u02/ora_test875266253_761 tag=TAG20150325T093052 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:16 Finished restore at 2015-03-26 09:24:14 sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DUP" RESETLOGS ARCHIVELOG   MAXLOGFILES     16   MAXLOGMEMBERS      3   MAXDATAFILES      100   MAXINSTANCES     8   MAXLOGHISTORY      292  LOGFILE   GROUP  1 ( '/u01/app/oracle/oradata/dup/redo01.log' ) SIZE 50 M  REUSE,   GROUP  2 ( '/u01/app/oracle/oradata/dup/redo02.log' ) SIZE 50 M  REUSE,   GROUP  3 ( '/u01/app/oracle/oradata/dup/redo03.log' ) SIZE 50 M  REUSE  DATAFILE   '/u01/app/oracle/oradata/dup/system01.dbf'  CHARACTER SET ZHS16GBK   contents of Memory Script: {    switch clone datafile all; } executing Memory Script  datafile 2 switched to datafile copy input datafile copy recid=1 stamp=875352256 filename=/u01/app/oracle/oradata/dup/undotbs01.dbf datafile 3 switched to datafile copy input datafile copy recid=2 stamp=875352256 filename=/u01/app/oracle/oradata/dup/sysaux01.dbf datafile 4 switched to datafile copy input datafile copy recid=3 stamp=875352256 filename=/u01/app/oracle/oradata/dup/users01.dbf datafile 5 switched to datafile copy input datafile copy recid=4 stamp=875352256 filename=/u01/app/oracle/oradata/dup/example01.dbf datafile 6 switched to datafile copy input datafile copy recid=5 stamp=875352256 filename=/u01/app/oracle/oradata/dup/tspitr01.dbf  contents of Memory Script: {    set until time  "to_date('2015-03-26 09:00:00','yyyy-mm-dd hh24:mi:ss')";    recover    clone database     delete archivelog    ; } executing Memory Script  executing command: SET until clause  Starting recover at 2015-03-26 09:24:15 using channel ORA_AUX_DISK_1  starting media recovery  channel ORA_AUX_DISK_1: starting archive log restore to default destination channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=67 channel ORA_AUX_DISK_1: reading from backup piece /u02/ora_test875266425_771 channel ORA_AUX_DISK_1: restored backup piece 1 piece handle=/u02/ora_test875266425_771 tag=TAG20150325T093344 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:02 archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_67_870806981.dbf thread=1 sequence=67 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_67_870806981.dbf recid=1 stamp=875352261 channel ORA_AUX_DISK_1: starting archive log restore to default destination channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=68 channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=69 channel ORA_AUX_DISK_1: reading from backup piece /u02/ora_test875292006_791 channel ORA_AUX_DISK_1: restored backup piece 1 piece handle=/u02/ora_test875292006_791 tag=TAG20150325T164005 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03 archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_68_870806981.dbf thread=1 sequence=68 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_68_870806981.dbf recid=3 stamp=875352263 archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_69_870806981.dbf thread=1 sequence=69 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_69_870806981.dbf recid=2 stamp=875352263 channel ORA_AUX_DISK_1: starting archive log restore to default destination channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=70 channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=71 channel ORA_AUX_DISK_1: reading from backup piece /u02/ora_test875308493_811 channel ORA_AUX_DISK_1: restored backup piece 1 piece handle=/u02/ora_test875308493_811 tag=TAG20150325T211453 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03 archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_70_870806981.dbf thread=1 sequence=70 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_70_870806981.dbf recid=4 stamp=875352274 archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_71_870806981.dbf thread=1 sequence=71 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_71_870806981.dbf recid=5 stamp=875352274 channel ORA_AUX_DISK_1: starting archive log restore to default destination channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=72 channel ORA_AUX_DISK_1: restoring archive log archive log thread=1 sequence=73 channel ORA_AUX_DISK_1: reading from backup piece /u02/ora_test875351407_831 channel ORA_AUX_DISK_1: restored backup piece 1 piece handle=/u02/ora_test875351407_831 tag=TAG20150326T091000 channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03 archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_72_870806981.dbf thread=1 sequence=72 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_72_870806981.dbf recid=7 stamp=875352285 archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_73_870806981.dbf thread=1 sequence=73 channel clone_default: deleting archive log(s) archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_73_870806981.dbf recid=6 stamp=875352283 media recovery complete, elapsed time: 00:00:14 Finished recover at 2015-03-26 09:24:59  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     167772160 bytes  Fixed Size                     1272624 bytes Variable Size                 58721488 bytes Database Buffers             104857600 bytes Redo Buffers                   2920448 bytes sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DUP" RESETLOGS ARCHIVELOG   MAXLOGFILES     16   MAXLOGMEMBERS      3   MAXDATAFILES      100   MAXINSTANCES     8   MAXLOGHISTORY      292  LOGFILE   GROUP  1 ( '/u01/app/oracle/oradata/dup/redo01.log' ) SIZE 50 M  REUSE,   GROUP  2 ( '/u01/app/oracle/oradata/dup/redo02.log' ) SIZE 50 M  REUSE,   GROUP  3 ( '/u01/app/oracle/oradata/dup/redo03.log' ) SIZE 50 M  REUSE  DATAFILE   '/u01/app/oracle/oradata/dup/system01.dbf'  CHARACTER SET ZHS16GBK   contents of Memory Script: {    set newname for tempfile  1 to  "/u01/app/oracle/oradata/dup/temp01.dbf";    switch clone tempfile all;    catalog clone datafilecopy  "/u01/app/oracle/oradata/dup/undotbs01.dbf";    catalog clone datafilecopy  "/u01/app/oracle/oradata/dup/sysaux01.dbf";    catalog clone datafilecopy  "/u01/app/oracle/oradata/dup/users01.dbf";    catalog clone datafilecopy  "/u01/app/oracle/oradata/dup/example01.dbf";    catalog clone datafilecopy  "/u01/app/oracle/oradata/dup/tspitr01.dbf";    switch clone datafile all; } executing Memory Script  executing command: SET NEWNAME  renamed temporary file 1 to /u01/app/oracle/oradata/dup/temp01.dbf in control file  cataloged datafile copy datafile copy filename=/u01/app/oracle/oradata/dup/undotbs01.dbf recid=1 stamp=875352312  cataloged datafile copy datafile copy filename=/u01/app/oracle/oradata/dup/sysaux01.dbf recid=2 stamp=875352312  cataloged datafile copy datafile copy filename=/u01/app/oracle/oradata/dup/users01.dbf recid=3 stamp=875352312  cataloged datafile copy datafile copy filename=/u01/app/oracle/oradata/dup/example01.dbf recid=4 stamp=875352312  cataloged datafile copy datafile copy filename=/u01/app/oracle/oradata/dup/tspitr01.dbf recid=5 stamp=875352312  datafile 2 switched to datafile copy input datafile copy recid=1 stamp=875352312 filename=/u01/app/oracle/oradata/dup/undotbs01.dbf datafile 3 switched to datafile copy input datafile copy recid=2 stamp=875352312 filename=/u01/app/oracle/oradata/dup/sysaux01.dbf datafile 4 switched to datafile copy input datafile copy recid=3 stamp=875352312 filename=/u01/app/oracle/oradata/dup/users01.dbf datafile 5 switched to datafile copy input datafile copy recid=4 stamp=875352312 filename=/u01/app/oracle/oradata/dup/example01.dbf datafile 6 switched to datafile copy input datafile copy recid=5 stamp=875352312 filename=/u01/app/oracle/oradata/dup/tspitr01.dbf  contents of Memory Script: {    Alter clone database open resetlogs; } executing Memory Script  database opened Finished Duplicate Db at 2015-03-26 09:25:43