使用RMAN的duplicate命令使用目标数据库（主库）的备份来创建一个副本数据库同时保留原目标数据库副本数据库可以和目标数据库完全相同或者只包含目标数据库中一部分表空间。目标数据库和副本数据库可以是在单独的机器上，也可以是在相同的机器上。
副本数据库是目标数据库的副本可以用于各种目的。例如，可以用来:
.测试备份和恢复过程
.导出那些无意中从生产数据库中删除的表数据并重新导入到生产数据库中
例如，可以将主机host1上的生产数据库复制到主机host2上，并使用主机host2上的副本数据库来练习还原和恢复的同时主机host1上的生产数据库处于运行状态。
复制的副本数据库与备库是有差别的，虽然两种类型的数据库都是使用duplicate命令创建。备库是主库的一个副本可以使用主库的归档重做日志连续或定期地更新。如果主库被损坏或破坏，那么可以对备库执行故障转移将它转换为主库。复制的副本数据库是不能这样使用的，它不能执和故障转移并且不支持各种备库恢复和故障转移选项。
为了进行数据库复制，首先得创建一个辅助实例。为了执行复制，必须使用RMAN连接到目标数据库（主库）和一个启动到nomount状态的辅助实例。
在辅助实例上至少分配一个辅助通道。执行复制的主要工作就是通过辅助通道来完成的，在复制的副本主机上启动一个服务会话。这个辅助通道然后会还原所需要的主库备份，使用它们来创建一个副本数据库，并执行恢复。
只要RMAN可以连接到主数据库和辅助实例，RMAN客户端可以在任何主机上运行。所有用来创建和恢复复制的副本数据库的备份和归档重做日志都必须能被副本主机上的服务会话所访问。如果副本主机与目标主机相同，那么对一目标主机上的备份必须使用主数据库的完整路径名来让副本主机能使用。
当使用磁盘备份时，可以使用以下任意方式来完成这个任务：
.从主数据库主机上将备份手动传输到副本数据库主机上的相同目录下。例如，如果在主数据库主机上备份存储在/dsk1/bkp，那么将它们传输到副本数据库主机上的/dsk1/bkp中。
.从主数据库主机上将备份手动传输到副本数据库主机上的新目录下。例如，如果在主数据库主机上备份存储在/dsk1/bkp，然后将备份传输到副本数据库主机上的/dsk2/dup中。在这里新路径 /dsk2/dup必须在目标主机和副本主机上都能访问。执行catalog命令将这些备份副本登记在副本数据库主机上的RMAN档案库中。
.使用NFS或共享磁盘并确保在副本数据库主机上有相同的路径。例如，NFS的挂载点在所有主机上都是/home/file_server
当使用磁带备份时，必须让存储备份的磁带能让副本数据库主机所访问。通过物理移动磁带上的备份到副本数据库主机所附加的设备上或者通过网络访问磁带服务
作为复制操作的一部分，RMAN自动执行以下步骤：
.为复制的副本数据库创建控制文件
.通过使用所有可用的增量备份和归档重做日志来对副本数据库还原目标数据文件并执行不完全恢复
.重启辅助实例.
.在不完全恢复后使用resetlogs选项来打开数据库并创建联机重做日志（当运行在duplicate … for standby之下时RMAN不会打开数据库)
在执行复制时，RMAN必须执行不完全恢复因为目标数据库的联机重做日志没有被备份并且不能应用到复制的副本数据库。RMAN可以将副本数据库恢复到目标数据库最后归档重做日志所对应的时间点。
当复制数据库时可以执行以下选项:
.可以使用也可以不使用恢复目录来执行duplicate命令
.使用skip readonly子句跳过只读表空间，缺省情况下包含只读表空间。
.使用skip tablespace子句来排除表空间。可以排除system表空间或包含回滚或undo段的表空间之外的任何表空间。
.可以在新主机上创建副本数据库。如果新主机的目录结构与目标主机相同，那么指定nofilenamecheck选项并对复制的数据文件使用目标数据库数据文件名。
.可以将存储在传统文件系统上的目标数据库复制到ASM或OMF中
.缺省情况下，duplicate命令将使用目标数据库的最近备份来创建副本数据库并恢复到归档日志文件所对应的一致性时间点。通过使用set until命令的RUN块或通过有until子句的duplicate命令来让RMAN将复制的副本数据库恢复到当前数据库化身的过去某个时间点。（然而不能使用duplicate命令将复制的副本数据库恢复到目标数据库之前化身的过去某个时间点）
.在相同恢复目录中可以像目标数据库一样来注意复制的副本数据库。因为RMAN给复制的副本数据库生成了新的DBID。注意：如果使用操作系统工具复制目标数据库，那么复制生成的副本数据库的DBID与目标数据库一样。为了在相同的恢复目录中注册副本数据库必须使用DBNEWID工具来改变副本数据库的DBID。
.在有些情况下，可以设置复制的副本数据库的DB_NAME不同于目标数据库的DB_NAME。具体来说，如果在目标数据库相同的Oracle Home目录中复制一个数据库时，那么DB_NAME参数必须不同。如果在与目标数据库不同的Oracle Home目录中复制一个数据库，那么DB_NAME参数在它的Oracle Home中必须是唯一的。
重命名RMAN复制数据库的数据库文件
在复制一个数据库时，RMAN会对数据库文件生成文件名，其中包括控制文件，联机重做日志文件，数据文件和临时文件。
重命名复制数据库的控制文件
确定复制数据库控制文件名称的优先级规则与create controlfile语句使用的一样。当给复制数据库的控制文件选择名称时，确保对辅助数据库设置了正确的参数，否则，可能会覆盖目标数据库的控制文件。
重命名复制数据库的联机重做日志文件
RMAN需要为复制生成的数据库使用新的联机重做日志文件名。可以在duplicate命令中显式指定，也可以让RMAN根据下面的规则来生成。
表1-1 生成联机重做日志文件名的优先级规则
-------------------------------------------------------------------------------------------
优先级 方法 结果
-------------------------------------------------------------------------------------------
1 在duplicate命令中指定logfile子句 根据指定条件生成联机重做日志文件
2 设置log_file_name_convert参数 转换目标文件名，例如从log_*转换为duplog_*
注意可以指定多个转换对
3 设置一个OMF参数db_create_file_dest, 基于设置的参数来转换目标文件名。这些参数
db_create_online_dest_n或者 的优先级与alter database add logfile语句
db_recovery_file_dest 一样
4 没有执行前面的设置 复制数据库的文件名与目标数据库的文件名相
同。当使用这种方法时必须指定
nofilenamecheck选项，并且要将数据库复制到
不同的主机上这样联机重做日志文件才不会与
目标数据库的联机重做日志文件冲突
-------------------------------------------------------------------------------------------
优先级规则中优先级高的会覆盖优先级低的。例如，如果指定了logfile子句和log_file_name_convert参数，那么RMAN将会使用logfile子句。如果目标数据库和复制的数据库在相同主机上，那么不要对复制的数据库使用与目标数据库相同名称的联机重做日志。如果复制的数据库与目标数据库在不同主机上，但没有使用nofilenamecheck选项，那么不要对复制的数据库使用与目标数据库相同名称的联机重做日志
重命名RMAN复制数据库的数据文件名
有几种方法用来指定复制数据库的数据文件名。按优先级依次为:
1.在RUN块中使用set newname for datafile命令，包含set newname与duplicate命令。
2.对已经存在的数据文件使用configure auxname来指定新名称。在duplicate命令之前执行configure auxname命令。
3.在duplicate命令中指定db_file_name_convert参数来为没有使用set newname或configure auxname进行重命名的任何数据文件指定文件名转换的规则。在目标实例使用OMF时有db_file_name_convert子句的duplicate命令不能对复制的副本实例生成新的文件名。
4.设置db_file_name_convert参数。在目标实例使用OMF时db_file_name_convert参数不能对复制的副本实例生成新的文件名。它的语法与duplicate命令中的db_file_name_convert参数一样。
5.设置db_create_file_dest参数在指定目录中生成OMF的数据文件
如果没有使用上面的任何规则选项，那么复制的数据库将重用目标数据库的数据文件目录。
阻止对复制数据库的文件名检查
如果可能使用configure auxname,set newname或db_file_name_convert来生成复制的副本数据库文件名在这种情况下，在duplicate命令中指定nofilenamecheck选项可以避免出错。
例如，假设主机A上数据库有两个文件:数据文件1被命名为/oracle/data/file1.f，数据文件2被命名为/oracle/data/file2.f。当将数据库复制到主机B上时，使用配置的通道进行复制：
RUN
{
SET NEWNAME FOR DATAFILE 1 TO /oracle/data/file2.f; # rename df 1 as file2.f
SET NEWNAME FOR DATAFILE 2 TO /oracle/data/file1.f; # rename df 2 as file1.f
DUPLICATE TARGET DATABASE TO newdb;
}
即使你对所有数据文件执行set newname命令，因为复制的文件名仍然会使用目标数据库的数据文件名所以duplicate命令会失败。虽然数据文件1在目标数据库中没有使用/oracle/data/file2.f并且数据文件2在目标数据库中没有使用/oracle/data/file1.f，目标数据库名被另一个复制的数据文件所使用。因此必须指定duplicate … nofilenamecheck来避免错误。
重命名RMAN复制数据库的临时文件
作为复制一个数据库的一部分RMAN会重新创建临时表空间。有几种方法来为复制数据库的临时文件指定目录。按优先级别依次为：
1.在RUN块中使用set newname for tempfile命令这样同时使用set newname和duplicate命令。
2.在duplicate命令中使用db_file_name_convert子句来为没有使用set newname或configure auxname进行重命名的临时文件指定转换规则。当目标实例使用了OMF,db_file_name_convert子句不能用来生成复制数据库的文件名。
3.设置db_file_name_convert参数。db_file_name_convert参数与duplicate命令中的
db_file_name_convert参数有相同的语法和限制
4.设置db_create_file_dest参数来创建OMF的临时文件
RMAN复制数据库时跳过指定表空间
不总是需要复制数据库中的所有表空间。例如，可能只需要从目标数据库中复制一组表空间来生成报告。RMAN的duplicate database可以跳过只读表空间或者当前offline normal的表空间。
复制数据库时跳过只读取表空间
当指定skip readonly时，RMAN不会复制只读表空间的数据文件。在复制完成后，可以查询复制的副本数据库中的视图来判断那些数据文件被跳过。status和enabled列描述了复制数据文件的当前状态。
使用相同目录结构在远程主机上创建复制数据库
在不同主机上复制数据库的最简单情况就是使用相同目录结构。在这种情况下不需要改变初始化参数文件或者不需要为复制的数据文件设置新的文件名。
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 -rw-r----- 1 oracle oinstall 2560 Mar 24 14:47 orapwdup
2.创建辅助实例网络连接
修改监听文件，使用静态监听来监听辅助实例
[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@jingyong1 admin]$ export ORACLE_SID=dup [oracle@jingyong1 admin]$ sqlplus /nolog SQL*Plus: Release 10.2.0.5.0 - Production on Tue Mar 24 14:57:08 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/test/control01.ctl 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 /nolog SQL*Plus: Release 10.2.0.5.0 - Production on Tue Mar 24 15:05:51 2015 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. SQL> conn sys/oracle@dup as sysdba 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 /nolog
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Mar 24 15:05:51 2015
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> conn sys/oracle@dup as sysdba
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> 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
在目标主机(运行被复制数据库的主机）配置辅助实例的网络服务名
[oracle@oracle11g admin]$ vi tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/10.2.0/db/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
JY =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = jy)
)
)
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)
dup =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.56.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =dup)
(UR=A)
)
)
[oracle@oracle11g admin]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Mar 24 15:49:11 2015
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> conn sys/oracle@dup as sysdba
Connected.
5.加载或打开目标数据库
[oracle@oracle11g ~]$ sqlplus /nolog SQL*Plus: Release 10.2.0.5.0 - Production on Tue Mar 24 08:48:03 2015 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. SQL> conn / as sysdba 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 2015-03-24 15:18:57
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=49 recid=56 stamp=874583978
input archive log thread=1 sequence=50 recid=57 stamp=874583996
input archive log thread=1 sequence=51 recid=58 stamp=874585387
input archive log thread=1 sequence=52 recid=59 stamp=874587721
input archive log thread=1 sequence=53 recid=60 stamp=874588386
input archive log thread=1 sequence=54 recid=61 stamp=874657003
input archive log thread=1 sequence=55 recid=62 stamp=874667860
input archive log thread=1 sequence=56 recid=63 stamp=874667943
input archive log thread=1 sequence=57 recid=64 stamp=874668125
input archive log thread=1 sequence=58 recid=65 stamp=874668205
input archive log thread=1 sequence=59 recid=66 stamp=874841642
input archive log thread=1 sequence=60 recid=67 stamp=874842111
input archive log thread=1 sequence=61 recid=68 stamp=875091192
input archive log thread=1 sequence=62 recid=69 stamp=875177310
input archive log thread=1 sequence=63 recid=70 stamp=875200740
channel ORA_DISK_1: starting piece 1 at 2015-03-24 15:19:03
channel ORA_DISK_1: finished piece 1 at 2015-03-24 15:19:19
piece handle=/u02/ora_test875200742_711 tag=TAG20150324T151901 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:17
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u02/1_49_870806981.dbf recid=56 stamp=874583978
archive log filename=/u02/1_50_870806981.dbf recid=57 stamp=874583996
archive log filename=/u02/1_51_870806981.dbf recid=58 stamp=874585387
archive log filename=/u02/1_52_870806981.dbf recid=59 stamp=874587721
archive log filename=/u02/1_53_870806981.dbf recid=60 stamp=874588386
archive log filename=/u02/1_54_870806981.dbf recid=61 stamp=874657003
archive log filename=/u02/1_55_870806981.dbf recid=62 stamp=874667860
archive log filename=/u02/1_56_870806981.dbf recid=63 stamp=874667943
archive log filename=/u02/1_57_870806981.dbf recid=64 stamp=874668125
archive log filename=/u02/1_58_870806981.dbf recid=65 stamp=874668205
archive log filename=/u02/1_59_870806981.dbf recid=66 stamp=874841642
archive log filename=/u02/1_60_870806981.dbf recid=67 stamp=874842111
archive log filename=/u02/1_61_870806981.dbf recid=68 stamp=875091192
archive log filename=/u02/1_62_870806981.dbf recid=69 stamp=875177310
archive log filename=/u02/1_63_870806981.dbf recid=70 stamp=875200740
Finished backup at 2015-03-24 15:19:20
Starting backup at 2015-03-24 15:19:20
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 2015-03-24 15:19:21
channel ORA_DISK_1: finished piece 1 at 2015-03-24 15:20:46
piece handle=/u02/ora_test875200761_721 tag=TAG20150324T151920 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
Finished backup at 2015-03-24 15:20:46
Starting backup at 2015-03-24 15:20:47
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=64 recid=71 stamp=875200847
channel ORA_DISK_1: starting piece 1 at 2015-03-24 15:20:49
channel ORA_DISK_1: finished piece 1 at 2015-03-24 15:20:50
piece handle=/u02/ora_test875200848_731 tag=TAG20150324T152048 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_64_870806981.dbf recid=71 stamp=875200847
Finished backup at 2015-03-24 15:20:50
Starting Control File and SPFILE Autobackup at 2015-03-24 15:20:50
piece handle=/u01/app/oracle/flash_recovery_area/TEST/autobackup/2015_03_24/o1_mf_s_875200851_bk242now_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2015-03-24 15:20:55
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
4452 61.69M DISK 00:00:15 2015-03-24 15:19:17
BP Key: 4453 Status: AVAILABLE Compressed: NO Tag: TAG20150324T151901
Piece Name: /u02/ora_test875200742_711
List of Archived Logs in backup set 4452
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 49 833130 2015-03-17 11:59:13 833176 2015-03-17 11:59:38
1 50 833176 2015-03-17 11:59:38 833183 2015-03-17 11:59:56
1 51 833183 2015-03-17 11:59:56 834037 2015-03-17 12:23:07
1 52 834037 2015-03-17 12:23:07 835281 2015-03-17 13:02:01
1 53 835281 2015-03-17 13:02:01 835767 2015-03-17 13:13:06
1 54 835767 2015-03-17 13:13:06 867877 2015-03-18 08:16:39
1 55 867877 2015-03-18 08:16:39 873825 2015-03-18 11:17:38
1 56 873825 2015-03-18 11:17:38 873875 2015-03-18 11:19:03
1 57 873875 2015-03-18 11:19:03 873988 2015-03-18 11:22:05
1 58 873988 2015-03-18 11:22:05 874075 2015-03-18 11:23:25
1 59 874075 2015-03-18 11:23:25 907518 2015-03-20 11:33:59
1 60 907518 2015-03-20 11:33:59 928331 2015-03-20 11:41:50
1 61 928331 2015-03-20 11:41:50 960300 2015-03-23 08:53:08
1 62 960300 2015-03-23 08:53:08 998814 2015-03-24 08:48:24
1 63 998814 2015-03-24 08:48:24 1009277 2015-03-24 15:18:57
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4479 Full 624.66M DISK 00:01:24 2015-03-24 15:20:45
BP Key: 4495 Status: AVAILABLE Compressed: NO Tag: TAG20150324T151920
Piece Name: /u02/ora_test875200761_721
List of Datafiles in backup set 4479
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 1009303 2015-03-24 15:19:21 /u01/app/oracle/oradata/test/system01.dbf
2 Full 1009303 2015-03-24 15:19:21 /u01/app/oracle/oradata/test/undotbs01.dbf
3 Full 1009303 2015-03-24 15:19:21 /u01/app/oracle/oradata/test/sysaux01.dbf
4 Full 1009303 2015-03-24 15:19:21 /u01/app/oracle/oradata/test/users01.dbf
5 Full 1009303 2015-03-24 15:19:21 /u01/app/oracle/oradata/test/example01.dbf
6 Full 1009303 2015-03-24 15:19:21 /u01/app/oracle/oradata/test/tspitr01.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
4511 3.00K DISK 00:00:01 2015-03-24 15:20:49
BP Key: 4518 Status: AVAILABLE Compressed: NO Tag: TAG20150324T152048
Piece Name: /u02/ora_test875200848_731
List of Archived Logs in backup set 4511
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 64 1009277 2015-03-24 15:18:57 1009334 2015-03-24 15:20:47
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4529 Full 6.89M DISK 00:00:02 2015-03-24 15:20:53
BP Key: 4531 Status: AVAILABLE Compressed: NO Tag: TAG20150324T152051
Piece Name: /u01/app/oracle/flash_recovery_area/TEST/autobackup/2015_03_24/o1_mf_s_875200851_bk242now_.bkp
Control File Included: Ckp SCN: 1009356 Ckp time: 2015-03-24 15:20:51
SPFILE Included: Modification time: 2015-03-24 08:48:23
将上面的备份传输到远程主机的相同目录中：
[oracle@jingyong1 u02]$ scp -r oracle@192.168.56.2:/u02/ora_test875200742_711 /u02 The authenticity of host '192.168.56.2 (192.168.56.2)' can't be established. RSA key fingerprint is fb:1d:33:a6:9e:25:86:6a:a0:44:76:d4:cf:eb:c9:c4. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '192.168.56.2' (RSA) to the list of known hosts. oracle@192.168.56.2's password: ora_test875200742_711 100% 62MB 10.3MB/s 00:06 [oracle@jingyong1 u02]$ scp -r oracle@192.168.56.2:/u02/ora_test875200761_721 /u02 oracle@192.168.56.2's password: ora_test875200761_721 100% 625MB 7.7MB/s 01:21 [oracle@jingyong1 u02]$ scp -r oracle@192.168.56.2:/u02/ora_test875200848_731 /u02 oracle@192.168.56.2's password: ora_test875200848_731 100% 3584 3.5KB/s 00:00 [oracle@jingyong1 u02]$ scp -r oracle@192.168.56.2:/u01/app/oracle/flash_recovery_area/TEST/autobackup/2015_03_24/o1_mf_s_875200851_bk242now_.bkp /u01/app/oracle/flash_recovery_area/TEST/autobackup/2015_03_24/ oracle@192.168.56.2's password: o1_mf_s_875200851_bk242now_.bkp
7.执行duplicate命令，如果没有配置自动通道，那么至少手动分配一个辅助实例。给duplicate命令指定nofilenamecheck参数。如果是使用PFILE参数文件启动辅助实例需要指定pfile参数文件，且pfile参数文件必须存储在运行RMAN执行复制的主机上。这里辅助实例使用SPFILE参数文件来启动，并使用自动通道和指定nofilenamecheck选项:
[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 Tue Mar 24 19:19:31 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 nofilenamecheck;
Starting Duplicate Db at 2015-03-24 19:19:46
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=35 devtype=DISK
contents of Memory Script:
{
set until scn 1009334;
set newname for datafile 1 to
"/u01/app/oracle/oradata/test/system01.dbf";
set newname for datafile 2 to
"/u01/app/oracle/oradata/test/undotbs01.dbf";
set newname for datafile 3 to
"/u01/app/oracle/oradata/test/sysaux01.dbf";
set newname for datafile 4 to
"/u01/app/oracle/oradata/test/users01.dbf";
set newname for datafile 5 to
"/u01/app/oracle/oradata/test/example01.dbf";
set newname for datafile 6 to
"/u01/app/oracle/oradata/test/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-24 19:19:46
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/test/system01.dbf
restoring datafile 00002 to /u01/app/oracle/oradata/test/undotbs01.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/test/sysaux01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/test/users01.dbf
restoring datafile 00005 to /u01/app/oracle/oradata/test/example01.dbf
restoring datafile 00006 to /u01/app/oracle/oradata/test/tspitr01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u02/ora_test875200761_721
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/u02/ora_test875200761_721 tag=TAG20150324T151920
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:05
Finished restore at 2015-03-24 19:20:52
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/test/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/u01/app/oracle/oradata/test/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/u01/app/oracle/oradata/test/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/u01/app/oracle/oradata/test/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=875215264 filename=/u01/app/oracle/oradata/test/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=875215264 filename=/u01/app/oracle/oradata/test/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=875215264 filename=/u01/app/oracle/oradata/test/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=875215264 filename=/u01/app/oracle/oradata/test/example01.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=875215264 filename=/u01/app/oracle/oradata/test/tspitr01.dbf
contents of Memory Script:
{
set until scn 1009334;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 2015-03-24 19:20:53
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=64
channel ORA_AUX_DISK_1: reading from backup piece /u02/ora_test875200848_731
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/u02/ora_test875200848_731 tag=TAG20150324T152048
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_64_870806981.dbf thread=1 sequence=64
channel clone_default: deleting archive log(s)
archive log filename=/u01/app/oracle/product/10.2.0/db/dbs/arch1_64_870806981.dbf recid=1 stamp=875215263
media recovery complete, elapsed time: 00:00:01
Finished recover at 2015-03-24 19:20:57
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/test/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/u01/app/oracle/oradata/test/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/u01/app/oracle/oradata/test/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/u01/app/oracle/oradata/test/system01.dbf'
CHARACTER SET ZHS16GBK
contents of Memory Script:
{
set newname for tempfile 1 to
"/u01/app/oracle/oradata/test/temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/u01/app/oracle/oradata/test/undotbs01.dbf";
catalog clone datafilecopy "/u01/app/oracle/oradata/test/sysaux01.dbf";
catalog clone datafilecopy "/u01/app/oracle/oradata/test/users01.dbf";
catalog clone datafilecopy "/u01/app/oracle/oradata/test/example01.dbf";
catalog clone datafilecopy "/u01/app/oracle/oradata/test/tspitr01.dbf";
switch clone datafile all;
}
executing Memory Script
executing command: SET NEWNAME
renamed temporary file 1 to /u01/app/oracle/oradata/test/temp01.dbf in control file
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/test/undotbs01.dbf recid=1 stamp=875215374
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/test/sysaux01.dbf recid=2 stamp=875215374
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/test/users01.dbf recid=3 stamp=875215374
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/test/example01.dbf recid=4 stamp=875215374
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/test/tspitr01.dbf recid=5 stamp=875215374
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=875215374 filename=/u01/app/oracle/oradata/test/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=875215374 filename=/u01/app/oracle/oradata/test/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=875215374 filename=/u01/app/oracle/oradata/test/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=875215374 filename=/u01/app/oracle/oradata/test/example01.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=875215374 filename=/u01/app/oracle/oradata/test/tspitr01.dbf
contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script
database opened
Finished Duplicate Db at 2015-03-24 19:23:05
[oracle@jingyong1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Mar 24 19:26:06 2015
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
dup