当前位置：首页 -> 基础 -> 数据库编程

Oracle DUPLICATE复制数据库(五)

2014-11-24 09:26:05 · 作者: · 浏览: 1
标签: Oracle DUPLICATE 复制 数据库
l 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS2.DBF www.2cto.com
3 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX
4 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF
5 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF
6 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ORADATA1.DBF
7 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ORADATA2.DBF
8 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM02.DBF
9 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\MYIDX01.DBF
10 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS02.DBF
11 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ASM_LMT.DBF
12 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\PERFSTAT.DBF
13 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ORADATA3.DBF
14 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\STREAMS_TBS.DBF
15 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\ORCL\DATAFILE\O1_MF_USER123_81MTG1GN_.DBF
16 Full 9008324 08-AUG-12 F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\GGTBS.DBF
没有备份就没法恢复，而恢复时DUPLICATE的主要工作，如果没有，赶紧创建备份集思密达。
NOTE:如果创建duplicate数据库到其他服务器，那么必须将备份集和相关的归档文件复制到辅助实
例所在的服务器适当路径下，以保证RMAN在向DUPLICATE数据库恢复数据文件时，能够读取到备份集。 www.2cto.com
3.执行恢复
C:\>rman target sys/lyn@orcl catalog rman/rman@catalog auxiliary sys/lyn@orcldup
Recovery Manager: Release 10.2.0.3.0 - Production on Thu Aug 9 11:38:40 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: ORCL (DBID=1304585157)
connected to recovery catalog database
connected to auxiliary database: ORCLDUP (not mounted)
运行duplicate命令之前至少指定一个辅助通道，分配通道在RMAN的RUN块中指定，通过ALLOCATE
AUXILIARY CHANNEL命令，
RUN{
#手工分配通道类型为sbt(磁带);
allocate auxiliary channel ch1 device type sbt;
#手工分配通道类型为disk
allocate auxiliary channel aux1 device type disk;
allocate auxiliary channel aux2 device type disk;
allocate auxiliary channel aux3 device type disk;
....
DUPLICATE TARGET DATABASE TO ORCLDUP;
}
4.执行DUPLICATE命令
RMAN>DUPLICATE TARGET DATABASE TO ORCLDUP;
Starting Duplicate Db at 09-AUG-12
starting full resync of recovery catalog
full resync complete
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=36 devtype=DISK
contents of Memory Script:
{
set until scn 9085645;
set newname for datafile 1 to
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\SYSTEM01.DBF";
set newname for datafile 2 to
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\UNDOTBS2.DBF";
set newname for datafile 3 to www.2cto.com
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\SYSAUX01.DBF";
set newname for datafile 4 to
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\USERS01.DBF";
set newname for datafile 5 to
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\EXAMPLE01.DBF";
set newname for datafile 6 to
"F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLDUP\ORADATA1.DBF";
set newname for datafile 7 to
"F:\ORACLE\P