事情发生原因:在RAC+RAW+ARCHIVE环境中,新增了几个RAW,但只在一边修改了宿主,结果就发生了如下错误:
ORA-01157: cannot identify/lock data file 129 - see DBWR trace file
ORA-01110: data file 129: '/dev/roradata126'
解决方法如下:
1,先将文件离线
2,RECOVER该文件
3,ONLINE 该文件
4,设定该文件大小
具体操作如下:
alter database datafile '/dev/roradata126' offline ;
alter database recover datafile '/dev/roradata126';
ALTER DATABASE DATAFILE '/dev/roradata126' ONLINE;
ALTER DATABASE DATAFILE '/dev/roradata126' RESIZE 2042M;