oracle rac NFS 备份现在恢复到 oracle rac asm 提示这个错误,怎么处理呢?
1、 恢复控制文件,没有 恢复SPFILE
从备份文件中没有找到这些数据文件的备份,检查一下备份的完整性,可用性。
评论
有用 0因为您的第一个问题里面,没有完整的restore命令的截图,所以还不能确认是不是restore命令确实在尝试回复您后面截图中备份完毕的数据库,或者是不是在读取正确的备份集。
能否给出包含以下命令的截图:
report need backup;
list backup summary;
restore的完整命令
我们再来看看有什么可能的报错原因。
评论
有用 0
catalog start with '/home/oracle/bakl/'
restore controlfile from '/home/oracle/bak/cntrl_20190301_242887_1_1'
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/onbisp/datafile/system01.dbf';
set newname for datafile 2 to '+data/onbisp/datafile/sysaux01.dbf';
set newname for datafile 3 to '+data/onbisp/datafile/undotbs01.dbf';
set newname for datafile 4 to '+data/onbisp/datafile/users01.dbf';
set newname for datafile 5 to '+data/onbisp/datafile/COGNOS.dbf';
set newname for datafile 6 to '+data/onbisp/datafile/DATASTAGE.dbf';
set newname for datafile 7 to '+data/onbisp/datafile/WEBSPHERE.dbf';
set newname for datafile 8 to '+data/onbisp/datafile/onbisp_ODS_TBS.dbf';
set newname for datafile 9 to '+data/onbisp/datafile/onbisp_DW_TBS_01.dbf';
set newname for datafile 10 to '+data/onbisp/datafile/onbisp_ODS_IDX_TBS.dbf';
set newname for datafile 11 to '+data/onbisp/datafile/DW_IDX_TBS_01.dbf';
set newname for datafile 12 to '+data/onbisp/datafile/DM_TBS_01.dbf';
set newname for datafile 13 to '+data/onbisp/datafile/DM_IDX_TBS_01.dbf';
set newname for datafile 14 to '+data/onbisp/datafile/onbisp_DMA_TBS_01.dbf';
set newname for datafile 15 to '+data/onbisp/datafile/DMA_IDX_TBS_01.dbf';
set newname for datafile 16 to '+data/onbisp/datafile/system02.dbf';
set newname for datafile 17 to '+data/onbisp/datafile/sysaux02.dbf';
set newname for datafile 18 to '+data/onbisp/datafile/DM_TBS_02.dbf';
set newname for datafile 19 to '+data/onbisp/datafile/DM_IDX_TBS_02.dbf';
set newname for datafile 20 to '+data/onbisp/datafile/coglogdb.dbf';
set newname for datafile 21 to '+data/onbisp/datafile/coglogdb_02.dbf';
set newname for datafile 22 to '+data/onbisp/datafile/DATASTAGE_02.dbf';
set newname for datafile 23 to '+data/onbisp/datafile/DM_TBS_03.dbf';
set newname for datafile 24 to '+data/onbisp/datafile/DM_IDX_TBS_03.dbf';
set newname for datafile 25 to '+data/onbisp/datafile/DM_TBS_04.dbf';
set newname for datafile 26 to '+data/onbisp/datafile/DW_TBS_02.dbf';
set newname for datafile 27 to '+data/onbisp/datafile/DW_IDX_TBS_02.dbf';
set newname for datafile 28 to '+data/onbisp/datafile/undotbs02.dbf';
set newname for datafile 29 to '+data/onbisp/datafile/DM_TBS_05.dbf';
set newname for tempfile 1 to '+data/onbisp/datafile/temp03.dbf';
set newname for tempfile 2 to '+data/onbisp/datafile/temp02.dbf';
set newname for tempfile 3 to '+data/onbisp/datafile/dssw_temp.dbf';
set newname for tempfile 4 to '+data/onbisp/datafile/dssw1_temp.dbf';
set until scn=10274067114602;
restore database validate;
switch tempfile all;
switch datafile all;
recover database;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
}
评论
有用 0显示你的备份机都在带库里面(SBT_TAPE),但是你restore的时候指定的channel都是disk,所以RMAN找不到需要的备份集。
请看一下backup时候指定channel的语句,需要使用同样的channel恢复。
评论
有用 0
墨值悬赏

