oracle rac备份和还原,oracle rac备份恢复

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号？