使用PFILE参数文件执行duplicate
可以使用辅助实例的PFILE参数文件来执行duplicate命令，测试环境如下:
1.目标数据库test主机是oracle11g，复制数据库dup主机是jingyong1
2.PFILE参数文件/u01/app/oracle/product/10.2.0/db/dbs/initdup.ora存储在主机jingyong1上。
3.主机oracle11g与jingyong1通过网络连接
在这种情况下可以在主机oracle11g或jingyong1上执行duplicate命令.
在主机jingyong1上执行duplicate命令的执行步骤如下:
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@jingyong1 admin]$ vi tnsnames.ora
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.56.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =test)
(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.
目标主机
[oracle@jingyong1 admin]$ sqlplus /nolog SQL*Plus: Release 10.2.0.5.0 - Production on Thu Mar 26 10:20:56 2015 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. SQL> conn sys/zzh_2046@test as sysdba Connected.
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.
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 pfile='/u01/app/oracle/product/10.2.0/db/dbs/initdup.ora' 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
断开连接
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执行复制的主机上。这里辅助实例使用PFILE参数文件来启动，并使用自动通道:
[oracle@jingyong1 ~]$ export NLS_DATE_FORMATE='yyyy-mm-dd hh24:mi:ss'
[oracle@jingyong1 ~]$ 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 10:28:09 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 device type disk pfile='/u01/app/oracle/product/10.2.0/db/dbs/initdup.ora';
Starting Duplicate Db at 26-MAR-15
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=36 devtype=DISK
contents of Memory Script:
{
set until scn 1126817;
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 26-MAR-15
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:26
Finished restore at 26-MAR-15
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=875356263 filename=/u01/app/oracle/oradata/dup/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=875356263 filename=/u01/app/oracle/oradata/dup/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=875356263 filename=/u01/app/oracle/oradata/dup/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=875356263 filename=/u01/app/oracle/oradata/dup/example01.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=875356263 filename=/u01/app/oracle/oradata/dup/tspitr01.dbf
contents of Memory Script:
{
set until scn 1126817;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 26-MAR-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:01
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=875356267
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=875356270
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=875356270
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=875356282
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=875356283
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=875356293
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=875356292
media recovery complete, elapsed time: 00:00:16
Finished recover at 26-MAR-15
contents of Memory Script:
{
shutdown clone;
startup clone nomount pfile= '/u01/app/oracle/product/10.2.0/db/dbs/initdup.ora';
}
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=875356321
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/dup/sysaux01.dbf recid=2 stamp=875356321
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/dup/users01.dbf recid=3 stamp=875356321
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/dup/example01.dbf recid=4 stamp=875356322
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/dup/tspitr01.dbf recid=5 stamp=875356322
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=875356321 filename=/u01/app/oracle/oradata/dup/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=875356321 filename=/u01/app/oracle/oradata/dup/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=875356321 filename=/u01/app/oracle/oradata/dup/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=875356322 filename=/u01/app/oracle/oradata/dup/example01.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=875356322 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 26-MAR-15
在主机oracle11g上执行duplicate命令的执行步骤如下:
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@jingyong1 admin]$ vi tnsnames.ora
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =192.168.56.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =test)
(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.
目标主机
[oracle@oracle11g admin]$ sqlplus /nolog SQL*Plus: Release 10.2.0.5.0 - Production on Thu Mar 26 10:20:56 2015 Copyright (c) 1982, 2010, Oracle. All Rights Reserved. SQL> conn sys/zzh_2046@test as sysdba Connected.
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.
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 pfile='/u01/app/oracle/product/10.2.0/db/dbs/initdup.ora' 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
断开连接
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.将复制主机jingyong1上的参数文件目录/u01/app/oracle/product/10.2.0/db/dbs作为NFS挂载到目标主机oracle11g中的/jingyong1目录具体操作请参考http://blog.itpub.net/26015009/viewspace-1474224/
8.执行duplicate命令，如果没有配置自动通道，那么至少手动分配一个辅助实例如果是使用PFILE参数文件启动辅助实例需要指定pfile参数文件，且pfile参数文件必须存储在运行RMAN执行复制的主机上。这里辅助实例使用PFILE参数文件来启动，这里在主机oracle11g上执行RMAN命令，为了能让RMAN访问主机jingyong1上的辅助实例pfile参数文件使用NFS来引用pfile参数文件:
[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 11:32:46 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>
RMAN> duplicate target database to dup device type disk pfile='/jingyong1/initdup.ora';
Starting Duplicate Db at 2015-03-26 11:39:05
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=38 devtype=DISK
contents of Memory Script:
{
set until scn 1126817;
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 11:39:05
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:06
Finished restore at 2015-03-26 11:40:12
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=875360416 filename=/u01/app/oracle/oradata/dup/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=875360416 filename=/u01/app/oracle/oradata/dup/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=875360416 filename=/u01/app/oracle/oradata/dup/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=875360416 filename=/u01/app/oracle/oradata/dup/example01.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=875360416 filename=/u01/app/oracle/oradata/dup/tspitr01.dbf
contents of Memory Script:
{
set until scn 1126817;
recover
clone database
delete archivelog
;
}
executing Memory Script
executing command: SET until clause
Starting recover at 2015-03-26 11:40:14
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=875360419
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:01
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=875360422
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=875360421
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:07
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=875360434
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=875360435
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:02
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=875360449
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=875360448
media recovery complete, elapsed time: 00:00:14
Finished recover at 2015-03-26 11:41:01
contents of Memory Script:
{
shutdown clone;
startup clone nomount pfile= '/jingyong1/initdup.ora';
}
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=875360473
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/dup/sysaux01.dbf recid=2 stamp=875360473
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/dup/users01.dbf recid=3 stamp=875360473
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/dup/example01.dbf recid=4 stamp=875360473
cataloged datafile copy
datafile copy filename=/u01/app/oracle/oradata/dup/tspitr01.dbf recid=5 stamp=875360473
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=875360473 filename=/u01/app/oracle/oradata/dup/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=875360473 filename=/u01/app/oracle/oradata/dup/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=875360473 filename=/u01/app/oracle/oradata/dup/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=875360473 filename=/u01/app/oracle/oradata/dup/example01.dbf
datafile 6 switched to datafile copy
input datafile copy recid=5 stamp=875360473 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 11:41:33