rename datafile时报错ora-01511,ora-01121,ora-01110
现象：
实例启动到mount之后，rename datafile时报错ora-01511,ora-01121,ora-01110
sql>
sql> alter database rename file '+data/rac/datafile/system.416.833384105' to '+testdg/rac/datafile/system.dbf';
alter database rename file '+data/rac/datafile/system.416.833384105' to '+testdg/rac/datafile/system.dbf'
*
error at line 1:
ora-01511: error in renaming log/data files
ora-01121: cannot rename database file 1 - file is in use or recovery
ora-01110: data file 1: '+data/rac/datafile/system.416.833384105'
分析：
只所以出现这种情况因为我的db是rac环境，另一个节点是open状态，导致出现上面报错。
解决方案：
关闭另一个节点的实例。
[oracle@saprac4 ~]$ dba
sql*plus: release 11.1.0.6.0 - production on thu dec 5 16:15:06 2013
copyright (c) 1982, 2007, oracle. all rights reserved.
connected to:
oracle database 11g enterprise edition release 11.1.0.6.0 - 64bit production
with the partitioning, real application clusters, olap, data mining
and real application testing options
sql> shutdown immediate
database closed.
database dismounted.
oracle instance shut down.
sql>
sql>
再在节点1上执行rename datafile。
sql> alter database rename file '+data/rac/datafile/system.416.833384105' to '+testdg/rac/datafile/system.dbf';
database altered.
sql>
sql>
sql> alter database rename file '+data/rac/datafile/sysaux.417.833384107' to '+testdg/rac/datafile/sysaux.dbf';
alter database rename file '+data/rac/datafile/undotbs1.418.833384107' to '+testdg/rac/datafile/undotbs1.dbf';
alter database rename file '+data/rac/datafile/users.419.833384109' to '+testdg/rac/datafile/users.dbf';
alter database rename file '+data/rac/datafile/undotbs2.424.833384491' to '+testdg/rac/datafile/undotbs2.dbf';
database altered.
sql>
database altered.
sql>
database altered.
sql>
database altered.
sql>
sql>
sql>
sql> alter database open;
alter database open
*
error at line 1:
ora-01113: file 1 needs media recovery
ora-01110: data file 1: '+testdg/rac/datafile/system.dbf'
sql> recover database;
media recovery complete.
sql> alter database open;
database altered.
sql> select name from v$datafile;
name
--------------------------------------------------------------------------------
+testdg/rac/datafile/system.dbf
+testdg/rac/datafile/sysaux.dbf
+testdg/rac/datafile/undotbs1.dbf
+testdg/rac/datafile/users.dbf
+testdg/rac/datafile/undotbs2.dbf
sql>
相关阅读：
ora-01172、ora-01151错误处理
ora-00600 [2662]错误解决
ora-01078 和 lrm-00109 报错解决方法
ora-00471 处理方法笔记
ora-00314,redolog 损坏，或丢失处理方法
ora-00257 归档日志过大导致无法存储的解决办法
，