log131.rdo' 、ora-27040:file create error.unable to create file

#解决方法：

在sqlplus 上

desc v$log;

select group,member from v$logfile;

筛选出结果

#GUOUP# MEMEBER

131 /redonew/redo131.log

132 /redonew/redo132.log

......

146 /redonew/redo146.log

修改成如下之后，在sqlplus上运行

alter database rename file '/redonew/redo131.log' to '/oradata/redo131.log';

alter database rename file '/redonew/redo132.log' to '/oradata/redo132.log';

.......

alter database rename file '/redonew/redo146.log' to '/oradata/redo146.log';

在alter database open resetlogs;

end

posted on 2016-01-05 15:26 rondon 阅读(2005) 评论(0) 编辑收藏举报