利用现有环境创建一个DUPLICATE RAC环境。

由于篇幅限制，这篇描述DUPLICATE命令的执行。

恢复之RAC数据库DUPLICATE（一）：http://yangtingkun.itpub.net/post/468/471508

下面就可以执行DUPLICATE命令了：

bash-3.00$ rman target sys/test@172.0.2.54/rac11g.us.oracle.com catalog catalog_user/catalog_user@172.0.2.61/test11g.netdb auxiliary /

Recovery Manager: Release 11.1.0.6.0 - Production on Mon Sep 8 20:30:18 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

connected to target database: RAC11G (DBID=1712482917)
connected to recovery catalog database
connected to auxiliary database: RAC11GS (not mounted)

RMAN> duplicate target database to rac11gs
2> db_file_name_convert '/dev/vx/rdsk/datavg', '+DATA/RAC11G'
3> spfile
4> parameter_value_convert '/dev/vx/rdsk/datavg', '+DATA/RAC11G'
5> set log_file_name_convert '/dev/vx/rdsk/datavg', '+DATA/RAC11G'
6> set log_archive_dest_1='LOCATION=+DATA/RAC11G'
7> set local_listener = ''
8> set cluster_database = 'false'
9> ;

Starting Duplicate Db at 08-SEP-08
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=112 device type=DISK

contents of Memory Script:
{
set until scn 26685490;
restore clone spfile to '/data/oracle/product/11.1/database/dbs/spfilerac11g1.ora';
sql clone "alter system set spfile= ''/data/oracle/product/11.1/database/dbs/spfilerac11g1.ora''";
}
executing Memory Script

executing command: SET until clause

Starting restore at 08-SEP-08
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: restoring SPFILE
output file name=/data/oracle/product/11.1/database/dbs/spfilerac11g1.ora
channel ORA_AUX_DISK_1: reading from backup piece +DATA/backup/01jpk0bj_1_1
channel ORA_AUX_DISK_1: piece handle=+DATA/backup/01jpk0bj_1_1 tag=TAG20080902T204539
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 08-SEP-08

sql statement: alter system set spfile= ''/data/oracle/product/11.1/database/dbs/spfilerac11g1.ora''

contents of Memory Script:
{
sql clone "alter system set db_name =
''RAC11GS'' comment=
''duplicate'' scope=spfile";
sql clone "alter system set control_files =
''+DATA/RAC11G/rac11g_control_1'', ''+DATA/RAC11G/rac11g_control_2'', ''+DATA/RAC11G/rac11g_control_3'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''/dev/vx/rdsk/datavg'', ''+DATA/RAC11G'' comment=
'''' scope=spfile";
sql clone "alter system set log_archive_dest_1 =
''LOCATION=+DATA/RAC11G'' comment=
'''' scope=spfile";
sql clone "alter system set local_listener =
'''' comment=
'''' scope=spfile";
sql clone "alter system set cluster_database =
false comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount ;
}
executing Memory Script

sql statement: alter system set db_name = ''RAC11GS'' comment= ''duplicate'' scope=spfile

sql statement: alter system set control_files = ''+DATA/RAC11G/rac11g_control_1'', ''+DATA/RAC11G/rac11g_control_2'', ''+DATA/RAC11G/rac11g_control_3'' comment= '''' scope=spfile

sql statement: alter system set log_file_name_convert = ''/dev/vx/rdsk/datavg'', ''+DATA/RAC11G'' comment= '''' scope=spfile

sql statement: alter system set log_archive_dest_1 = ''LOCATION=+DATA/RAC11G'' comment= '''' scope=spfile

sql statement: alter system set local_listener = '''' comment= '''' scope=spfile

sql statement: alter system set cluster_database = false comment= '''' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 17108271104 bytes

Fixed Size 2101632 bytes
Variable Size 3747073664 bytes
Database Buffers 13354663936 bytes
Redo Buffers 4431872 bytes

contents of Memory Script:
{
set until scn 26685490;
set newname for datafile 1 to
"+DATA/rac11g/rac11g_system_1_1g";
set newname for datafile 2 to
"+DATA/rac11g/rac11g_sysaux_1_1g";
set newname for datafile 3 to
"+DATA/rac11g/rac11g_undotbs1_1_4g";
set newname for datafile 4 to
"+DATA/rac11g/rac11g_undotbs2_1_4g";
set newname for datafile 5 to
"+DATA/rac11g/rac11g_users_1_4g";
set newname for datafile 6 to
"+DATA/rac11g/rac11g_ndmain_1_32g";
set newname for datafile 7 to
"+DATA/rac11g/rac11g_ndmain_2_32g";
set newname for datafile 8 to
"+DATA/rac11g/rac11g_ndmain_3_32g";
set newname for datafile 9 to
"+DATA/rac11g/rac11g_ndmain_4_32g";
set newname for datafile 10 to
"+DATA/rac11g/rac11g_ndmain_5_32g";
set newname for datafile 11 to
"+DATA/rac11g/rac11g_ndmain_6_32g";
set newname for datafile 12 to
"+DATA/rac11g/rac11g_undotbs1_2_32g";
set newname for datafile 13 to
"+DATA/rac11g/rac11g_undotbs2_2_32g";
set newname for datafile 14 to
"+DATA/rac11g/rac11g_perfstat_1_8g";
restore
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

executing command: SET NEWNAME

executing command: SET NEWNAME

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 08-SEP-08
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=661 device type=DISK

skipping datafile 1; already restored to file +DATA/rac11g/rac11g_system_1_1g
skipping datafile 2; already restored to file +DATA/rac11g/rac11g_sysaux_1_1g
skipping datafile 3; already restored to file +DATA/rac11g/rac11g_undotbs1_1_4g
skipping datafile 4; already restored to file +DATA/rac11g/rac11g_undotbs2_1_4g
skipping datafile 5; already restored to file +DATA/rac11g/rac11g_users_1_4g
skipping datafile 6; already restored to file +DATA/rac11g/rac11g_ndmain_1_32g
skipping datafile 7; already restored to file +DATA/rac11g/rac11g_ndmain_2_32g
skipping datafile 8; already restored to file +DATA/rac11g/rac11g_ndmain_3_32g
skipping datafile 9; already restored to file +DATA/rac11g/rac11g_ndmain_4_32g
skipping datafile 10; already restored to file +DATA/rac11g/rac11g_ndmain_5_32g
skipping datafile 11; already restored to file +DATA/rac11g/rac11g_ndmain_6_32g
skipping datafile 12; already restored to file +DATA/rac11g/rac11g_undotbs1_2_32g
skipping datafile 13; already restored to file +DATA/rac11g/rac11g_undotbs2_2_32g
skipping datafile 14; already restored to file +DATA/rac11g/rac11g_perfstat_1_8g
restore not done; all files read only, offline, or already restored
Finished restore at 08-SEP-08
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "RAC11GS" RESETLOGS ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 1168
LOGFILE
GROUP 1 ( '+DATA/rac11g/rac11g_redo1_1_1_1g' ) SIZE 1 G REUSE,
GROUP 2 ( '+DATA/rac11g/rac11g_redo1_2_1_1g' ) SIZE 1 G REUSE
DATAFILE
'+DATA/rac11g/rac11g_system_1_1g'
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=664921865 file name=+DATA/rac11g/rac11g_sysaux_1_1g
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=664921865 file name=+DATA/rac11g/rac11g_undotbs1_1_4g
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=664921865 file name=+DATA/rac11g/rac11g_undotbs2_1_4g
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=664921865 file name=+DATA/rac11g/rac11g_users_1_4g
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=664921865 file name=+DATA/rac11g/rac11g_ndmain_1_32g
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=664921865 file name=+DATA/rac11g/rac11g_ndmain_2_32g
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=664921865 file name=+DATA/rac11g/rac11g_ndmain_3_32g
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=664921865 file name=+DATA/rac11g/rac11g_ndmain_4_32g
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=664921865 file name=+DATA/rac11g/rac11g_ndmain_5_32g
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=664921865 file name=+DATA/rac11g/rac11g_ndmain_6_32g
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=664921865 file name=+DATA/rac11g/rac11g_undotbs1_2_32g
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=664921865 file name=+DATA/rac11g/rac11g_undotbs2_2_32g
datafile 14 switched to datafile copy
input datafile copy RECID=13 STAMP=664921865 file name=+DATA/rac11g/rac11g_perfstat_1_8g

contents of Memory Script:
{
set until scn 26685490;
recover
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 08-SEP-08
using channel ORA_AUX_DISK_1

starting media recovery

archived log for thread 1 with sequence 528 is already on disk as file /data/oracle/oradata/rac11g/archivelog/1_528_660235173.dbf
archived log for thread 1 with sequence 529 is already on disk as file /data/oracle/oradata/rac11g/archivelog/1_529_660235173.dbf
archived log for thread 1 with sequence 530 is already on disk as file /data/oracle/oradata/rac11g/archivelog/1_530_660235173.dbf
archived log for thread 1 with sequence 531 is already on disk as file /data/oracle/oradata/rac11g/archivelog/1_531_660235173.dbf
archived log for thread 2 with sequence 193 is already on disk as file /data/oracle/oradata/rac11g/archivelog/2_193_660235173.dbf
archived log for thread 2 with sequence 194 is already on disk as file /data/oracle/oradata/rac11g/archivelog/2_194_660235173.dbf
archived log for thread 2 with sequence 195 is already on disk as file /data/oracle/oradata/rac11g/archivelog/2_195_660235173.dbf
archived log file name=/data/oracle/oradata/rac11g/archivelog/1_528_660235173.dbf thread=1 sequence=528
archived log file name=/data/oracle/oradata/rac11g/archivelog/2_193_660235173.dbf thread=2 sequence=0
archived log file name=/data/oracle/oradata/rac11g/archivelog/1_529_660235173.dbf thread=1 sequence=529
archived log file name=/data/oracle/oradata/rac11g/archivelog/2_194_660235173.dbf thread=2 sequence=194
archived log file name=/data/oracle/oradata/rac11g/archivelog/1_530_660235173.dbf thread=1 sequence=530
archived log file name=/data/oracle/oradata/rac11g/archivelog/1_531_660235173.dbf thread=1 sequence=531
archived log file name=/data/oracle/oradata/rac11g/archivelog/2_195_660235173.dbf thread=2 sequence=195
media recovery complete, elapsed time: 00:00:38
Finished recover at 08-SEP-08

contents of Memory Script:
{
shutdown clone immediate;
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 17108271104 bytes

Fixed Size 2101632 bytes
Variable Size 3747073664 bytes
Database Buffers 13354663936 bytes
Redo Buffers 4431872 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "RAC11GS" RESETLOGS ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES 1024
MAXINSTANCES 32
MAXLOGHISTORY 1168
LOGFILE
GROUP 1 ( '+DATA/rac11g/rac11g_redo1_1_1_1g' ) SIZE 1 G REUSE,
GROUP 2 ( '+DATA/rac11g/rac11g_redo1_2_1_1g' ) SIZE 1 G REUSE
DATAFILE
'+DATA/rac11g/rac11g_system_1_1g'
CHARACTER SET ZHS16GBK

sql statement: ALTER DATABASE ADD LOGFILE

INSTANCE 'i2'
GROUP 3 ( '+DATA/rac11g/rac11g_redo2_2_1_1g' ) SIZE 1 G REUSE,
GROUP 4 ( '+DATA/rac11g/rac11g_redo2_2_2_1g' ) SIZE 1 G REUSE

contents of Memory Script:
{
set newname for tempfile 1 to
"+DATA/rac11g/rac11g_temp_1_4g";
set newname for tempfile 2 to
"+DATA/rac11g/rac11g_temp_2_16g";
switch clone tempfile all;
catalog clone datafilecopy "+DATA/rac11g/rac11g_sysaux_1_1g";
catalog clone datafilecopy "+DATA/rac11g/rac11g_undotbs1_1_4g";
catalog clone datafilecopy "+DATA/rac11g/rac11g_undotbs2_1_4g";
catalog clone datafilecopy "+DATA/rac11g/rac11g_users_1_4g";
catalog clone datafilecopy "+DATA/rac11g/rac11g_ndmain_1_32g";
catalog clone datafilecopy "+DATA/rac11g/rac11g_ndmain_2_32g";
catalog clone datafilecopy "+DATA/rac11g/rac11g_ndmain_3_32g";
catalog clone datafilecopy "+DATA/rac11g/rac11g_ndmain_4_32g";
catalog clone datafilecopy "+DATA/rac11g/rac11g_ndmain_5_32g";
catalog clone datafilecopy "+DATA/rac11g/rac11g_ndmain_6_32g";
catalog clone datafilecopy "+DATA/rac11g/rac11g_undotbs1_2_32g";
catalog clone datafilecopy "+DATA/rac11g/rac11g_undotbs2_2_32g";
catalog clone datafilecopy "+DATA/rac11g/rac11g_perfstat_1_8g";
switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

renamed tempfile 1 to +DATA/rac11g/rac11g_temp_1_4g in control file
renamed tempfile 2 to +DATA/rac11g/rac11g_temp_2_16g in control file

cataloged datafile copy
datafile copy file name=+DATA/rac11g/rac11g_sysaux_1_1g RECID=1 STAMP=664921969

cataloged datafile copy
datafile copy file name=+DATA/rac11g/rac11g_undotbs1_1_4g RECID=2 STAMP=664921969

cataloged datafile copy
datafile copy file name=+DATA/rac11g/rac11g_undotbs2_1_4g RECID=3 STAMP=664921970

cataloged datafile copy
datafile copy file name=+DATA/rac11g/rac11g_users_1_4g RECID=4 STAMP=664921970

cataloged datafile copy
datafile copy file name=+DATA/rac11g/rac11g_ndmain_1_32g RECID=5 STAMP=664921970

cataloged datafile copy
datafile copy file name=+DATA/rac11g/rac11g_ndmain_2_32g RECID=6 STAMP=664921970

cataloged datafile copy
datafile copy file name=+DATA/rac11g/rac11g_ndmain_3_32g RECID=7 STAMP=664921970

cataloged datafile copy
datafile copy file name=+DATA/rac11g/rac11g_ndmain_4_32g RECID=8 STAMP=664921970

cataloged datafile copy
datafile copy file name=+DATA/rac11g/rac11g_ndmain_5_32g RECID=9 STAMP=664921970

cataloged datafile copy
datafile copy file name=+DATA/rac11g/rac11g_ndmain_6_32g RECID=10 STAMP=664921970

cataloged datafile copy
datafile copy file name=+DATA/rac11g/rac11g_undotbs1_2_32g RECID=11 STAMP=664921971

cataloged datafile copy
datafile copy file name=+DATA/rac11g/rac11g_undotbs2_2_32g RECID=12 STAMP=664921971

cataloged datafile copy
datafile copy file name=+DATA/rac11g/rac11g_perfstat_1_8g RECID=13 STAMP=664921971

datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=664921969 file name=+DATA/rac11g/rac11g_sysaux_1_1g
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=664921969 file name=+DATA/rac11g/rac11g_undotbs1_1_4g
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=664921970 file name=+DATA/rac11g/rac11g_undotbs2_1_4g
datafile 5 switched to datafile copy
input datafile copy RECID=4 STAMP=664921970 file name=+DATA/rac11g/rac11g_users_1_4g
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=664921970 file name=+DATA/rac11g/rac11g_ndmain_1_32g
datafile 7 switched to datafile copy
input datafile copy RECID=6 STAMP=664921970 file name=+DATA/rac11g/rac11g_ndmain_2_32g
datafile 8 switched to datafile copy
input datafile copy RECID=7 STAMP=664921970 file name=+DATA/rac11g/rac11g_ndmain_3_32g
datafile 9 switched to datafile copy
input datafile copy RECID=8 STAMP=664921970 file name=+DATA/rac11g/rac11g_ndmain_4_32g
datafile 10 switched to datafile copy
input datafile copy RECID=9 STAMP=664921970 file name=+DATA/rac11g/rac11g_ndmain_5_32g
datafile 11 switched to datafile copy
input datafile copy RECID=10 STAMP=664921970 file name=+DATA/rac11g/rac11g_ndmain_6_32g
datafile 12 switched to datafile copy
input datafile copy RECID=11 STAMP=664921971 file name=+DATA/rac11g/rac11g_undotbs1_2_32g
datafile 13 switched to datafile copy
input datafile copy RECID=12 STAMP=664921971 file name=+DATA/rac11g/rac11g_undotbs2_2_32g
datafile 14 switched to datafile copy
input datafile copy RECID=13 STAMP=664921971 file name=+DATA/rac11g/rac11g_perfstat_1_8g

contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 08-SEP-08

至此DUPLICATE操作成功执行。需要注意一下几点，可以修改一下初始化参数CLUSTER_DATABASE为TRUE，并启动实例2。

修改LOCAL_LISTENER，设置正确的IP地址。

修改spfile的位置，使得SPFILE存放到ASM中。

yangtingkun你好！我碰到下面的问题，麻烦请给点建议：

rman中delete backup后再备份，恢复出错
背景：要做data guard，源库是rac（两节点），目标库是单实例db，用rman初始化备库。

操作：用rman做了几次全库的备份操作，最后一次备份操作之前，在rman界面下用delete backup；delete copy删除了之前所有备份，看到backup目录下还有没有删除干净的文件，就手动rm *(估计问题就出在这里)。于是备份完毕之后恢复就出错了。

操作命令现场：（声明：backup database和duplicate target database都是在rac的其中一个节点Node3上做的）。
备份：
[oracle@node3 dbs]$ /u01/app/oracle/product/102/bin/rman target /
RMAN> run
2> {
3> allocate channel c1 device type disk format '/soft/backup/%U' connect sys/manager@rac1;
4> allocate channel c2 device type disk format '/soft/backup/%U' connect sys/manager@rac2;
5> backup database plus archivelog delete all input;
6> }
RMAN> run
2> {
3> allocate channel c1 device type disk format '/soft/backup/CON_%U';
4> backup current controlfile for standby;
5> }
执行成功。

恢复：
[oracle@node3 dbs]$ /u01/app/oracle/product/102/bin/rman target / auxiliary sys/manager@standby
Recovery Manager: Release 10.2.0.3.0 - Production on Mon Oct 20 17:39:03 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: RAC (DBID=2256083078)
connected to auxiliary database: RAC (not mounted)
RMAN> run
2> {
3> allocate channel c1 device type disk format '/soft/backup/%U' connect sys/manager@rac1;
4> allocate channel c2 device type disk format '/soft/backup/%U' connect sys/manager@rac2;
5> allocate auxiliary channel ac1 device type disk format '/soft/backup/%U';
6> allocate auxiliary channel ac2 device type disk format '/soft/backup/%U';
7> duplicate target database for standby;
8> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: sid=116 instance=rac1 devtype=DISK
allocated channel: c2
channel c2: sid=119 instance=rac2 devtype=DISK
allocated channel: ac1
channel ac1: sid=155 devtype=DISK
allocated channel: ac2
channel ac2: sid=156 devtype=DISK
Starting Duplicate Db at 2008-10-21 11:13:44
contents of Memory Script:
{
restore clone standby controlfile;
sql clone 'alter database mount standby database';
}
executing Memory Script
Starting restore at 2008-10-21 11:13:45
channel ac1: starting datafile backupset restore
channel ac1: restoring control file
channel ac1: reading from backup piece /soft/backup/CON_30jtmm0m_1_1
ORA-19870: error reading backup piece /soft/backup/CON_30jtmm0m_1_1
ORA-19505: failed to identify file "/soft/backup/CON_30jtmm0m_1_1"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
failover to previous backup
channel ac1: restoring control file
ORA-19625: error identifying file /soft/standby.ctl
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-19600: input file is control file (/soft/standby.ctl)
ORA-19601: output file is control file (/u02/standby/control01.ctl)
failover to previous backup
released channel: c1
released channel: c2
released channel: ac1
released channel: ac2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 10/21/2008 11:13:47
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06024: no backup or copy of the control file found to restore

之前相同的rman操作都通过了呢，不知道这次清理backup文件的时候动了哪根弦：（
说是找不到controlfile,怎么可能呢？我明明看到rac节点路径"/soft/backup/下有这个文件的。

在目标数据库，也就是AUXILIARY实例数据库的服务器上是否将备份集手工拷贝过来？