先switch再recover

另外请在个人中心完善下邮箱，专家回复后会有邮件通知。

open resetlogs还是不行

如果是不完全恢复，要设置恢复点如：

set until sequence XXX;
recover database;

或者直接until cancel：

recover database using backup controlfile until cancel;

 启动还是有问题。ORACLE RAC还有没有 办 法处理呢？还是得重新还原呢

这是由于你使用了_allow_resetlogs_corruption强制open数据库造成的，ora-600[2662]很容易处理，推进scn就行了

推进scn就行了，什么意思呢怎么处理呢 

现在发现listen也不一样了，有没有参考ORACLE RAC数据恢复的呢谢谢 

异机恢复的话，要手工设置local_listener参数，然后把DB注册到集群中。

catalog start with '/home/oracle/bak/'

 run {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
allocate channel c5 device type disk;
set newname for datafile 1        to  '+data/swbi/datafile/system01.dbf';
set newname for datafile 2  to  '+data/swbi/datafile/sysaux01.dbf';
set newname for datafile 3  to  '+data/swbi/datafile/undotbs01.dbf';
set newname for datafile 4  to  '+data/swbi/datafile/users01.dbf';
set newname for datafile 5  to  '+data/swbi/datafile/COGNOS.dbf';
set newname for datafile 6  to  '+data/swbi/datafile/DATASTAGE.dbf';
set newname for datafile 7  to  '+data/swbi/datafile/WEBSPHERE.dbf';
set newname for datafile 8  to  '+data/swbi/datafile/SWBI_ODS_TBS.dbf';
set newname for datafile 9  to  '+data/swbi/datafile/SWBI_DW_TBS_01.dbf';
set newname for datafile 10  to  '+data/swbi/datafile/SWBI_ODS_IDX_TBS.dbf';
set newname for datafile 11  to  '+data/swbi/datafile/DW_IDX_TBS_01.dbf';
set newname for datafile 12  to  '+data/swbi/datafile/DM_TBS_01.dbf';
set newname for datafile 13  to  '+data/swbi/datafile/DM_IDX_TBS_01.dbf';
set newname for datafile 14  to  '+data/swbi/datafile/SWBI_DMA_TBS_01.dbf';
set newname for datafile 15  to  '+data/swbi/datafile/DMA_IDX_TBS_01.dbf';
set newname for datafile 16  to  '+data/swbi/datafile/system02.dbf';
set newname for datafile 17  to  '+data/swbi/datafile/sysaux02.dbf';
set newname for datafile 18  to  '+data/swbi/datafile/DM_TBS_02.dbf';
set newname for datafile 19  to  '+data/swbi/datafile/DM_IDX_TBS_02.dbf';
set newname for datafile 20  to  '+data/swbi/datafile/coglogdb.dbf';
set newname for datafile 21  to  '+data/swbi/datafile/coglogdb_02.dbf';
set newname for datafile 22  to  '+data/swbi/datafile/DATASTAGE_02.dbf';
set newname for datafile 23  to  '+data/swbi/datafile/DM_TBS_03.dbf';
set newname for datafile 24  to  '+data/swbi/datafile/DM_IDX_TBS_03.dbf';
set newname for datafile 25  to  '+data/swbi/datafile/DM_TBS_04.dbf';
set newname for datafile 26  to  '+data/swbi/datafile/DW_TBS_02.dbf';
set newname for datafile 27  to  '+data/swbi/datafile/DW_IDX_TBS_02.dbf';
set newname for datafile 28  to  '+data/swbi/datafile/undotbs02.dbf';
set newname for datafile 29  to  '+data/swbi/datafile/DM_TBS_05.dbf';
set newname for datafile 1  to  '+data/swbi/datafile/temp03.dbf';                 
set newname for datafile 2  to  '+data/swbi/datafile/temp02.dbf';                 
set newname for datafile 3 to  '+data/swbi/datafile/dssw_temp.dbf';
set newname for datafile 4 to  '+data/swbi/datafile/dssw1_temp.dbf';

set until sequence 16326;
restore database;
switch tempfile all;
switch datafile all;
recover database;

release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;

}

这样恢复有问题吗？我现在异机恢复，能从备份集查看恢复到哪个SCN号？

脚本没问题的。

关于SCN，你可以备份之前查下数据库的SCN并记录下来，或者是list backup查询备份时的SCN号，再恢复时指定SCN号。