使用不同的目录结构在远程主机上创建复制数据库
如果在远程主机上使用不同于目标数据库（被复制的数据库）的目录结构来创建复制数据库，那么为了在新的目录中为复制数据库的数据文件生成新的文件名必须修改一些参数。下面分别来介绍生成新文件名的各种方法。
只使用初始化参数来转换文件名
这种方法是只使用初始化方法来对复制数据库的数据文件和日志文件进行重命名。
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.创建辅助实例的参数文件
检查所有以_DEST结束的参数并且指定完整路径名。有一些可能需要修改。设置db_file_name_convert参数，RMAN就能捕获目标数据库的所有数据文件并将其转换成合适的文件名。设置log_file_name_convert参数，RMAN能捕获目标数据库的所有联机重做日志并将其转换成合适的文件名。db_file_name_convert和log_file_name_convert参数可以设置多个转换对。下面将目标数据库的数据文件和日志文件从/u01/app/oracle/oradata/test/目录转换到/u01/app/oracle/oradata/dup/目录中
[oracle@jingyong1 dbs]$ vi initdup.ora
db_name=dup
db_unique_name=dup
control_files= /u01/app/oracle/oradata/test/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 Tue Mar 24 21:13:44 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 /nolog
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Mar 24 21:13:44 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 21:13:44 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 21:13:44 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参数文件来启动，并使用自动通道:
[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 21:19:51 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;
Starting Duplicate Db at 2015-03-24 21:19:54
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=37 devtype=DISK
contents of Memory Script:
{
set until scn 1009334;
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-24 21:19:54
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_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:25
Finished restore at 2015-03-24 21:21:20
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=875222496 filename=/u01/app/oracle/oradata/dup/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=875222496 filename=/u01/app/oracle/oradata/dup/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=875222496 filename=/u01/app/oracle/oradata/dup/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=875222496 filename=/u01/app/oracle/oradata/dup/example01.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=875222496 filename=/u01/app/oracle/oradata/dup/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 21:21:24
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=875222496
media recovery complete, elapsed time: 00:00:03
Finished recover at 2015-03-24 21:21:30
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=875222510
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/dup/sysaux01.dbf recid=2 stamp=875222510
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/dup/users01.dbf recid=3 stamp=875222510
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/dup/example01.dbf recid=4 stamp=875222510
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/dup/tspitr01.dbf recid=5 stamp=875222510
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=875222510 filename=/u01/app/oracle/oradata/dup/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=875222510 filename=/u01/app/oracle/oradata/dup/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=875222510 filename=/u01/app/oracle/oradata/dup/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=875222510 filename=/u01/app/oracle/oradata/dup/example01.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=875222510 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-24 21:22:03
[oracle@jingyong1 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Tue Mar 24 21:22:52 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