事情发生原因:在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;
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;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/38006/viewspace-733232/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/38006/viewspace-733232/